DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on MTL_CUSTOMER_ITEMS

Line 1516: mtl_customer_items mci

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

Line 3147: mtl_customer_items mci

3143: IF (x_cascaded_table(n).customer_item_num IS NOT NULL) THEN
3144: SELECT NVL(MAX(oel.line_id), 0)
3145: INTO x_order_line_id
3146: FROM oe_order_lines_all oel,
3147: mtl_customer_items mci
3148: WHERE oel.line_id = x_cascaded_table(n).oe_order_line_id
3149: AND oel.ordered_item_id = mci.customer_item_id
3150: AND mci.customer_item_number = x_cascaded_table(n).customer_item_num;
3151: