[Home] [Help]
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
Name |
ID1 |
ID2 |
DELIVERY_ID |
CONTAINER_INVENTORY_ITEM_ID |
QUANTITY |
ORGANIZATION_ID |
NAME |
DESCRIPTION |
STATUS |
START_DATE_ACTIVE |
END_DATE_ACTIVE |