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.WSHFV_PACKED_CONTAINER

Source

View Text - Preformatted


SELECT PC.CONTAINER_ID , PC.DELIVERY_ID , WDL.NAME DELIVERY_NAME , PC.CONTAINER_INVENTORY_ITEM_ID , PC.QUANTITY PACKED_QUANTITY , PC.SEQUENCE_NUMBER , PC.PARENT_SEQUENCE_NUMBER , PC.GROSS_WEIGHT , PC.WEIGHT_UOM_CODE , PC.ORGANIZATION_ID , ORG.ORGANIZATION_CODE , MSI.DESCRIPTION , MSI.PRIMARY_UOM_CODE , PC.INVENTORY_LOCATION_ID , DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE,1,'Y','N') SUBINV_RESTRICTED_FLAG , PC.SUBINVENTORY , DECODE(MSI.REVISION_QTY_CONTROL_CODE,2,'Y','N') REVISION_CONTROL_FLAG , PC.REVISION , DECODE(MSI.LOT_CONTROL_CODE,2,'Y','N') LOT_CONTROL_FLAG , PC.LOT_NUMBER , DECODE(MSI.SERIAL_NUMBER_CONTROL_CODE,2,'Y',5,'Y',6,'Y','N') SERIAL_NUMBER_CONTROL_FLAG , MSI.SERIAL_NUMBER_CONTROL_CODE , MSI.RESTRICT_LOCATORS_CODE , MSI.LOCATION_CONTROL_CODE , ORG.STOCK_LOCATOR_CONTROL_CODE , ORG.NEGATIVE_INV_RECEIPT_CODE , PC.SERIAL_NUMBER , PC.MASTER_SERIAL_NUMBER , PC.INVENTORY_STATUS INVENTORY_INTERFACED_STATUS , PC.RA_INTERFACE_STATUS RECEIVABLE_INTERFACED_STATUS , PC.CREATION_DATE , PC.CREATED_BY , PC.LAST_UPDATE_DATE , PC.LAST_UPDATED_BY , PC.LAST_UPDATE_LOGIN , PC.PROGRAM_APPLICATION_ID , PC.PROGRAM_ID , PC.PROGRAM_UPDATE_DATE , PC.REQUEST_ID FROM WSH_PACKED_CONTAINERS PC, MTL_SYSTEM_ITEMS MSI, MTL_PARAMETERS ORG, WSH_DELIVERIES WDL WHERE PC.CONTAINER_INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND PC.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND ORG.ORGANIZATION_ID(+) = MSI.ORGANIZATION_ID AND WDL.DELIVERY_ID (+) = PC.DELIVERY_ID

View Text - HTML Formatted

SELECT PC.CONTAINER_ID
, PC.DELIVERY_ID
, WDL.NAME DELIVERY_NAME
, PC.CONTAINER_INVENTORY_ITEM_ID
, PC.QUANTITY PACKED_QUANTITY
, PC.SEQUENCE_NUMBER
, PC.PARENT_SEQUENCE_NUMBER
, PC.GROSS_WEIGHT
, PC.WEIGHT_UOM_CODE
, PC.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, MSI.DESCRIPTION
, MSI.PRIMARY_UOM_CODE
, PC.INVENTORY_LOCATION_ID
, DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE
, 1
, 'Y'
, 'N') SUBINV_RESTRICTED_FLAG
, PC.SUBINVENTORY
, DECODE(MSI.REVISION_QTY_CONTROL_CODE
, 2
, 'Y'
, 'N') REVISION_CONTROL_FLAG
, PC.REVISION
, DECODE(MSI.LOT_CONTROL_CODE
, 2
, 'Y'
, 'N') LOT_CONTROL_FLAG
, PC.LOT_NUMBER
, DECODE(MSI.SERIAL_NUMBER_CONTROL_CODE
, 2
, 'Y'
, 5
, 'Y'
, 6
, 'Y'
, 'N') SERIAL_NUMBER_CONTROL_FLAG
, MSI.SERIAL_NUMBER_CONTROL_CODE
, MSI.RESTRICT_LOCATORS_CODE
, MSI.LOCATION_CONTROL_CODE
, ORG.STOCK_LOCATOR_CONTROL_CODE
, ORG.NEGATIVE_INV_RECEIPT_CODE
, PC.SERIAL_NUMBER
, PC.MASTER_SERIAL_NUMBER
, PC.INVENTORY_STATUS INVENTORY_INTERFACED_STATUS
, PC.RA_INTERFACE_STATUS RECEIVABLE_INTERFACED_STATUS
, PC.CREATION_DATE
, PC.CREATED_BY
, PC.LAST_UPDATE_DATE
, PC.LAST_UPDATED_BY
, PC.LAST_UPDATE_LOGIN
, PC.PROGRAM_APPLICATION_ID
, PC.PROGRAM_ID
, PC.PROGRAM_UPDATE_DATE
, PC.REQUEST_ID
FROM WSH_PACKED_CONTAINERS PC
, MTL_SYSTEM_ITEMS MSI
, MTL_PARAMETERS ORG
, WSH_DELIVERIES WDL
WHERE PC.CONTAINER_INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND PC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID(+) = MSI.ORGANIZATION_ID
AND WDL.DELIVERY_ID (+) = PC.DELIVERY_ID