APPS.RCV_RMA_TRANSACTIONS dependencies on OE_ORDER_HEADERS_ALL

Line 647: FROM oe_order_headers_all oeh,

643: -- bug 3224001: change query to get the correct header for the given order_num
644:
645: SELECT DISTINCT oeh.header_id
646: INTO x_cascaded_table(n).oe_order_header_id
647: FROM oe_order_headers_all oeh,
648: oe_order_lines_all oel,
649: oe_transaction_types_all oett
650: WHERE oeh.order_number = x_cascaded_table(n).oe_order_num
651: AND oeh.header_id = oel.header_id

Line 1057: FROM oe_order_headers_all oeh,

1053: oel.line_number oe_order_line_num,
1054: oel.inventory_item_id item_id,
1055: mum.unit_of_measure,
1056: msi.description description
1057: FROM oe_order_headers_all oeh,
1058: oe_order_lines_all oel,
1059: oe_transaction_types_all olt,
1060: oe_transaction_types_tl t,
1061: mtl_units_of_measure_tl mum,

Line 1511: FROM oe_order_headers_all oeh,

1507: x_booked_flag,
1508: x_flow_status_code,
1509: x_ordered_quantity,
1510: x_shipped_quantity
1511: FROM oe_order_headers_all oeh,
1512: oe_order_lines_all oel,
1513: mtl_customer_items mci
1514: WHERE oeh.header_id = x_cascaded_table(n).oe_order_header_id
1515: AND oeh.header_id = oel.header_id

Line 3025: FROM oe_order_headers_all oeh

3021: -- check customer id
3022: IF (x_cascaded_table(n).customer_id IS NOT NULL) THEN
3023: SELECT (NVL(oeh.sold_to_org_id, 0))
3024: INTO x_customer_id
3025: FROM oe_order_headers_all oeh
3026: WHERE oeh.header_id = x_cascaded_table(n).oe_order_header_id;
3027:
3028: IF (x_customer_id = 0) THEN
3029: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;