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

Line 3137: FROM mtl_secondary_inventories msub

3133: , NVL(msub.locator_type, 1)
3134: , msub.description
3135: , msub.asset_inventory
3136: , lpn_controlled_flag
3137: FROM mtl_secondary_inventories msub
3138: WHERE msub.organization_id = p_organization_id
3139: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3140: AND msub.secondary_inventory_name LIKE (p_sub)
3141: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL,

Line 3153: FROM mtl_secondary_inventories msub

3149: , NVL(msub.locator_type, 1)
3150: , msub.description
3151: , msub.asset_inventory
3152: , lpn_controlled_flag
3153: FROM mtl_secondary_inventories msub
3154: WHERE msub.organization_id = p_organization_id
3155: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3156: AND msub.secondary_inventory_name LIKE (p_sub)
3157: AND EXISTS( SELECT NULL

Line 3374: FROM mtl_secondary_inventories

3370: END IF;
3371:
3372: SELECT NVL(default_loc_status_id, 1)
3373: INTO l_sub_default_status
3374: FROM mtl_secondary_inventories
3375: WHERE organization_id = p_org_id
3376: AND secondary_inventory_name = p_sub_code;
3377:
3378: