[Home] [Help]
3035:
3036: BEGIN
3037: SELECT org_id, ship_from_org_id
3038: INTO l_selling_ou, l_ship_from_org_id
3039: FROM oe_order_lines_all
3040: WHERE
3041: header_id = l_header_id AND
3042: line_id = l_line_id;
3043: EXCEPTION
3246: IF l_doc_type = 'OMSO' THEN
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
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
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
3779:
3780: select l.ato_line_id,l.header_id
3781: into l_ato_line_id,l_order_header_id
3782: from mtl_material_transactions mmt
3783: , oe_order_lines_all l
3784: WHERE MMT.transaction_id = p_transaction_id
3785: AND l.line_id = mmt.trx_source_line_id;
3786:
3787: SELECT line_id
3785: AND l.line_id = mmt.trx_source_line_id;
3786:
3787: SELECT line_id
3788: INTO l_order_line_id
3789: from oe_order_lines_all
3790: where header_id=l_order_header_id
3791: and ato_line_id=l_ato_line_id
3792: and inventory_item_id=p_inventory_item_id;
3793: ELSE