eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WMS_LABEL_REQUESTS_HIST_V

Source

View Text - Preformatted


SELECT WLRH.ROWID ROW_ID, WLRH.LABEL_REQUEST_ID ,WLRH.JOB_NAME ,WLRH.REQUEST_MODE_CODE ,ML3.MEANING REQUEST_MODE ,WLRH.REQUEST_DATE ,WLRH.REQUEST_USER_ID ,FU.USER_NAME REQUEST_USER ,WLRH.BUSINESS_FLOW_CODE ,ML1.MEANING BUSINESS_FLOW_CODE_NAME ,WLRH.LABEL_TYPE_ID ,ML2.MEANING LABEL_TYPE ,WLRH.LABEL_FORMAT_ID ,WLF.LABEL_FORMAT_NAME ,WLRH.PRINTER_NAME ,WLRH.LABEL_CONTENT ,WLRH.OUTFILE_NAME ,WLRH.OUTFILE_DIRECTORY ,WLRH.NO_OF_COPY ,WLRH.ENCODING ,WLRH.ORIGINAL_REQUEST_ID ,WLRH.ORGANIZATION_ID ,MP.ORGANIZATION_CODE ,WLRH.INVENTORY_ITEM_ID ,MSIK.CONCATENATED_SEGMENTS ITEM ,WLRH.SUBINVENTORY_CODE ,WLRH.LOCATOR_ID ,MILK.CONCATENATED_SEGMENTS LOCATOR ,WLRH.LOT_NUMBER ,WLRH.REVISION ,WLRH.SERIAL_NUMBER ,WLRH.LPN_ID ,WLPN.LICENSE_PLATE_NUMBER ,WLRH.DELIVERY_ID ,WND.NAME DELIVERY ,WLRH.DELIVERY_DETAIL_ID ,WLRH.PACKAGE_ID ,WLRH.SALES_ORDER_HEADER_ID ,OOHA.ORDER_NUMBER SALES_ORDER_HEADER ,WLRH.SALES_ORDER_LINE_ID ,OOLA.LINE_NUMBER SALES_ORDER_LINE ,WLRH.SUPPLIER_ID ,POV.VENDOR_NAME SUPPLIER ,WLRH.SUPPLIER_SITE_ID ,POVS.VENDOR_SITE_CODE SUPPLIER_SITE ,WLRH.SUPPLIER_ITEM_ID ,WLRH.CUSTOMER_ID ,PARTY.PARTY_NUMBER CUSTOMER_NUMBER ,PARTY.PARTY_NAME CUSTOMER_NAME ,WLRH.CUSTOMER_SITE_ID ,WLRH.CUSTOMER_ITEM_ID ,MCI.CUSTOMER_ITEM_NUMBER ,WLRH.CUSTOMER_CONTACT_ID ,HCAR_1.CUSTOMER_CONTACT_NAME CUSTOMER_CONTACT_NAME ,WLRH.FREIGHT_CODE ,WLRH.RULE_ID ,WRV.NAME RULE_NAME ,WLRH.RULE_WEIGHT ,WLRH.STRATEGY_ID ,WSTG.NAME STRATEGY_NAME ,WLRH.STATUS_FLAG ,WLRH.ERROR_MESSAGE ,WLRH.JOB_STATUS ,WLRH.PRINTER_STATUS ,WLRH.STATUS_TYPE ,WLRH.ATTRIBUTE_CATEGORY ,WLRH.ATTRIBUTE1 ,WLRH.ATTRIBUTE2 ,WLRH.ATTRIBUTE3 ,WLRH.ATTRIBUTE4 ,WLRH.ATTRIBUTE5 ,WLRH.ATTRIBUTE6 ,WLRH.ATTRIBUTE7 ,WLRH.ATTRIBUTE8 ,WLRH.ATTRIBUTE9 ,WLRH.ATTRIBUTE10 ,WLRH.ATTRIBUTE11 ,WLRH.ATTRIBUTE12 ,WLRH.ATTRIBUTE13 ,WLRH.ATTRIBUTE14 ,WLRH.ATTRIBUTE15 ,WLRH.CREATION_DATE ,WLRH.CREATED_BY ,WLRH.LAST_UPDATE_DATE ,WLRH.LAST_UPDATED_BY ,WLRH.LAST_UPDATE_LOGIN ,WLRH.REQUEST_ID ,WLRH.PROGRAM_APPLICATION_ID ,WLRH.PROGRAM_ID ,WLRH.PROGRAM_UPDATE_DATE FROM WMS_LABEL_REQUESTS_HIST WLRH ,FND_USER FU ,MFG_LOOKUPS ML1 ,MFG_LOOKUPS ML2 ,MFG_LOOKUPS ML3 ,WMS_LABEL_FORMATS WLF ,MTL_PARAMETERS MP ,MTL_SYSTEM_ITEMS_KFV MSIK ,MTL_ITEM_LOCATIONS_KFV MILK ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WSH_NEW_DELIVERIES WND ,OE_ORDER_HEADERS_ALL OOHA ,OE_ORDER_LINES_ALL OOLA ,PO_VENDORS POV ,PO_VENDOR_SITES_ALL POVS ,HZ_PARTIES PARTY ,HZ_CUST_ACCOUNTS CUST_ACCT ,MTL_CUSTOMER_ITEMS MCI ,( SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID, SUBSTRB(PARTY1.PERSON_LAST_NAME,1,50) || DECODE(substrb(PARTY1.PERSON_LAST_NAME,1,50),NULL,NULL,',')|| SUBSTRB(PARTY1.PERSON_FIRST_NAME,1,50) CUSTOMER_CONTACT_NAME FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE ,HZ_PARTIES PARTY1 ,HZ_RELATIONSHIPS REL ,HZ_ORG_CONTACTS ORG_CONT ,HZ_PARTIES REL_PARTY ,HZ_CUST_ACCOUNTS ROLE_ACCT WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID AND ACCT_ROLE.ROLE_TYPE = 'CONTACT' AND REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID AND REL.SUBJECT_ID = PARTY1.PARTY_ID AND REL.PARTY_ID = REL_PARTY.PARTY_ID AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_ID = ROLE_ACCT.PARTY_ID AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID ) hcar_1 ,WMS_RULES_TL WRV ,WMS_STRATEGIES_TL WSTG WHERE WLRH.REQUEST_USER_ID = FU.USER_ID AND ML1.LOOKUP_TYPE(+)='WMS_BUSINESS_FLOW' AND ML1.LOOKUP_CODE(+)=WLRH.BUSINESS_FLOW_CODE AND ML2.LOOKUP_TYPE(+)='WMS_LABEL_TYPE' AND ML2.LOOKUP_CODE(+)=WLRH.LABEL_TYPE_ID AND ML3.LOOKUP_TYPE(+)='WMS_PRINT_MODE' AND ML3.LOOKUP_CODE(+)=WLRH.REQUEST_MODE_CODE AND WLF.DOCUMENT_ID(+)=WLRH.LABEL_TYPE_ID AND WLF.LABEL_FORMAT_ID(+)=WLRH.LABEL_FORMAT_ID AND MP.ORGANIZATION_ID (+) = WLRH.ORGANIZATION_ID AND MSIK.ORGANIZATION_ID (+) = WLRH.ORGANIZATION_ID AND MSIK.INVENTORY_ITEM_ID(+) = WLRH.INVENTORY_ITEM_ID AND MILK.ORGANIZATION_ID(+) = WLRH.ORGANIZATION_ID AND MILK.SUBINVENTORY_CODE(+) = WLRH.SUBINVENTORY_CODE AND MILK.INVENTORY_LOCATION_ID(+) = WLRH.LOCATOR_ID AND WLPN.LPN_ID(+) = WLRH.LPN_ID AND WND.DELIVERY_ID(+) = WLRH.DELIVERY_ID AND OOHA.HEADER_ID(+) = WLRH.SALES_ORDER_HEADER_ID AND OOLA.HEADER_ID(+) = WLRH.SALES_ORDER_HEADER_ID AND OOLA.LINE_ID(+) = WLRH.SALES_ORDER_LINE_ID AND POV.VENDOR_ID(+) = WLRH.SUPPLIER_ID AND POVS.VENDOR_ID(+) = WLRH.SUPPLIER_ID AND POVS.VENDOR_SITE_ID(+) = WLRH.SUPPLIER_SITE_ID AND PARTY.PARTY_ID(+) = CUST_ACCT.PARTY_ID AND CUST_ACCT.CUST_ACCOUNT_ID(+) = WLRH.CUSTOMER_ID AND MCI.CUSTOMER_ITEM_ID(+) = WLRH.CUSTOMER_ITEM_ID AND hcar_1.CUST_ACCOUNT_ROLE_ID(+) = WLRH.CUSTOMER_CONTACT_ID AND WRV.RULE_ID(+) = WLRH.RULE_ID AND WRV.LANGUAGE(+) = USERENV('LANG') AND WSTG.STRATEGY_ID(+) = WLRH.STRATEGY_ID AND WSTG.LANGUAGE(+) = userenv('LANG')

