APPS.INV_RCV_TXN_MATCH dependencies on OE_ORDER_LINES_ALL

Line 974: FROM oe_order_lines_all oel

970: , To_number(NULL)
971: , To_number(NULL)
972: , To_char(NULL)
973: , To_char(NULL)
974: FROM oe_order_lines_all oel
975: , oe_order_headers_all oeh
976: --, wf_item_activity_statuses wf
977: --, wf_process_activities wpa
978: WHERE oel.header_id = oeh.header_id

Line 1017: FROM oe_order_lines_all oel

1013: ,v_project_id NUMBER
1014: ,v_task_id NUMBER)
1015: IS
1016: SELECT COUNT(*)
1017: FROM oe_order_lines_all oel
1018: , oe_order_headers_all oeh
1019: --, wf_item_activity_statuses wf
1020: --, wf_process_activities wpa
1021: WHERE oel.header_id = oeh.header_id

Line 2871: --bug3592116 for RMA the uom code is got from oe_order_lines_all but we need to get

2867: l_parent_id := x_MatchedRec.shipment_line_id;
2868: ELSIF p_match_type = 'RMA' THEN
2869: l_receipt_source_code := x_MatchedRec.receipt_source_code;
2870: l_parent_id := x_MatchedRec.oe_order_line_id;
2871: --bug3592116 for RMA the uom code is got from oe_order_lines_all but we need to get
2872: --unit_of_measure to convert the rma line quantity to user input qty.
2873: SELECT unit_of_measure INTO l_rma_uom
2874: FROM mtl_units_of_measure
2875: WHERE uom_code = x_MatchedRec.unit_of_measure;