VIEW: APPS.CSD_RO_RMA_SLS_INT_ORDS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'