DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 3251: , oe_order_headers_all OEH

3247: SELECT WHS.mtl_organization_id, oeh.ordered_date
3248: INTO l_organization_id, l_transaction_date
3249: FROM ic_whse_mst WHS
3250: , oe_order_lines_all OEL
3251: , oe_order_headers_all OEH
3252: WHERE OEL.line_id = l_line_id
3253: AND oel.header_id = oeh.header_id
3254: AND WHS.whse_code = l_whse_code;
3255: ELSIF l_doc_type = 'PORC' THEN

Line 3260: , oe_order_headers_all OEH

3256: SELECT WHS.mtl_organization_id, oeh.ordered_date
3257: INTO l_organization_id, l_transaction_date
3258: FROM ic_whse_mst WHS
3259: , oe_order_lines_all OEL
3260: , oe_order_headers_all OEH
3261: , rcv_transactions RCT
3262: , po_requisition_headers_all poh
3263: , po_requisition_lines_all pol
3264: WHERE poh.requisition_header_id = pol.requisition_header_id

Line 3302: FROM oe_order_lines_all oel, oe_order_headers_all oeh

3298: -- this is a true drop ship with procuring flow
3299: BEGIN
3300: select oel.ship_from_org_id, oeh.ordered_date
3301: into l_organization_id, l_transaction_date
3302: FROM oe_order_lines_all oel, oe_order_headers_all oeh
3303: where oel.line_id = p_reference_id
3304: AND oel.header_id = oeh.header_id;
3305: EXCEPTION
3306: WHEN NO_DATA_FOUND then