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.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 304: FROM mtl_item_sub_inventories mis

300: 2,--not be reservable
301: msub.reservable_type))
302:
303: AND EXISTS( SELECT NULL
304: FROM mtl_item_sub_inventories mis
305: WHERE mis.organization_id = NVL(p_organization_id, mis.organization_id)
306: AND mis.inventory_item_id = p_item_id
307: AND mis.secondary_inventory = msub.secondary_inventory_name)
308: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, msub.secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y'

Line 416: FROM mtl_item_sub_inventories mis

412: ),
413: msub.reservable_type
414: )
415: AND EXISTS( SELECT NULL
416: FROM mtl_item_sub_inventories mis
417: WHERE mis.organization_id = NVL(p_organization_id, mis.organization_id)
418: AND mis.inventory_item_id = p_item_id
419: AND mis.secondary_inventory = msub.secondary_inventory_name)
420: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, msub.secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y'

Line 573: FROM mtl_item_sub_inventories mis

569: 2,--not be reservable
570: msub.reservable_type))
571:
572: AND EXISTS( SELECT NULL
573: FROM mtl_item_sub_inventories mis
574: WHERE mis.organization_id = NVL(p_organization_id, mis.organization_id)
575: AND mis.inventory_item_id = p_item_id
576: AND mis.secondary_inventory = msub.secondary_inventory_name)
577: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, msub.secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y'

Line 685: FROM mtl_item_sub_inventories mis

681: ),
682: msub.reservable_type
683: )
684: AND EXISTS( SELECT NULL
685: FROM mtl_item_sub_inventories mis
686: WHERE mis.organization_id = NVL(p_organization_id, mis.organization_id)
687: AND mis.inventory_item_id = p_item_id
688: AND mis.secondary_inventory = msub.secondary_inventory_name)
689: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, msub.secondary_inventory_name, NULL, NULL, NULL, 'Z') = 'Y'

Line 1631: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1627: , a.description
1628: , a.asset_inventory
1629: , a.lpn_controlled_flag
1630: , a.enable_locator_alias
1631: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1632: WHERE a.organization_id = p_organization_id
1633: AND a.organization_id = b.organization_id
1634: AND b.inventory_item_id = p_inventory_item_id
1635: AND a.secondary_inventory_name = b.secondary_inventory

Line 1662: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1658: , a.description
1659: , a.asset_inventory
1660: , a.lpn_controlled_flag
1661: , a.enable_locator_alias
1662: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1663: WHERE a.organization_id = p_organization_id
1664: AND a.organization_id = b.organization_id
1665: AND a.secondary_inventory_name = b.secondary_inventory
1666: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1697: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1693: , a.description
1694: , a.asset_inventory
1695: , a.lpn_controlled_flag
1696: , a.enable_locator_alias
1697: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1698: WHERE a.organization_id = p_organization_id
1699: AND a.organization_id = b.organization_id
1700: AND a.secondary_inventory_name = b.secondary_inventory
1701: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1728: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1724: , a.description
1725: , a.asset_inventory
1726: , a.lpn_controlled_flag
1727: , a.enable_locator_alias
1728: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1729: WHERE a.organization_id = p_organization_id
1730: AND a.organization_id = b.organization_id
1731: AND a.secondary_inventory_name = b.secondary_inventory
1732: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1813: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1809: , a.description
1810: , a.asset_inventory
1811: , a.lpn_controlled_flag
1812: , a.enable_locator_alias
1813: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1814: WHERE a.organization_id = l_org
1815: AND a.organization_id = b.organization_id
1816: AND a.secondary_inventory_name = b.secondary_inventory
1817: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 1846: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1842: , a.description
1843: , a.asset_inventory
1844: , a.lpn_controlled_flag
1845: , a.enable_locator_alias
1846: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1847: WHERE a.organization_id = l_org
1848: AND a.organization_id = b.organization_id
1849: -- and a.asset_inventory = 1
1850: AND b.inventory_item_id = p_inventory_item_id

Line 1863: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1859: , a.description
1860: , a.asset_inventory
1861: , a.lpn_controlled_flag
1862: , a.enable_locator_alias
1863: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1864: WHERE a.organization_id = l_org
1865: AND a.organization_id = b.organization_id
1866: AND a.asset_inventory = 2
1867: AND b.inventory_item_id = p_inventory_item_id

Line 1881: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1877: , a.description
1878: , a.asset_inventory
1879: , a.lpn_controlled_flag
1880: , a.enable_locator_alias
1881: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1882: WHERE a.organization_id = l_org
1883: AND a.organization_id = b.organization_id
1884: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1885: AND a.secondary_inventory_name = b.secondary_inventory

Line 3256: FROM mtl_item_sub_inventories

3252: IF (NVL(l_expense_to_asset, '2') = '1') THEN
3253: IF l_restrict_subinventories_code = 1 THEN
3254: SELECT COUNT(*)
3255: INTO l_count
3256: FROM mtl_item_sub_inventories
3257: WHERE inventory_item_id = l_item_id
3258: AND organization_id = p_orgid
3259: AND secondary_inventory = p_to_subinventory;
3260:

Line 3276: FROM mtl_item_sub_inventories

3272: IF l_inventory_asset_flag = 'Y' THEN
3273: IF p_from_sub_asset_inventory = 1 THEN
3274: SELECT COUNT(*)
3275: INTO l_count
3276: FROM mtl_item_sub_inventories
3277: WHERE inventory_item_id = l_item_id
3278: AND organization_id = p_orgid
3279: AND secondary_inventory = p_to_subinventory;
3280:

Line 3305: FROM mtl_item_sub_inventories

3301: END IF;
3302: ELSE
3303: SELECT COUNT(*)
3304: INTO l_count
3305: FROM mtl_item_sub_inventories
3306: WHERE inventory_item_id = l_item_id
3307: AND organization_id = p_orgid
3308: AND secondary_inventory = p_to_subinventory;
3309:

Line 4896: FROM mtl_item_sub_inventories

4892: -- check that the sub is allowed
4893: IF (l_restrict_sub = 1) THEN
4894: SELECT COUNT(*)
4895: INTO l_count
4896: FROM mtl_item_sub_inventories
4897: WHERE organization_id = p_organization_id
4898: AND inventory_item_id = l_item_id
4899: AND secondary_inventory = p_subinventory_code;
4900:

Line 7030: mtl_item_sub_inventories misi

7026: , asset_inventory
7027: , lpn_controlled_flag
7028: , enable_locator_alias
7029: FROM mtl_secondary_inventories msi,
7030: mtl_item_sub_inventories misi
7031: WHERE msi.organization_id = p_organization_id
7032: AND msi.organization_id = misi.organization_id
7033: AND msi.secondary_inventory_name = misi.secondary_inventory
7034: AND misi.inventory_item_id = p_inventory_item_id