FND Design Data [Home] [Help]

View: RCV_UNPROCESSED_LOTS_V

Product: PO - Purchasing
Description: New in version 8.0
Implementation/DBA Data: ViewAPPS.RCV_UNPROCESSED_LOTS_V
View Text

SELECT RLI.LOT_NUM
, RLI.ITEM_ID
, RLI.SHIPMENT_LINE_ID
, SUM( DECODE(RTI.TRANSACTION_TYPE
, 'DELIVER'
, RLI.PRIMARY_QUANTITY
, 'CORRECT'
, SIGN(RTI.PRIMARY_QUANTITY)* RLI.PRIMARY_QUANTITY
, 'RECEIVE'
, RLI.PRIMARY_QUANTITY
, 'RETURN TO RECEIVING'
, RLI.PRIMARY_QUANTITY * -1
, 'RETURN TO VENDOR'
, RLI.PRIMARY_QUANTITY * -1
, 0))
, SUM( DECODE(RTI.TRANSACTION_TYPE
, 'DELIVER'
, RLI.QUANTITY
, 'CORRECT'
, SIGN(RTI.QUANTITY)*RLI.QUANTITY
, 'RECEIVE'
, RLI.QUANTITY
, 'RETURN TO RECEIVING'
, RLI.QUANTITY * -1
, 'RETURN TO VENDOR'
, RLI.QUANTITY * -1
, 0))
, RLI.PARENT_LOT_NUMBER
, SUM( DECODE(RTI.TRANSACTION_TYPE
, 'DELIVER'
, RLI.SECONDARY_QUANTITY
, 'CORRECT'
, SIGN(RTI.SECONDARY_QUANTITY)*RLI.SECONDARY_QUANTITY
, 'RECEIVE'
, RLI.SECONDARY_QUANTITY
, 'RETURN TO RECEIVING'
, RLI.SECONDARY_QUANTITY * -1
, 'RETURN TO VENDOR'
, RLI.SECONDARY_QUANTITY * -1
, 0))
FROM RCV_LOTS_INTERFACE RLI
, RCV_TRANSACTIONS_INTERFACE RTI
WHERE RLI.INTERFACE_TRANSACTION_ID = RTI.INTERFACE_TRANSACTION_ID GROUP BY RLI.LOT_NUM
, RLI.ITEM_ID
, RLI.SHIPMENT_LINE_ID
, RLI.PARENT_LOT_NUMBER

Columns

Name
LOT_NUM
ITEM_ID
SHIPMENT_LINE_ID
PRIMARY_QUANTITY
QUANTITY
PARENT_LOT_NUMBER
SECONDARY_QUANTITY