APPS.INV_MGD_MVT_STATS_PROC dependencies on OE_ORDER_LINES_ALL

Line 1151: oe_order_lines_all

1147: SELECT
1148: item_type_code
1149: , NVL(shipped_quantity, fulfilled_quantity)
1150: FROM
1151: oe_order_lines_all
1152: WHERE line_id = l_link_to_line_id;
1153: BEGIN
1154: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1155: THEN

Line 1740: oe_order_lines_all

1736: SELECT
1737: item_type_code
1738: , NVL(shipped_quantity, fulfilled_quantity)
1739: FROM
1740: oe_order_lines_all
1741: WHERE line_id = l_link_to_line_id;
1742:
1743: CURSOR l_order_currency
1744: IS

Line 2503: oe_order_lines_all oola

2499: SELECT
2500: MAX(oola.line_id)
2501: , MAX(wdd.delivery_detail_id) picking_line_detail_id
2502: FROM
2503: oe_order_lines_all oola
2504: , wsh_delivery_details_ob_grp_v wdd
2505: WHERE oola.order_source_id = 10 --combine 1st and 2nd condition to use index 11
2506: AND oola.orig_sys_document_ref = l_req_number
2507: AND oola.source_document_line_id = l_movement_transaction.requisition_line_id

Line 2522: oe_order_lines_all oola

2518: SELECT
2519: oola.line_id
2520: , wdd.delivery_detail_id picking_line_detail_id
2521: FROM
2522: oe_order_lines_all oola
2523: , wsh_delivery_details_ob_grp_v wdd
2524: , rcv_transactions rcv
2525: , rcv_shipment_lines rsl
2526: , mtl_material_transactions mmt

Line 4364: , oe_order_lines_all oola

4360: mms.movement_id
4361: , mms.movement_status
4362: FROM
4363: mtl_movement_statistics mms
4364: , oe_order_lines_all oola
4365: WHERE mms.order_header_id = oola.reference_header_id
4366: AND mms.order_line_id = oola.reference_line_id
4367: AND oola.line_id = x_mvt_rma_transaction.order_line_id
4368: AND mms.entity_org_id = x_mvt_rma_transaction.entity_org_id

Line 4911: oe_order_lines_all oola1

4907: CURSOR c_item_type IS
4908: SELECT
4909: oola2.item_type_code
4910: FROM
4911: oe_order_lines_all oola1
4912: , oe_order_lines_all oola2
4913: WHERE oola1.line_id = l_movement_transaction.order_line_id
4914: AND oola2.line_id = oola1.reference_line_id;
4915:

Line 4912: , oe_order_lines_all oola2

4908: SELECT
4909: oola2.item_type_code
4910: FROM
4911: oe_order_lines_all oola1
4912: , oe_order_lines_all oola2
4913: WHERE oola1.line_id = l_movement_transaction.order_line_id
4914: AND oola2.line_id = oola1.reference_line_id;
4915:
4916: BEGIN