eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVPPROC dependencies on MTL_SYSTEM_ITEMS_B

Line 81: from mtl_system_items_b_kfv msk,

77:
78: CURSOR Flex_Exists IS
79: select msi.item_number,msi.organization_id,msi.organization_code,
80: msi.transaction_id,msi.process_flag
81: from mtl_system_items_b_kfv msk,
82: mtl_system_items_interface msi
83: where msi.item_number = msk.concatenated_segments
84: and msk.organization_id = msi.organization_id
85: AND msi.transaction_type = 'CREATE'

Line 308: INSERT INTO MTL_SYSTEM_ITEMS_B

304: * and last_update_date , records will always
305: * be inserted with sysdate timestamp
306: * bug 10373720 */
307:
308: INSERT INTO MTL_SYSTEM_ITEMS_B
309: (
310: INVENTORY_ITEM_ID,
311: ORGANIZATION_ID,
312: LAST_UPDATE_DATE,

Line 1716: FROM mtl_system_items_b i

1712: AND mic.organization_id = mp.organization_id
1713: AND mic.category_set_id = mdcs.category_set_id )
1714: AND EXISTS
1715: ( SELECT 'x'
1716: FROM mtl_system_items_b i
1717: WHERE
1718: i.inventory_item_id = msi.inventory_item_id
1719: AND i.organization_id = mp.organization_id
1720: );