APPS.CSM_MULTI_MOBQRY_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 1395: SELECT INVENTORY_ITEM_ID FROM MTL_SYSTEM_ITEMS_B

1391: PRAGMA AUTONOMOUS_TRANSACTION;
1392:
1393: CURSOR c_get_item(p_item VARCHAR2, p_org_id NUMBER)
1394: IS
1395: SELECT INVENTORY_ITEM_ID FROM MTL_SYSTEM_ITEMS_B
1396: WHERE UPPER(SEGMENT1) = UPPER(p_item)
1397: AND ORGANIZATION_ID = p_ORG_ID;
1398:
1399:

Line 1778: FROM mtl_system_items_b msi, mtl_system_items_tl msi_tl

1774: msi.comms_nl_trackable_flag , msi.stock_enabled_flag, msi.attribute1 , msi.attribute2 , msi.attribute3 , msi.attribute4 , msi.attribute5 , msi.attribute6 ,
1775: msi.attribute7 , msi.attribute8 , msi.attribute9 , msi.attribute10 , msi.attribute11 , msi.attribute12, msi.attribute13 , msi.attribute14 , msi.attribute15 ,
1776: msi.attribute_category, msi.contract_item_type_code, msi.recovered_part_disp_code, msi.revision_qty_control_code, msi.RESTRICT_LOCATORS_CODE,
1777: msi.LOCATION_CONTROL_CODE, msi.LIST_PRICE_PER_UNIT, UPPER(msi.segment1) AS inventory_name_upper
1778: FROM mtl_system_items_b msi, mtl_system_items_tl msi_tl
1779: WHERE msi_tl.inventory_item_id = msi.inventory_item_id AND msi_tl.organization_id = msi.organization_id AND msi_tl.language = asg_base.get_language(p_user_name)
1780: AND msi.segment1 like l_item_name AND msi.organization_id=P_ORG_ID and rownum<=11 order by msi.segment1)
1781: --at client limiting to 10 items found , showing 11 for them to know that more exists here
1782: LOOP