View Text - HTML Formatted

SELECT WLRH.ROWID ROW_ID
, WLRH.LABEL_REQUEST_ID
, WLRH.JOB_NAME
, WLRH.REQUEST_MODE_CODE
, ML3.MEANING REQUEST_MODE
, WLRH.REQUEST_DATE
, WLRH.REQUEST_USER_ID
, FU.USER_NAME REQUEST_USER
, WLRH.BUSINESS_FLOW_CODE
, ML1.MEANING BUSINESS_FLOW_CODE_NAME
, WLRH.LABEL_TYPE_ID
, ML2.MEANING LABEL_TYPE
, WLRH.LABEL_FORMAT_ID
, WLF.LABEL_FORMAT_NAME
, WLRH.PRINTER_NAME
, WLRH.LABEL_CONTENT
, WLRH.OUTFILE_NAME
, WLRH.OUTFILE_DIRECTORY
, WLRH.NO_OF_COPY
, WLRH.ENCODING
, WLRH.ORIGINAL_REQUEST_ID
, WLRH.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, WLRH.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS ITEM
, WLRH.SUBINVENTORY_CODE
, WLRH.LOCATOR_ID
, MILK.CONCATENATED_SEGMENTS LOCATOR
, WLRH.LOT_NUMBER
, WLRH.REVISION
, WLRH.SERIAL_NUMBER
, WLRH.LPN_ID
, WLPN.LICENSE_PLATE_NUMBER
, WLRH.DELIVERY_ID
, WND.NAME DELIVERY
, WLRH.DELIVERY_DETAIL_ID
, WLRH.PACKAGE_ID
, WLRH.SALES_ORDER_HEADER_ID
, OOHA.ORDER_NUMBER SALES_ORDER_HEADER
, WLRH.SALES_ORDER_LINE_ID
, OOLA.LINE_NUMBER SALES_ORDER_LINE
, WLRH.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER
, WLRH.SUPPLIER_SITE_ID
, POVS.VENDOR_SITE_CODE SUPPLIER_SITE
, WLRH.SUPPLIER_ITEM_ID
, WLRH.CUSTOMER_ID
, PARTY.PARTY_NUMBER CUSTOMER_NUMBER
, PARTY.PARTY_NAME CUSTOMER_NAME
, WLRH.CUSTOMER_SITE_ID
, WLRH.CUSTOMER_ITEM_ID
, MCI.CUSTOMER_ITEM_NUMBER
, WLRH.CUSTOMER_CONTACT_ID
, HCAR_1.CUSTOMER_CONTACT_NAME CUSTOMER_CONTACT_NAME
, WLRH.FREIGHT_CODE
, WLRH.RULE_ID
, WRV.NAME RULE_NAME
, WLRH.RULE_WEIGHT
, WLRH.STRATEGY_ID
, WSTG.NAME STRATEGY_NAME
, WLRH.STATUS_FLAG
, WLRH.ERROR_MESSAGE
, WLRH.JOB_STATUS
, WLRH.PRINTER_STATUS
, WLRH.STATUS_TYPE
, WLRH.ATTRIBUTE_CATEGORY
, WLRH.ATTRIBUTE1
, WLRH.ATTRIBUTE2
, WLRH.ATTRIBUTE3
, WLRH.ATTRIBUTE4
, WLRH.ATTRIBUTE5
, WLRH.ATTRIBUTE6
, WLRH.ATTRIBUTE7
, WLRH.ATTRIBUTE8
, WLRH.ATTRIBUTE9
, WLRH.ATTRIBUTE10
, WLRH.ATTRIBUTE11
, WLRH.ATTRIBUTE12
, WLRH.ATTRIBUTE13
, WLRH.ATTRIBUTE14
, WLRH.ATTRIBUTE15
, WLRH.CREATION_DATE
, WLRH.CREATED_BY
, WLRH.LAST_UPDATE_DATE
, WLRH.LAST_UPDATED_BY
, WLRH.LAST_UPDATE_LOGIN
, WLRH.REQUEST_ID
, WLRH.PROGRAM_APPLICATION_ID
, WLRH.PROGRAM_ID
, WLRH.PROGRAM_UPDATE_DATE
FROM WMS_LABEL_REQUESTS_HIST WLRH
, FND_USER FU
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, WMS_LABEL_FORMATS WLF
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_ITEM_LOCATIONS_KFV MILK
, WMS_LICENSE_PLATE_NUMBERS WLPN
, WSH_NEW_DELIVERIES WND
, OE_ORDER_HEADERS_ALL OOHA
, OE_ORDER_LINES_ALL OOLA
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, MTL_CUSTOMER_ITEMS MCI
, ( SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
, SUBSTRB(PARTY1.PERSON_LAST_NAME
, 1
, 50) || DECODE(SUBSTRB(PARTY1.PERSON_LAST_NAME
, 1
, 50)
, NULL
, NULL
, '
, ')|| SUBSTRB(PARTY1.PERSON_FIRST_NAME
, 1
, 50) CUSTOMER_CONTACT_NAME
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY1
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_PARTIES REL_PARTY
, HZ_CUST_ACCOUNTS ROLE_ACCT
WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND REL.RELATIONSHIP_ID = ORG_CONT.PARTY_RELATIONSHIP_ID
AND REL.SUBJECT_ID = PARTY1.PARTY_ID
AND REL.PARTY_ID = REL_PARTY.PARTY_ID
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_ID = ROLE_ACCT.PARTY_ID
AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID ) HCAR_1
, WMS_RULES_TL WRV
, WMS_STRATEGIES_TL WSTG
WHERE WLRH.REQUEST_USER_ID = FU.USER_ID
AND ML1.LOOKUP_TYPE(+)='WMS_BUSINESS_FLOW'
AND ML1.LOOKUP_CODE(+)=WLRH.BUSINESS_FLOW_CODE
AND ML2.LOOKUP_TYPE(+)='WMS_LABEL_TYPE'
AND ML2.LOOKUP_CODE(+)=WLRH.LABEL_TYPE_ID
AND ML3.LOOKUP_TYPE(+)='WMS_PRINT_MODE'
AND ML3.LOOKUP_CODE(+)=WLRH.REQUEST_MODE_CODE
AND WLF.DOCUMENT_ID(+)=WLRH.LABEL_TYPE_ID
AND WLF.LABEL_FORMAT_ID(+)=WLRH.LABEL_FORMAT_ID
AND MP.ORGANIZATION_ID (+) = WLRH.ORGANIZATION_ID
AND MSIK.ORGANIZATION_ID (+) = WLRH.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID(+) = WLRH.INVENTORY_ITEM_ID
AND MILK.ORGANIZATION_ID(+) = WLRH.ORGANIZATION_ID
AND MILK.SUBINVENTORY_CODE(+) = WLRH.SUBINVENTORY_CODE
AND MILK.INVENTORY_LOCATION_ID(+) = WLRH.LOCATOR_ID
AND WLPN.LPN_ID(+) = WLRH.LPN_ID
AND WND.DELIVERY_ID(+) = WLRH.DELIVERY_ID
AND OOHA.HEADER_ID(+) = WLRH.SALES_ORDER_HEADER_ID
AND OOLA.HEADER_ID(+) = WLRH.SALES_ORDER_HEADER_ID
AND OOLA.LINE_ID(+) = WLRH.SALES_ORDER_LINE_ID
AND POV.VENDOR_ID(+) = WLRH.SUPPLIER_ID
AND POVS.VENDOR_ID(+) = WLRH.SUPPLIER_ID
AND POVS.VENDOR_SITE_ID(+) = WLRH.SUPPLIER_SITE_ID
AND PARTY.PARTY_ID(+) = CUST_ACCT.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID(+) = WLRH.CUSTOMER_ID
AND MCI.CUSTOMER_ITEM_ID(+) = WLRH.CUSTOMER_ITEM_ID
AND HCAR_1.CUST_ACCOUNT_ROLE_ID(+) = WLRH.CUSTOMER_CONTACT_ID
AND WRV.RULE_ID(+) = WLRH.RULE_ID
AND WRV.LANGUAGE(+) = USERENV('LANG')
AND WSTG.STRATEGY_ID(+) = WLRH.STRATEGY_ID
AND WSTG.LANGUAGE(+) = USERENV('LANG')