APPS.CTO_AUTO_PROCURE_PK dependencies on MTL_SYSTEM_ITEMS_B

Line 1890: FROM mtl_system_items_b

1886: l_stmt_num := 110;
1887: Begin
1888: SELECT 'Y'
1889: into l_pegging_flag
1890: FROM mtl_system_items_b
1891: WHERE inventory_item_id = p_item_id
1892: AND organization_id = p_destination_org_id
1893: AND end_assembly_pegging_flag IN ('I','X');
1894: Exception

Line 5002: from mtl_system_items_b

4998: from inv_organization_info_v org,
4999: financials_system_params_all fsp,
5000: mtl_system_items msi
5001: where org.organization_id in (select organization_id
5002: from mtl_system_items_b
5003: where inventory_item_id = p_config_item_id)
5004: and fsp.org_id = org.operating_unit
5005: and msi.inventory_item_id = p_config_item_id
5006: and msi.organization_id = fsp.inventory_organization_id;