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

Line 533: FROM mtl_secondary_inventories

529:
530: CURSOR cur_sub_control (v_org_id NUMBER, v_subinventory VARCHAR2)
531: IS
532: SELECT locator_type
533: FROM mtl_secondary_inventories
534: WHERE organization_id = v_org_id
535: AND secondary_inventory_name = v_subinventory;
536: BEGIN
537: IF g_debug <= gme_debug.g_log_procedure THEN

Line 660: FROM mtl_secondary_inventories

656:
657: CURSOR cur_sub_control (v_org_id NUMBER, v_subinventory VARCHAR2)
658: IS
659: SELECT locator_type
660: FROM mtl_secondary_inventories
661: WHERE organization_id = v_org_id
662: AND secondary_inventory_name = v_subinventory;
663: BEGIN
664: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1786: FROM mtl_secondary_inventories

1782: v_org_id NUMBER
1783: ,v_subinventory VARCHAR2)
1784: IS
1785: SELECT NVL (locator_type, 1)
1786: FROM mtl_secondary_inventories
1787: WHERE organization_id = v_org_id
1788: AND secondary_inventory_name = v_subinventory;
1789: /* Bug 5441643 Added NVL condition for location control code*/
1790: CURSOR cur_item_details (v_org_id NUMBER, v_inventory_item_id NUMBER)