SELECT ROWID, DESTINATION_CONTEXT, (DECODE (DESTINATION_CONTEXT, 'SHOP FLOOR', DELIVER_TO_LOCATION_ID, 'INVENTORY', DELIVER_TO_LOCATION_ID, 'EXPENSE', DELIVER_TO_LOCATION_ID, NULL)), (DECODE (DESTINATION_CONTEXT, 'INVENTORY', SUBINVENTORY, NULL)), (DECODE (DESTINATION_CONTEXT, 'INVENTORY', LOCATOR_ATTRIBUTE, NULL)), (DECODE (DESTINATION_CONTEXT, 'RECEIVING', LOCATION_ID, NULL)),
(DECODE (DESTINATION_CONTEXT,
'EXPENSE', DESTINATION_CONTEXT || '-' || DELIVER_TO_LOCATION_ID,
'INVENTORY', DESTINATION_CONTEXT || '-' || DELIVER_TO_LOCATION_ID || '-' || SUBINVENTORY || '-' || LOCATOR_ATTRIBUTE,
'RECEIVING', DESTINATION_CONTEXT || '-' || LOCATION_ID,
'SHOP FLOOR', DESTINATION_CONTEXT || '-' || DELIVER_TO_LOCATION_ID, NULL))
FROM RCV_TRANSACTIONS
SELECT ROWID
, DESTINATION_CONTEXT
, (DECODE (DESTINATION_CONTEXT
, 'SHOP FLOOR'
, DELIVER_TO_LOCATION_ID
, 'INVENTORY'
, DELIVER_TO_LOCATION_ID
, 'EXPENSE'
, DELIVER_TO_LOCATION_ID
, NULL))
, (DECODE (DESTINATION_CONTEXT
, 'INVENTORY'
, SUBINVENTORY
, NULL))
, (DECODE (DESTINATION_CONTEXT
, 'INVENTORY'
, LOCATOR_ATTRIBUTE
, NULL))
, (DECODE (DESTINATION_CONTEXT
, 'RECEIVING'
, LOCATION_ID
, NULL))
,
(DECODE (DESTINATION_CONTEXT
,
'EXPENSE'
, DESTINATION_CONTEXT || '-' || DELIVER_TO_LOCATION_ID
,
'INVENTORY'
, DESTINATION_CONTEXT || '-' || DELIVER_TO_LOCATION_ID || '-' || SUBINVENTORY || '-' || LOCATOR_ATTRIBUTE
,
'RECEIVING'
, DESTINATION_CONTEXT || '-' || LOCATION_ID
,
'SHOP FLOOR'
, DESTINATION_CONTEXT || '-' || DELIVER_TO_LOCATION_ID
, NULL))
FROM RCV_TRANSACTIONS
|
|
|