APPS.INV_TRANSACTION_FLOW_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 3263: , oe_order_headers_all OEH

3259: SELECT WHS.mtl_organization_id, oeh.ordered_date
3260: INTO l_organization_id, l_transaction_date
3261: FROM ic_whse_mst WHS
3262: , oe_order_lines_all OEL
3263: , oe_order_headers_all OEH
3264: WHERE OEL.line_id = l_line_id
3265: AND oel.header_id = oeh.header_id
3266: AND WHS.whse_code = l_whse_code;
3267: ELSIF l_doc_type = 'PORC' THEN

Line 3272: , oe_order_headers_all OEH

3268: SELECT WHS.mtl_organization_id, oeh.ordered_date
3269: INTO l_organization_id, l_transaction_date
3270: FROM ic_whse_mst WHS
3271: , oe_order_lines_all OEL
3272: , oe_order_headers_all OEH
3273: , rcv_transactions RCT
3274: , po_requisition_headers_all poh
3275: , po_requisition_lines_all pol
3276: WHERE poh.requisition_header_id = pol.requisition_header_id

Line 3314: FROM oe_order_lines_all oel, oe_order_headers_all oeh

3310: -- this is a true drop ship with procuring flow
3311: BEGIN
3312: select oel.ship_from_org_id, oeh.ordered_date
3313: into l_organization_id, l_transaction_date
3314: FROM oe_order_lines_all oel, oe_order_headers_all oeh
3315: where oel.line_id = p_reference_id
3316: AND oel.header_id = oeh.header_id;
3317: EXCEPTION
3318: WHEN NO_DATA_FOUND then

Line 4593: FROM oe_order_lines_all oel, oe_order_headers_all oeh

4589: print_debug('Inside p_drop_ship_flag = Y', 'GET_TRANSFER_PRICE');
4590: BEGIN
4591: select oeh.ordered_date
4592: into l_transaction_date
4593: FROM oe_order_lines_all oel, oe_order_headers_all oeh
4594: where oel.line_id = p_transaction_id
4595: AND oel.header_id = oeh.header_id;
4596: EXCEPTION
4597: WHEN NO_DATA_FOUND then