APPS.CTO_AUTO_PROCURE_PK dependencies on MTL_SYSTEM_ITEMS_B

Line 1567: FROM mtl_system_items_b

1563: l_stmt_num := 110;
1564: Begin
1565: SELECT 'Y'
1566: into l_pegging_flag
1567: FROM mtl_system_items_b
1568: WHERE inventory_item_id = p_item_id
1569: AND organization_id = p_destination_org_id
1570: AND end_assembly_pegging_flag IN ('I','X');
1571: Exception

Line 4590: from mtl_system_items_b

4586: from inv_organization_info_v org,
4587: financials_system_params_all fsp,
4588: mtl_system_items msi
4589: where org.organization_id in (select organization_id
4590: from mtl_system_items_b
4591: where inventory_item_id = p_config_item_id)
4592: and fsp.org_id = org.operating_unit
4593: and msi.inventory_item_id = p_config_item_id
4594: and msi.organization_id = fsp.inventory_organization_id;