VIEW: APPS.RCV_TRANSACTIONS_INTERFAC1_DFV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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