APPS.INV_RCV_COMMON_APIS dependencies on OE_ORDER_HEADERS_ALL

Line 3695: FROM oe_order_lines_all oel, oe_order_headers_all oeh

3691: l_progress := '20';
3692: BEGIN
3693: SELECT COUNT (DISTINCT oel.order_quantity_uom)
3694: INTO l_count
3695: FROM oe_order_lines_all oel, oe_order_headers_all oeh
3696: WHERE oel.header_id = p_order_header_id
3697: --AND oel.ordered_item_id = p_item_id -- commented for Bug 12640725
3698: AND oel.inventory_item_id = p_item_id -- added for Bug 12640725
3699: AND NVL (OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id

Line 3733: FROM oe_order_headers_all oeh

3729: AND oel.open_flag = 'Y'
3730: AND oel.booked_flag = 'Y'
3731: AND oel.flow_status_code = 'AWAITING_RETURN'
3732: AND EXISTS (SELECT 1
3733: FROM oe_order_headers_all oeh
3734: WHERE oeh.open_flag = 'Y' AND oeh.header_id = oel.header_id)
3735: AND ROWNUM = 1;
3736: EXCEPTION
3737: WHEN OTHERS

Line 4936: OE_ORDER_HEADERS_all OEH

4932: SELECT DISTINCT(OEL.item_revision)
4933: INTO x_revision_code
4934: FROM
4935: OE_ORDER_LINES_all OEL,
4936: OE_ORDER_HEADERS_all OEH
4937: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
4938: AND OEL.INVENTORY_ITEM_ID = p_item_id
4939: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id
4940: AND OEL.HEADER_ID = OEH.HEADER_ID

Line 7801: FROM oe_order_headers_all

7797:
7798: l_progress := '20';
7799: SELECT header_id
7800: INTO l_order_header_id
7801: FROM oe_order_headers_all
7802: WHERE orig_sys_document_ref = l_req_num
7803: AND order_source_id = 10;
7804:
7805: IF (l_debug = 1) THEN

Line 8071: from oe_order_headers_all

8067: IF p_oe_order_header_id IS NOT NULL THEN
8068:
8069: Select org_id
8070: into l_operating_unit_id
8071: from oe_order_headers_all
8072: where header_id = p_oe_order_header_id;
8073:
8074: END IF;
8075: