APPS.INV_RCV_COMMON_APIS dependencies on OE_ORDER_HEADERS_ALL

Line 4413: OE_ORDER_HEADERS_all OEH

4409: SELECT DISTINCT(OEL.item_revision)
4410: INTO x_revision_code
4411: FROM
4412: OE_ORDER_LINES_all OEL,
4413: OE_ORDER_HEADERS_all OEH
4414: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
4415: AND OEL.INVENTORY_ITEM_ID = p_item_id
4416: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id
4417: AND OEL.HEADER_ID = OEH.HEADER_ID

Line 7269: FROM oe_order_headers_all

7265:
7266: l_progress := '20';
7267: SELECT header_id
7268: INTO l_order_header_id
7269: FROM oe_order_headers_all
7270: WHERE orig_sys_document_ref = l_req_num
7271: AND order_source_id = 10;
7272:
7273: IF (l_debug = 1) THEN

Line 7539: from oe_order_headers_all

7535: IF p_oe_order_header_id IS NOT NULL THEN
7536:
7537: Select org_id
7538: into l_operating_unit_id
7539: from oe_order_headers_all
7540: where header_id = p_oe_order_header_id;
7541:
7542: END IF;
7543: