[Home] [Help]
1123: AND rcv.transaction_type IN ('DELIVER')
1124: AND rcv.source_document_code = 'RMA'
1125: AND rcv.transaction_date BETWEEN p_start_date AND p_end_date
1126: AND p_movement_transaction.entity_org_id =
1127: XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info
1128: ('SOLD_TO', oola.sold_to_org_id
1129: , null, null, oola.org_id)
1130: UNION
1131: SELECT --regular case: receipt LE is same as creating LE
1174: AND rcv.mvt_stat_status IN ('NEW', 'FORDISP', 'FORARVL') -- 7165989 Changes for RMA triangulation
1175: AND rcv.transaction_type IN ('DELIVER')
1176: AND rcv.source_document_code = 'RMA'
1177: AND p_movement_transaction.entity_org_id =
1178: XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info
1179: ('SOLD_TO', oola.sold_to_org_id
1180: , null, null, oola.org_id)
1181: UNION
1182: SELECT