APPS.CSI_ORDER_SHIP_PUB dependencies on MTL_SYSTEM_ITEMS

Line 33: FROM mtl_system_items msi,

29: x_return_status OUT NOCOPY varchar2)
30: IS
31: CURSOR ato_option_cur(p_ato_line_id in number) IS
32: SELECT oel.line_id
33: FROM mtl_system_items msi,
34: oe_order_lines_all oel
35: WHERE oel.ato_line_id = p_ato_line_id
36: AND oel.item_type_code = 'OPTION'
37: AND nvl(oel.cancelled_flag,'N') <> 'Y'

Line 1783: mtl_system_items msi,

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,
1786: mtl_secondary_inventories msei,
1787: hr_all_organization_units haou

Line 1843: mtl_system_items msi,

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,
1846: mtl_material_transactions mmt,
1847: mtl_secondary_inventories msei,

Line 4441: mtl_system_items msi

4437: sum(required_quantity) qty_required,
4438: sum(quantity_issued) qty_issued,
4439: sum(quantity_per_assembly) qty_per_assy
4440: FROM wip_requirement_operations wip,
4441: mtl_system_items msi
4442: WHERE wip_entity_id = p_wip_entity_id
4443: AND wip.organization_id = p_organization_id
4444: AND wip.inventory_item_id = msi.inventory_item_id
4445: AND wip.organization_id = msi.organization_id

Line 4502: FROM mtl_system_items

4498: IF req_rec.qty_per_assy > 0 THEN
4499:
4500: SELECT serial_number_control_code
4501: INTO l_serial_code
4502: FROM mtl_system_items
4503: WHERE inventory_item_id = req_rec.inventory_item_id
4504: AND organization_id = p_organization_id;
4505:
4506: IF l_serial_code in (2, 5) THEN

Line 4992: FROM mtl_system_items

4988: IF l_config_rec.line_id is not null THEN
4989:
4990: SELECT serial_number_control_code
4991: INTO l_config_rec.serial_code
4992: FROM mtl_system_items
4993: WHERE inventory_item_id = l_config_rec.item_id
4994: AND organization_id = l_config_rec.ship_organization_id;
4995:
4996: csi_order_fulfill_pub.get_job_for_config_line(