View: WMS_LABEL_REQUESTS_HIST_V

Product:	WMS - Warehouse Management
Description:	View to store lable printing request history records
Implementation/DBA Data:	APPS.WMS_LABEL_REQUESTS_HIST_V

View Text

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')

Columns