APPS.RCV_RMA_TRANSACTIONS dependencies on OE_ORDER_HEADERS_ALL

Line 648: FROM oe_order_headers_all oeh,

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

Line 1058: FROM oe_order_headers_all oeh,

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

Line 1514: FROM oe_order_headers_all oeh,

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

Line 2563: x_oe_reference_order_num oe_order_headers_all.order_number%type;

2559: x_oe_order_line_id oe_order_lines_all.line_id%type;
2560: x_oe_reference_order_line_id oe_order_lines_all.reference_line_id%type;
2561: x_so_issue_transaction_date mtl_material_transactions.transaction_date%type;
2562: x_item_id mtl_material_transactions.inventory_item_id%type;
2563: x_oe_reference_order_num oe_order_headers_all.order_number%type;
2564: x_oe_reference_order_line varchar2(30);
2565: -- Bug 12582249 End
2566: BEGIN
2567: /*Bug 2327318 Implemented the validation Transaction date should not be greater than

Line 2726: FROM oe_order_headers_all ooha, oe_order_lines_all oola

2722: OR x_so_issue_transaction_date is null -- bug 14168623 if so not being shipped then not allow to do RMA
2723: THEN
2724: SELECT ooha.order_number, oola.line_number||'.'||oola.shipment_number
2725: INTO x_oe_reference_order_num, x_oe_reference_order_line
2726: FROM oe_order_headers_all ooha, oe_order_lines_all oola
2727: WHERE ooha.header_id = oola.header_id
2728: AND oola.line_id = x_oe_reference_order_line_id;
2729:
2730: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;

Line 3165: FROM oe_order_headers_all oeh

3161: -- check customer id
3162: IF (x_cascaded_table(n).customer_id IS NOT NULL) THEN
3163: SELECT (NVL(oeh.sold_to_org_id, 0))
3164: INTO x_customer_id
3165: FROM oe_order_headers_all oeh
3166: WHERE oeh.header_id = x_cascaded_table(n).oe_order_header_id;
3167:
3168: IF (x_customer_id = 0) THEN
3169: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;