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.FLM_KANBAN_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 175: mtl_secondary_inventories mss,

171: SELECT mp.stock_locator_control_code,
172: mss.locator_type,
173: msi.location_control_code
174: FROM mtl_parameters mp,
175: mtl_secondary_inventories mss,
176: mtl_system_items_b msi
177: WHERE mp.organization_id = p_organization_id
178: AND mss.secondary_inventory_name = p_subinventory_name
179: AND mss.organization_id = p_organization_id

Line 543: CURSOR c_subinv(p_subinv_name IN mtl_secondary_inventories.secondary_inventory_name%TYPE

539: WHERE msi.inventory_item_id = p_inventory_item_id
540: AND msi.organization_id = p_organization_id;
541:
542: -- cursor to validate subinventory
543: CURSOR c_subinv(p_subinv_name IN mtl_secondary_inventories.secondary_inventory_name%TYPE
544: ,p_org_id IN mtl_secondary_inventories.organization_id%TYPE)
545: IS
546: SELECT misi.secondary_inventory_name
547: FROM mtl_secondary_inventories misi

Line 544: ,p_org_id IN mtl_secondary_inventories.organization_id%TYPE)

540: AND msi.organization_id = p_organization_id;
541:
542: -- cursor to validate subinventory
543: CURSOR c_subinv(p_subinv_name IN mtl_secondary_inventories.secondary_inventory_name%TYPE
544: ,p_org_id IN mtl_secondary_inventories.organization_id%TYPE)
545: IS
546: SELECT misi.secondary_inventory_name
547: FROM mtl_secondary_inventories misi
548: WHERE misi.secondary_inventory_name = p_subinv_name

Line 547: FROM mtl_secondary_inventories misi

543: CURSOR c_subinv(p_subinv_name IN mtl_secondary_inventories.secondary_inventory_name%TYPE
544: ,p_org_id IN mtl_secondary_inventories.organization_id%TYPE)
545: IS
546: SELECT misi.secondary_inventory_name
547: FROM mtl_secondary_inventories misi
548: WHERE misi.secondary_inventory_name = p_subinv_name
549: AND ( misi.disable_date > SYSDATE
550: OR misi.disable_date IS NULL )
551: AND misi.organization_id = p_org_id;

Line 1707: CURSOR c_subinv (p_subinv_name IN mtl_secondary_inventories.secondary_inventory_name%TYPE,

1703: WHERE msi.inventory_item_id = p_inventory_item_id
1704: AND msi.organization_id = p_organization_id;
1705:
1706: -- cursor to validate subinventory
1707: CURSOR c_subinv (p_subinv_name IN mtl_secondary_inventories.secondary_inventory_name%TYPE,
1708: p_org_id IN mtl_secondary_inventories.organization_id%TYPE
1709: )
1710: IS
1711: SELECT misi.secondary_inventory_name

Line 1708: p_org_id IN mtl_secondary_inventories.organization_id%TYPE

1704: AND msi.organization_id = p_organization_id;
1705:
1706: -- cursor to validate subinventory
1707: CURSOR c_subinv (p_subinv_name IN mtl_secondary_inventories.secondary_inventory_name%TYPE,
1708: p_org_id IN mtl_secondary_inventories.organization_id%TYPE
1709: )
1710: IS
1711: SELECT misi.secondary_inventory_name
1712: FROM mtl_secondary_inventories misi

Line 1712: FROM mtl_secondary_inventories misi

1708: p_org_id IN mtl_secondary_inventories.organization_id%TYPE
1709: )
1710: IS
1711: SELECT misi.secondary_inventory_name
1712: FROM mtl_secondary_inventories misi
1713: WHERE misi.secondary_inventory_name = p_subinv_name
1714: AND (misi.disable_date > SYSDATE
1715: OR misi.disable_date IS NULL)
1716: AND misi.organization_id = p_org_id;