APPS.CSI_ORDER_SHIP_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 1781: FROM oe_order_headers_all ooh,

1777: to_number(null) ib_install_loc_id,
1778: to_char(null) ib_current_loc,
1779: to_number(null) ib_current_loc_id,
1780: ooh.order_source_id order_source_id -- Added for Siebel Genesis Project
1781: FROM oe_order_headers_all ooh,
1782: oe_order_lines_all ool,
1783: mtl_system_items msi,
1784: mtl_unit_transactions mut,
1785: mtl_material_transactions mmt,

Line 1841: FROM oe_order_headers_all ooh,

1837: to_number(null) ib_install_loc_id,
1838: to_char(null) ib_current_loc,
1839: to_number(null) ib_current_loc_id,
1840: ooh.order_source_id order_source_id -- Added for Siebel Genesis Project
1841: FROM oe_order_headers_all ooh,
1842: oe_order_lines_all ool,
1843: mtl_system_items msi,
1844: mtl_unit_transactions mut,
1845: mtl_transaction_lot_numbers mtln,

Line 4234: l_order_header_rec oe_order_headers_all%rowtype;

4230: l_owner_party_id number;
4231: l_owner_account_id number;
4232:
4233: l_order_line_rec oe_order_lines_all%rowtype;
4234: l_order_header_rec oe_order_headers_all%rowtype;
4235:
4236: l_location_type_code varchar2(80);
4237: l_inst_object_ver_num number;
4238:

Line 4274: FROM oe_order_headers_all

4270: FROM oe_order_lines_all
4271: WHERE line_id = p_line_id;
4272:
4273: SELECT * INTO l_order_header_rec
4274: FROM oe_order_headers_all
4275: WHERE header_id = l_order_line_rec.header_id;
4276:
4277: -- derive location
4278: