APPS.CSI_ORDER_SHIP_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 1723: FROM oe_order_headers_all ooh,

1719: to_number(null) ib_install_loc_id,
1720: to_char(null) ib_current_loc,
1721: to_number(null) ib_current_loc_id,
1722: ooh.order_source_id order_source_id -- Added for Siebel Genesis Project
1723: FROM oe_order_headers_all ooh,
1724: oe_order_lines_all ool,
1725: mtl_system_items msi,
1726: mtl_unit_transactions mut,
1727: mtl_material_transactions mmt,

Line 1782: FROM oe_order_headers_all ooh,

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

Line 4155: l_order_header_rec oe_order_headers_all%rowtype;

4151: l_owner_party_id number;
4152: l_owner_account_id number;
4153:
4154: l_order_line_rec oe_order_lines_all%rowtype;
4155: l_order_header_rec oe_order_headers_all%rowtype;
4156:
4157: l_location_type_code varchar2(80);
4158: l_inst_object_ver_num number;
4159:

Line 4195: FROM oe_order_headers_all

4191: FROM oe_order_lines_all
4192: WHERE line_id = p_line_id;
4193:
4194: SELECT * INTO l_order_header_rec
4195: FROM oe_order_headers_all
4196: WHERE header_id = l_order_line_rec.header_id;
4197:
4198: -- derive location
4199: