View: OKX_PACKING_V

Product:	OKX - Contracts Integration
Description:	Packed containers
Implementation/DBA Data:	APPS.OKX_PACKING_V

View Text

SELECT PC.CONTAINER_ID ID1
, '#' ID2
, PC.DELIVERY_ID DELIVERY_ID
, PC.CONTAINER_INVENTORY_ITEM_ID CONTAINER_INVENTORY_ITEM_ID
, PC.QUANTITY QUANTITY
, PC.ORGANIZATION_ID ORGANIZATION_ID
, B.SEGMENT1 NAME
, B.DESCRIPTION || ' (QUANTITY: ' || PC.QUANTITY || '
, WEIGHT: ' || PC.GROSS_WEIGHT || ' ' || PC.WEIGHT_UOM_CODE || ')' DESCRIPTION
, 'A' STATUS
, SYSDATE START_DATE_ACTIVE
, NULL END_DATE_ACTIVE
FROM WSH_PACKED_CONTAINERS PC
, MTL_SYSTEM_ITEMS_B B
, MTL_SYSTEM_ITEMS_TL T
WHERE PC.CONTAINER_INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND PC.ORGANIZATION_ID = B.ORGANIZATION_ID
AND B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns