View: CSD_RO_RMA_SLS_INT_ORDS_V

Product:	CSD - Depot Repair
Description:	This view gets RMA, sales order, internal order and internal requistion for repair orders.
Implementation/DBA Data:	APPS.CSD_RO_RMA_SLS_INT_ORDS_V

View Text

SELECT DRA.REPAIR_LINE_ID
, CED.ORDER_HEADER_ID RMA_SALES_ORDER_HEADER_ID
, DECODE (CED.ORDER_HEADER_ID
, NULL
, CPT.ORDER_HEADER_ID
, TO_NUMBER(NULL) ) INTERNAL_ORDER_HEADER_ID
, CPT.REQ_HEADER_ID INTERNAL_REQUISITION_HEADER_ID
FROM CSD_REPAIRS DRA
, CSD_PRODUCT_TRANSACTIONS CPT
, CS_ESTIMATE_DETAILS CED
WHERE DRA.REPAIR_LINE_ID = CPT.REPAIR_LINE_ID
AND CPT.ESTIMATE_DETAIL_ID = CED.ESTIMATE_DETAIL_ID(+)
AND ( CED.ORDER_HEADER_ID IS NOT NULL OR CPT.REQ_HEADER_ID IS NOT NULL ) UNION SELECT DRA.REPAIR_LINE_ID
, ORIGINAL_SOURCE_HEADER_ID RMA_SALES_ORDER_HEADER_ID
, TO_NUMBER(NULL) INTERNAL_ORDER_HEADER_ID
, TO_NUMBER(NULL) INTERNAL_REQUISITION_HEADER_ID
FROM CSD_REPAIRS DRA
WHERE DRA.ORIGINAL_SOURCE_REFERENCE = 'RMA'

Columns