Skip Banners
Animal and Plant Health Inspection Service logo Fruits and Vegetables Import Requirements (FAVIR)
Effective October 1, 2022 the Fruits and Vegetables Import Requirements (FAVIR) database has been replaced by the Agricultural Commodity Import Requirements database at https://acir.aphis.usda.gov/s/


Print image
Commodity Import Report (CIR)

Woodruff (Above-ground parts) from Guam into CNMI
The CIR contains current import regulation information for the selected Commodity Import (a specific commodity approved from a designated country, or region, into one or more designated ports). A flag ( Access Restricted to APHIS/CBP ) indicates information that is intended for and available to an APHIS/CBP audience only.
Galium odoratum Commodity Summary Guide Page Country Summary

Import Requirements
1 Admissible Plant Parts: Above-ground parts
2 Admissible Ports: CNMI
3 Import Permit Required: An Import Permit is required. To obtain a permit, go to APHIS eFile.
4 Subject to Inspection: This commodity is subject to inspection at the port of entry and all general requirements of 7 CFR 319.56-3.
Commodity Information
5 For additional commodity information and images, visit https://npgsweb.ars-grin.gov/gringlobal/taxonomydetail.aspx?id=103279  
Page ID: CIRReportP
Skip Footer

 


Debugging Information
ColdFusion Server Enterprise 2021,0,12,330257
Template /manual/index.cfm
Time Stamp 28-Feb-24 10:00 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.100.82.26
Host Name 10.100.82.26


Execution Time

