APPS.CSP_PART_SEARCH_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1669: from mtl_system_items

1665:
1666: cursor c_item_attributes is
1667: select serial_number_control_code,
1668: revision_qty_control_code
1669: from mtl_system_items
1670: where organization_id = p_organization_id
1671: and inventory_item_id = p_inventory_item_id;
1672:
1673: cursor c_defective_sub is

Line 1694: from mtl_system_items_b

1690: -- if the MTL_TRANSACTIONS_ENABLED_FLAG is not Y no need to search for qty
1691: l_TRANSACTIONS_ENABLED := 'N'; -- closed world assumption
1692: select nvl(MTL_TRANSACTIONS_ENABLED_FLAG, 'N')
1693: into l_TRANSACTIONS_ENABLED
1694: from mtl_system_items_b
1695: where inventory_item_id = p_inventory_item_id
1696: and organization_id = p_organization_id;
1697: log('get_avail_qty','l_transactions_enabled:'||l_transactions_enabled);
1698: if l_TRANSACTIONS_ENABLED = 'N' then