VIEW: APPS.OKX_PACKING_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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