Total Time Avg Time Count Template
34 ms 34 ms 1 CFC[ D:/Inetpub/wwwroot/Manual/Application.cfc | onRequestStart(/manual/index.cfm) ] from D:/Inetpub/wwwroot/Manual/Application.cfc
24 ms 24 ms 1 CFC[ D:/Inetpub/wwwroot/Manual/Application.cfc | onRequest(/manual/index.cfm) ] from D:/Inetpub/wwwroot/Manual/Application.cfc
23 ms 23 ms 1 CFC[ D:/CFMX-Components/Controller/RequestManager.cfc | ListenRequests() ] from D:/CFMX-Components/Controller/RequestManager.cfc
23 ms 23 ms 1 D:/Inetpub/wwwroot/Manual/index.cfm
20 ms 20 ms 1 D:/CFMX-Components/Manual/parsed/parsed.cirReportP.cfm
16 ms 16 ms 1 CFC[ D:/CFMX-Components/Manual/Objects/searchManager.cfc | cirReport(EPERMITS_OBJ_PATH = epermits.objects, LOGOFF_EAUTH = https://www.eauth.usda.gov/Logout/logoff.asp, HTTP_PRE = https, ACCESS_ERROR_TEMPLATE = AccessDenied.htm, DEFAULT_REQUEST = goHome, ROOT_PATH = /manual, PERMITTED_ID = 10601693, PARSED_PATH = /manual/parsed, ERROR_EMAIL_FROM = epermits.automated.message@aphis.usda.gov, JS_PATH = /manual/js, REQUEST_NAME = action, CSS_PATH = /manual/css, EXCEPTION_ERROR_TEMPLATE = MANUALSiteError.htm, un = PUBLICFV, pwd = PUBLICFV1, URL_PRECEDENCE = 5000, DSN = MANUAL_RESTRICT, CIMG_PATH = /manual/commod_images, changePassword = 0, ERROR_SUBJECT = FAVIR Error(prod), VERSION_TYPE = PROD, DSN_RESTRICT = MANUAL_RESTRICT, MANUAL_EMAIL = epermits.automated.message@aphis.usda.gov, HTTP_HOST = epermits.aphis.usda.gov, OBJ_PATH = manual.objects, action = cirReportP, CIMG_WRITE_PATH = D:/inetpub/wwwroot/Manual/commod_images, IMG_PATH = /manual/images, ERROR_EMAIL_TO = Eapps.Sysmsg@perspecta.com) ] from D:/CFMX-Components/Manual/Objects/searchManager.cfc
14 ms 14 ms 1 CFC[ D:/CFMX-Components/Manual/Objects/security/SecurityCheck.cfc | UserAccessCheck(itemActive = 0, un = PUBLICFV, pwd = PUBLICFV1, changePassword = 0) ] from D:/CFMX-Components/Manual/Objects/security/SecurityCheck.cfc
8 ms 8 ms 1 CFC[ D:/CFMX-Components/Controller/ControllerManager.cfc | init(cirReportP) ] from D:/CFMX-Components/Controller/ControllerManager.cfc
4 ms 4 ms 1 CFC[ D:/CFMX-Components/Manual/Objects/admin/AdminUserRoleManager.cfc | ep_getUserRoles(APP_ADMIN = 0) ] from D:/CFMX-Components/Manual/Objects/admin/AdminUserRoleManager.cfc
1 ms 1 ms 1 CFC[ D:/CFMX-Components/EPERMITS/OBJECTS/RequestLogger.cfc | logRequest(Listen) ] from D:/CFMX-Components/EPERMITS/OBJECTS/RequestLogger.cfc
1 ms 1 ms 1 CFC[ D:/CFMX-Components/EPERMITS/OBJECTS/RequestLogger.cfc | logRequest(Resolve) ] from D:/CFMX-Components/EPERMITS/OBJECTS/RequestLogger.cfc
1 ms 1 ms 1 CFC[ D:/CFMX-Components/Manual/Objects/SideBarManager.cfc | init(cirReportP, 0) ] from D:/CFMX-Components/Manual/Objects/SideBarManager.cfc
1 ms 1 ms 1 D:/CFMX-Components/Manual/Views/pub/dspCIRReportP.cfm
0 ms 0 ms 2 CFC[ D:/CFMX-Components/Controller/ControllerManager.cfc | getParsedFileExist() ] from D:/CFMX-Components/Controller/ControllerManager.cfc
0 ms 0 ms 1 CFC[ D:/CFMX-Components/Controller/ControllerManager.cfc | getParsedFileName() ] from D:/CFMX-Components/Controller/ControllerManager.cfc
0 ms 0 ms 1 CFC[ D:/CFMX-Components/Controller/ControllerManager.cfc | getRequestManager() ] from D:/CFMX-Components/Controller/ControllerManager.cfc
0 ms 0 ms 1 CFC[ D:/CFMX-Components/Controller/RequestManager.cfc | init(CFC: Controller.ControllerManager) ] from D:/CFMX-Components/Controller/RequestManager.cfc
0 ms 0 ms 2 CFC[ D:/CFMX-Components/EPERMITS/OBJECTS/RequestLogger.cfc | init() ] from D:/CFMX-Components/EPERMITS/OBJECTS/RequestLogger.cfc
0 ms 0 ms 1 CFC[ D:/CFMX-Components/Manual/Objects/RootBaseUtil.cfc | constructNoHeaderFooter(0) ] from D:/CFMX-Components/Manual/Objects/RootBaseUtil.cfc
0 ms 0 ms 1 CFC[ D:/CFMX-Components/Manual/Objects/RootBaseUtil.cfc | lockReadSession() ] from D:/CFMX-Components/Manual/Objects/RootBaseUtil.cfc
0 ms 0 ms 1 CFC[ D:/CFMX-Components/Manual/Objects/RootBaseUtil.cfc | lockSetApplication() ] from D:/CFMX-Components/Manual/Objects/RootBaseUtil.cfc
0 ms 0 ms 1 CFC[ D:/CFMX-Components/Manual/Objects/RootBaseUtil.cfc | lockSetSession() ] from D:/CFMX-Components/Manual/Objects/RootBaseUtil.cfc
0 ms 0 ms 1 CFC[ D:/CFMX-Components/Manual/Objects/security/EAuthManager.cfc | init() ] from D:/CFMX-Components/Manual/Objects/security/EAuthManager.cfc
0 ms 0 ms 1 CFC[ D:/CFMX-Components/Manual/Objects/security/SecurityCheck.cfc | setSecuritySession() ] from D:/CFMX-Components/Manual/Objects/security/SecurityCheck.cfc
0 ms 0 ms 1 CFC[ D:/Inetpub/wwwroot/Manual/Application.cfc | onRequestEnd(/manual/index.cfm) ] from D:/Inetpub/wwwroot/Manual/Application.cfc
0 ms 0 ms 1 CFC[ D:/Inetpub/wwwroot/Manual/Application.cfc | onSessionStart() ] from D:/Inetpub/wwwroot/Manual/Application.cfc
0 ms 0 ms 1 D:/CFMX-Components/Manual/Views/_footer.cfm
0 ms 0 ms 1 D:/CFMX-Components/Manual/Views/_header.cfm
0 ms 0 ms 1 D:/CFMX-Components/Manual/Views/setMenuActive.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
60 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

checkDatabase (Datasource=MANUAL_RESTRICT, Time=0ms, Records=0) in D:\CFMX-Components\Manual\Objects\RootBaseUtil.cfc @ 22:00:23.023
SELECT TABLE_NAME
			FROM USER_TABLES
			WHERE 0 = 1
checkUser (Datasource=MANUAL_RESTRICT, Time=4ms, Records=1) in D:\CFMX-Components\Manual\Objects\security\SecurityCheck.cfc @ 22:00:23.023
SELECT U.SYS_USER_ID,U.LOGIN_ATTEMPT,U.LAST_LOGIN_DATE,U.INACTIVE,U.LOCKOUT_EXP_DATE,U.LOCKED,U.PASSWORD_UPDATE_DATE,U.SELECT_AGENT_FLAG,U.EAUTH_LEVEL
				  FROM EP_SYS_USERS 	U
					  ,EP_SYS_USER_ROLE J
					  ,EP_SYS_ROLES 	R
				 WHERE U.USERNAME	 = ?
				   AND U.PASSWORD	 = ?
				   AND U.ARCHIVE	 = ?
				   AND U.SYS_USER_ID = J.SYS_USER_ID
				   AND J.SYS_ROLE_ID = R.SYS_ROLE_ID
				   AND R.CHAR_KEY IN (SELECT PARAM_VALUE FROM EP_SYS_CONFIG_PARAMS WHERE PARAM_NAME = 'Q56ROLES')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = PUBLICFV
Parameter #2(CF_SQL_VARCHAR) = agqx|uqn
Parameter #3(CF_SQL_INTEGER) = 0

updateLoginDate (Datasource=MANUAL_RESTRICT, Time=3ms, Records=1) in D:\CFMX-Components\Manual\Objects\security\SecurityCheck.cfc @ 22:00:23.023
UPDATE EP_SYS_USERS SET
						 LAST_LOGIN_DATE = SYSDATE
						,LOGIN_ATTEMPT = ?
						,LOCKOUT_EXP_DATE = ''
						,IP_ADDRESS = ?
					WHERE SYS_USER_ID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_VARCHAR) = 10.100.82.26
Parameter #3(CF_SQL_NUMERIC) = 14763

qryDefaultRole (Datasource=MANUAL_RESTRICT, Time=1ms, Records=1) in D:\CFMX-Components\Manual\Objects\security\SecurityCheck.cfc @ 22:00:23.023
SELECT ESR.SYS_ROLE_ID, ESR.CHAR_KEY, ESR.PO_ADMIN, ESR.APP_ADMIN, ESR.PROGRAM_OFFICE_ID
					   FROM EP_SYS_ROLES ESR, EP_SYS_USER_ROLE ESUR
					  WHERE ESUR.SYS_USER_ID  = ?
						AND ESUR.DEFAULT_ROLE = ?
						AND ESR.SYS_ROLE_ID   = ESUR.SYS_ROLE_ID
						AND ESR.CHAR_KEY IN (SELECT PARAM_VALUE FROM EP_SYS_CONFIG_PARAMS WHERE PARAM_NAME = 'Q56ROLES')
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 14763
Parameter #2(CF_SQL_INTEGER) = 1

qryOtherRoles (Datasource=MANUAL_RESTRICT, Time=1ms, Records=1) in D:\CFMX-Components\Manual\Objects\security\SecurityCheck.cfc @ 22:00:23.023
SELECT ESR.SYS_ROLE_ID, ESR.CHAR_KEY
					FROM EP_SYS_ROLES ESR, EP_SYS_USER_ROLE ESUR
					WHERE ESUR.SYS_USER_ID = ?
						AND ESUR.DEFAULT_ROLE = ?
						AND ESR.SYS_ROLE_ID   = ESUR.SYS_ROLE_ID
						AND ESR.SYS_ROLE_ID  != '5555555'
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 14763
Parameter #2(CF_SQL_INTEGER) = 0

qryQ56User (Datasource=MANUAL_RESTRICT, Time=2ms, Records=1) in D:\CFMX-Components\Manual\Objects\admin\AdminUserRoleManager.cfc @ 22:00:23.023
SELECT ESR.CHAR_KEY
			FROM EP_SYS_ROLES ESR, EP_SYS_USER_ROLE ESUR
			WHERE ESUR.SYS_USER_ID = ?
			   AND ESR.SYS_ROLE_ID = ESUR.SYS_ROLE_ID
				AND ESR.CHAR_KEY IN (SELECT PARAM_VALUE FROM EP_SYS_CONFIG_PARAMS WHERE PARAM_NAME = 'Q56ROLES')
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 14763

qryUserRoles (Datasource=MANUAL_RESTRICT, Time=1ms, Records=1) in D:\CFMX-Components\Manual\Objects\admin\AdminUserRoleManager.cfc @ 22:00:23.023
SELECT ESR.SYS_ROLE_ID, ESR.PROGRAM_OFFICE_ID, ESR.NAME, ESR.CHAR_KEY, ESR.APP_ADMIN, ESR.PO_ADMIN,
				ERPO.SHORT_NAME AS PO_SHORT_NAME, 'B' AS SORT_ORDER
			FROM EP_SYS_ROLES ESR, EP_SYS_USER_ROLE ESUR, EP_REF_PROGRAM_OFFICE ERPO
			WHERE ESUR.SYS_USER_ID = ?
				AND ESR.SYS_ROLE_ID = ESUR.SYS_ROLE_ID
				AND ERPO.PROGRAM_OFFICE_ID = ESR.PROGRAM_OFFICE_ID
				AND ESR.CHAR_KEY IN (SELECT PARAM_VALUE FROM EP_SYS_CONFIG_PARAMS WHERE PARAM_NAME = 'Q56ROLES')

			UNION

			SELECT ESR.SYS_ROLE_ID, ESR.PROGRAM_OFFICE_ID, ESR.NAME, ESR.CHAR_KEY, ESR.APP_ADMIN, ESR.PO_ADMIN,
				'N/A' AS PO_SHORT_NAME, 'Z' AS SORT_ORDER
			FROM EP_SYS_ROLES ESR, EP_SYS_USER_ROLE ESUR
			WHERE ESUR.SYS_USER_ID = ?
				AND ESR.PROGRAM_OFFICE_ID IS NULL
				AND ESR.SYS_ROLE_ID = ESUR.SYS_ROLE_ID
				AND ESR.CHAR_KEY IN (SELECT PARAM_VALUE FROM EP_SYS_CONFIG_PARAMS WHERE PARAM_NAME = 'Q56ROLES')
			

			ORDER BY 8, 7, 3
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 14763
Parameter #2(CF_SQL_NUMERIC) = 14763

variables.navigationData (Datasource=MANUAL_OPEN, Time=1ms, Records=6) in D:\CFMX-Components\Manual\Objects\SideBarManager.cfc @ 22:00:23.023
SELECT NAV_CHAR_KEY
				  ,NAME
				  ,HREF_TITLE
				  ,REQUEST_KEY AS HREF_REQUEST_NAME
				  ,URL_STRING
				  ,TARGET_URL
			  FROM FV_NAVIGATION
			 WHERE DISPLAY		= ?
			   AND NAV_CHAR_KEY = (SELECT CHAR_KEY FROM EP_SYS_ROLES WHERE SYS_ROLE_ID = ? )
			 ORDER BY SORT_ORDER
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 1
Parameter #2(CF_SQL_NUMERIC) = 66

qryRecord (Datasource=MANUAL_OPEN, Time=1ms, Records=2) in D:\CFMX-Components\Manual\Objects\RootBaseUtil.cfc @ 22:00:23.023
SELECT R.CHAR_KEY
			FROM EP_SYS_USER_ROLE U, EP_SYS_ROLES R
			WHERE U.SYS_ROLE_ID = R.SYS_ROLE_ID
				AND U.SYS_USER_ID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 14763

qPMTD (Datasource=MANUAL_OPEN, Time=2ms, Records=1) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT DISTINCT
                       P.PERMITTED_ID
                      ,P.COMMOD_ID
                      ,R.REGION_ID
                      ,R.REGION_NAME
                      ,U.PORTGROUP_NAME
                 FROM  FV_PERMITTED             P
                      ,FV_PORTGROUP             U
                      ,FV_REGION                R
                WHERE  P.PERMITTED_ID           = ?
                  AND  P.ACTIVE                 = ?
                  AND  P.REGION_ID              = R.REGION_ID
                  AND  R.ACTIVE                 = ?
                  AND  R.SEARCHABLE             = ?
                  AND  P.PORTGROUP_ID           = U.PORTGROUP_ID
                ORDER  BY R.REGION_NAME
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 10601693
Parameter #2(CF_SQL_NUMERIC) = 1
Parameter #3(CF_SQL_NUMERIC) = 1
Parameter #4(CF_SQL_NUMERIC) = 1

qParts (Datasource=MANUAL_OPEN, Time=1ms, Records=1) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT P.PART_NAME
             FROM  FV_REF_PLANTPART         P
                  ,FV_PERMITTED_PLANTPART   J
             WHERE J.PART_ID                = P.PART_ID
              
               AND J.PERMITTED_ID           = ? 
               AND P.ACTIVE                 = ?
             ORDER BY P.PART_NAME
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 10601693
Parameter #2(CF_SQL_NUMERIC) = 1

qCommod (Datasource=MANUAL_OPEN, Time=1ms, Records=1) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT C.COMMOD_ID
                  ,C.COMMODITY_NAME
                  ,C.COMMODITY_NAME_HTML
                  ,G.GENUS_NAME || ' ' || S.SPECIES || ' ' || S.VARIETY || ' ' || S.SUBSPECIES AS SCI_NAME
                  ,C.COMMODITY_GRIN_URL
             FROM  FV_COMMODITY             C
                  ,FV_SCIENTIFIC_NAME       S
                  ,FV_REF_GENUS             G
            WHERE  C.ACTIVE                 = ?
              AND  C.COMMOD_ID              = ?
              AND  C.COMMOD_ID              = S.COMMOD_ID(+)
              AND  S.GENUS_ID               = G.GENUS_ID(+)
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 1
Parameter #2(CF_SQL_NUMERIC) = 141

qSciName (Datasource=MANUAL_OPEN, Time=0ms, Records=1) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT  S1.SORT_ORDER
                  ,'<i>' || G1.GENUS_NAME || ' ' || S1.SPECIES || ' ' || S1.VARIETY || ' ' || S1.SUBSPECIES  || '</i> x <i>' || G2.GENUS_NAME || ' ' || S2.SPECIES || ' ' || S2.VARIETY ||  ' ' || S2.SUBSPECIES  || '</i>' AS SCI_NAME
             FROM  FV_SCIENTIFIC_NAME    S1
                  ,FV_SCIENTIFIC_NAME    S2
                  ,FV_HYBRID             H
                  ,FV_REF_GENUS          G1
                  ,FV_REF_GENUS          G2
            WHERE  S1.COMMOD_ID          = ?
              AND  S1.HYBRID_IND         = ?
              AND  S2.HYBRID_IND         = ?
              AND  S1.SCIENTIFIC_NAME_ID = H.SCIENTIFIC_NAME_ID_A
              AND  S2.SCIENTIFIC_NAME_ID = H.SCIENTIFIC_NAME_ID_B
              AND  S1.GENUS_ID           = G1.GENUS_ID
              AND  S2.GENUS_ID           = G2.GENUS_ID
         UNION
           SELECT  S2.SORT_ORDER
                  ,'<i>' || G2.GENUS_NAME || ' ' || S2.SPECIES || ' ' || S2.VARIETY ||  ' ' || S2.SUBSPECIES || '</i> x <i>' || G1.GENUS_NAME || ' ' || S1.SPECIES || ' ' || S1.VARIETY || ' ' || S1.SUBSPECIES || '</i>' AS SCI_NAME
             FROM  FV_SCIENTIFIC_NAME    S1
                  ,FV_SCIENTIFIC_NAME    S2
                  ,FV_HYBRID             H
                  ,FV_REF_GENUS          G1
                  ,FV_REF_GENUS          G2
            WHERE  S2.COMMOD_ID          = ?
              AND  S1.HYBRID_IND         = ?
              AND  S2.HYBRID_IND         = ?
              AND  S2.SCIENTIFIC_NAME_ID = H.SCIENTIFIC_NAME_ID_A
              AND  S1.SCIENTIFIC_NAME_ID = H.SCIENTIFIC_NAME_ID_B
              AND  S1.GENUS_ID           = G1.GENUS_ID
              AND  S2.GENUS_ID           = G2.GENUS_ID
         UNION
            SELECT S.SORT_ORDER, G.GENUS_NAME || ' ' || S.SPECIES || ' ' || S.VARIETY || ' ' || S.SUBSPECIES AS SCI_NAME
              FROM FV_SCIENTIFIC_NAME S
                  ,FV_REF_GENUS       G
             WHERE S.COMMOD_ID        = ?
               AND S.GENUS_ID         = G.GENUS_ID
               AND S.HYBRID_IND       = ?
             ORDER BY 1, 2
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 141
Parameter #2(CF_SQL_NUMERIC) = 1
Parameter #3(CF_SQL_NUMERIC) = 1
Parameter #4(CF_SQL_NUMERIC) = 141
Parameter #5(CF_SQL_NUMERIC) = 1
Parameter #6(CF_SQL_NUMERIC) = 1
Parameter #7(CF_SQL_NUMERIC) = 141
Parameter #8(CF_SQL_NUMERIC) = 0

qAlert (Datasource=MANUAL_OPEN, Time=0ms, Records=0) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT DISTINCT
                   A.ALERT_ID
                  ,A.ALERT_SHORT_TITLE
                  ,A.EXPIRATION_DATE
                  ,A.RESTRICTED_IND
                  ,A.ISSUED_DATE
                  ,A.ALERT_DESC
                  ,A.ATTACH_ID
                  ,A.HOME_DISPLAY_IND
                  ,A.MODIFIED_DATE
              FROM FV_ALERT               A
                  ,FV_ALERT_RELATIONSHIPS R
             WHERE R.ALERT_ID             = A.ALERT_ID
               AND ( (R.COMMOD_ID         = ?
                      AND
                      R.REGION_ID         = ?
                     )
                    OR
                     (R.COMMOD_ID         = ?
                      AND
                      R.REGION_ID      IS NULL
                     )
                    OR
                     (R.COMMOD_ID      IS NULL
                      AND
                      R.REGION_ID         = ?
                     )
                   )
             
               AND (A.EXPIRATION_DATE     > (sysdate - 1) OR A.EXPIRATION_DATE IS NULL )
             ORDER BY ISSUED_DATE
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 141
Parameter #2(CF_SQL_NUMERIC) = 254
Parameter #3(CF_SQL_NUMERIC) = 141
Parameter #4(CF_SQL_NUMERIC) = 254

qImp (Datasource=MANUAL_OPEN, Time=2ms, Records=4) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT T.REQUIREMENT_TYPE_NAME
                  ,T.CHAR_KEY
                  ,T.REQUIREMENT_TYPE_ID
                  ,D.REQ_DESC
                  ,R.IMPORT_REQ_ID
                  ,R.IMPORT_REQ_ID_PARENT
                  ,R.SORT_REQ
              FROM FV_PERMITTED            P
                  ,FV_IMPORT_REQUIREMENT   R
                  ,FV_REF_REQUIREMENT_TYPE T
                  ,FV_REQUIREMENT_DESC     D
             WHERE P.PERMITTED_ID          = ?
               AND P.ACTIVE                = 1
               AND R.ACTIVE                = 1
               AND P.PERMITTED_ID          = R.PERMITTED_ID
               AND R.REQUIREMENT_TYPE_ID   = T.REQUIREMENT_TYPE_ID
               AND R.REQ_DESC_ID           = D.REQ_DESC_ID(+)
               AND T.CHAR_KEY         NOT IN ('INSO','EYKQ')
               ORDER BY R.SORT_REQ, R.IMPORT_REQ_ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 10601693

qPP (Datasource=MANUAL_OPEN, Time=1ms, Records=1) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT RP.PART_NAME
                                  FROM FV_IMPORT_REQ_PLANTPART PP
                                      ,FV_REF_PLANTPART        RP
                                WHERE PP.IMPORT_REQ_ID         = ?
                                  AND PP.PART_ID               = RP.PART_ID
                                ORDER BY 1
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 103991

qPG (Datasource=MANUAL_OPEN, Time=0ms, Records=1) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT PG.PORTGROUP_NAME
                                 FROM FV_IMPORT_REQ_PORTGROUP IP
                                     ,FV_PORTGROUP            PG
                                WHERE IP.IMPORT_REQ_ID = ?
                                  AND IP.PORTGROUP_ID  = PG.PORTGROUP_ID
                                 ORDER BY 1
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 103994

qEYKQ (Datasource=MANUAL_OPEN, Time=0ms, Records=0) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT T.REQUIREMENT_TYPE_NAME
                  ,T.CHAR_KEY
                  ,T.REQUIREMENT_TYPE_ID
                  ,D.REQ_DESC
                  ,R.IMPORT_REQ_ID
                  ,R.IMPORT_REQ_ID_PARENT
                  ,R.SORT_REQ
              FROM FV_PERMITTED            P
                  ,FV_IMPORT_REQUIREMENT   R
                  ,FV_REF_REQUIREMENT_TYPE T
                  ,FV_REQUIREMENT_DESC     D
             WHERE P.PERMITTED_ID          = ?
               AND P.ACTIVE                = 1
               AND R.ACTIVE                = 1
               AND P.PERMITTED_ID          = R.PERMITTED_ID
               AND R.REQUIREMENT_TYPE_ID   = T.REQUIREMENT_TYPE_ID
               AND R.REQ_DESC_ID           = D.REQ_DESC_ID(+)
               AND T.CHAR_KEY              = ?
               ORDER BY R.SORT_REQ, R.IMPORT_REQ_ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 10601693
Parameter #2(CF_SQL_VARCHAR) = EYKQ

qImpINSO (Datasource=MANUAL_OPEN, Time=0ms, Records=0) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT T.REQUIREMENT_TYPE_NAME
                      ,T.CHAR_KEY
                      ,T.REQUIREMENT_TYPE_ID
                      ,D.REQ_DESC
                      ,R.IMPORT_REQ_ID
                      ,R.IMPORT_REQ_ID_PARENT
                      ,R.SORT_REQ
                  FROM FV_PERMITTED            P
                      ,FV_IMPORT_REQUIREMENT   R
                      ,FV_REF_REQUIREMENT_TYPE T
                      ,FV_REQUIREMENT_DESC     D
                 WHERE P.PERMITTED_ID          = ?
                   AND P.ACTIVE                = 1
                   AND R.ACTIVE                = 1
                   AND P.PERMITTED_ID          = R.PERMITTED_ID
                   AND R.REQUIREMENT_TYPE_ID   = T.REQUIREMENT_TYPE_ID
                   AND R.REQ_DESC_ID           = D.REQ_DESC_ID(+)
                   AND T.CHAR_KEY              = 'INSO'
                   AND D.REQ_DESC              IS NOT NULL
                   ORDER BY R.SORT_REQ, R.IMPORT_REQ_ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 10601693

qRatt (Datasource=MANUAL_OPEN, Time=0ms, Records=0) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT A.DESCRIPTION
                      ,A.FILE_SIZE
                      ,A.FILE_NAME
                      ,A.ATTACH_ID
                      ,T.ATTACH_TYPE
                  FROM FV_ATTACHMENT       A
                      ,FV_REF_ATTACH_TYPE  T
                      ,FV_ATTACH_PERMITTED P
                 WHERE A.ATTACH_ID         = P.ATTACH_ID
                   AND A.RESTRICTED_IND    = 1
                   AND A.ATTACH_TYPE_ID    = T.ATTACH_TYPE_ID
                   AND P.PERMITTED_ID      = ?

                 UNION
                 SELECT A.DESCRIPTION
                      ,A.FILE_SIZE
                      ,A.FILE_NAME
                      ,A.ATTACH_ID
                      ,T.ATTACH_TYPE
                  FROM FV_ATTACHMENT       A
                      ,FV_ATTACH_COMMODITY C
                      ,FV_REF_ATTACH_TYPE  T
                 WHERE C.COMMOD_ID         = ?
                   AND C.ATTACH_ID         = A.ATTACH_ID
                   AND A.ATTACH_TYPE_ID    = T.ATTACH_TYPE_ID
                   AND A.RESTRICTED_IND = 1

                 ORDER BY ATTACH_ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 10601693
Parameter #2(CF_SQL_NUMERIC) = 141

qUNRnote (Datasource=MANUAL_OPEN, Time=1ms, Records=0) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT  DISTINCT N.NOTE_TEXT
                  FROM  FV_NOTE                  N
                       ,FV_NOTE_PORTGROUP_REGION R
                       ,FV_PERMITTED             P
                 WHERE  P.PERMITTED_ID   = ?
                   AND  P.PORTGROUP_ID   = R.PORTGROUP_ID
                   AND  P.REGION_ID      = R.REGION_ID
                   AND  R.NOTE_ID        = N.NOTE_ID
                   AND  N.ACTIVE         = 1
                   AND  N.RESTRICTED_IND = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 10601693

qUNRatt (Datasource=MANUAL_OPEN, Time=1ms, Records=0) in D:\CFMX-Components\Manual\Objects\searchManager.cfc @ 22:00:23.023
SELECT A.DESCRIPTION || ' (' || A.FILE_SIZE || ' KB)' AS ADESC
                  ,A.ATTACH_ID
                  ,A.DESCRIPTION
                  ,A.FILE_SIZE
                  ,A.FILE_NAME
                  ,A.RESTRICTED_IND
                  ,T.ATTACH_TYPE
              FROM FV_ATTACHMENT       A
                  ,FV_REF_ATTACH_TYPE  T
                  ,FV_ATTACH_PERMITTED P
             WHERE A.ATTACH_ID         = P.ATTACH_ID
               AND A.ATTACH_TYPE_ID    = T.ATTACH_TYPE_ID
               AND A.RESTRICTED_IND    = 0
               AND P.PERMITTED_ID      = ?

             UNION
             SELECT A.DESCRIPTION || ' (' || A.FILE_SIZE || ' KB)' AS ADESC
                  ,A.ATTACH_ID
                  ,A.DESCRIPTION
                  ,A.FILE_SIZE
                  ,A.FILE_NAME
                  ,A.RESTRICTED_IND
                  ,T.ATTACH_TYPE
              FROM FV_ATTACHMENT       A
                  ,FV_ATTACH_COMMODITY C
                  ,FV_REF_ATTACH_TYPE  T
             WHERE C.COMMOD_ID         = ?
               AND C.ATTACH_ID         = A.ATTACH_ID
               AND A.ATTACH_TYPE_ID    = T.ATTACH_TYPE_ID
               AND A.RESTRICTED_IND = 0

             ORDER BY ATTACH_ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 10601693
Parameter #2(CF_SQL_NUMERIC) = 141


Stored Procedures

cod.encryp (Datasource=MANUAL_RESTRICT, Time=1ms) in D:\CFMX-Components\Manual\Objects\security\SecurityCheck.cfc @ 22:00:23.023

    
parameters
typeCFSQLTypevaluevariabledbVarName
 OUT  CF_SQL_VARCHAR  PUBLICFV1  encPassword = encPassword  
    
resultsets
nameresultset


Scope Variables

Application Variables:
applicationname=manualApp
componentdirpath=D:\CFMX-Components\manual\
configfiledate=06/06/2018 09:39:12 AM
properties=Struct (24)
resetconfigfile=0
tempdir=D:\temp
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=d:\inetpub\wwwroot\manual\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.100.81.26
HTTP_REFERER=
HTTP_URL=/manual/index.cfm?action=cirReportP&PERMITTED_ID=10601693
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.100.81.26
PATH_INFO=
PATH_TRANSLATED=d:\inetpub\wwwroot\manual\index.cfm
QUERY_STRING=action=cirReportP&PERMITTED_ID=10601693
REMOTE_ADDR=10.100.82.26
REMOTE_HOST=10.100.82.26
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/manual/index.cfm
SERVER_NAME=10.100.81.26
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=307
CFTOKEN=322d01d1ca84e4fb-7E34601B-95F8-5054-C7627F088A7921E2
Form Fields:
changePassword=0
pwd=PUBLICFV1
un=PUBLICFV
Request Parameters:
app_admin=0
appvar=Struct (6)
default_sys_role_char_key=PFV
default_sys_role_id=66
eauth_level=2
epermitssessionstruct=Struct (7)
fvrole=PFV
headerfooter=Struct (1)
loggedin=1
other_sys_role_char_key=APP
other_sys_role_id=6
po_admin=0
program_office_id=
results=Struct (20)
samesite_value=
select_agent_flag=N
sessiontokenurlstring=
sys_user_id=14763
Session Variables:
cfid=307
cftoken=322d01d1ca84e4fb-7E34601B-95F8-5054-C7627F088A7921E2
fvrole=PFV
loggedin=1
securitystruct=Struct (10)
sessionid=MANUALAPP_307_322d01d1ca84e4fb-7E34601B-95F8-5054-C7627F088A7921E2
urltoken=CFID=307&CFTOKEN=322d01d1ca84e4fb-7E34601B-95F8-5054-C7627F088A7921E2
URL Parameters:
PERMITTED_ID=10601693
action=cirReportP
Debug Rendering Time: 8 ms