DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on MTL_CUSTOMER_ITEMS

Line 1513: mtl_customer_items mci

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
1516: AND oel.line_number = NVL(x_cascaded_table(n).oe_order_line_num, oel.line_number)
1517: AND oel.inventory_item_id = NVL(x_cascaded_table(n).item_id, oel.inventory_item_id)

Line 3007: mtl_customer_items mci

3003: IF (x_cascaded_table(n).customer_item_num IS NOT NULL) THEN
3004: SELECT NVL(MAX(oel.line_id), 0)
3005: INTO x_order_line_id
3006: FROM oe_order_lines_all oel,
3007: mtl_customer_items mci
3008: WHERE oel.line_id = x_cascaded_table(n).oe_order_line_id
3009: AND oel.ordered_item_id = mci.customer_item_id
3010: AND mci.customer_item_number = x_cascaded_table(n).customer_item_num;
3011: