View: CSD_RCV_LINE_STATUS_V

Product:	CSD - Depot Repair
Description:	View for receiving line status on status details tab
Implementation/DBA Data:	APPS.CSD_RCV_LINE_STATUS_V

View Text

SELECT RCV.OE_ORDER_HEADER_ID
, RCV.OE_ORDER_LINE_ID
, TO_CHAR(OE.LINE_NUMBER) || '.' || TO_CHAR(OE.SHIPMENT_NUMBER) LINE_NUMBER
, RCV.QUANTITY
, RCV.TRANSACTION_TYPE
FROM RCV_TRANSACTIONS RCV
, OE_ORDER_LINES_ALL OE
WHERE OE.HEADER_ID = RCV.OE_ORDER_HEADER_ID
AND OE.LINE_ID = RCV.OE_ORDER_LINE_ID ORDER BY OE.LINE_NUMBER
, OE.SHIPMENT_NUMBER

Columns