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_TXN_VALIDATIONS dependencies on INV_MATERIAL_STATUS_GRP

Line 3738: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, l_org, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'

3734: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3735: AND b.subinventory_code = p_subinventory_code
3736: AND a.inventory_location_id = b.secondary_locator
3737: AND a.concatenated_segments LIKE (p_concatenated_segments||'%')
3738: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, l_org, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'
3739: ORDER BY a.concatenated_segments;
3740: ELSE --Locators not restricted
3741: OPEN x_locators FOR
3742: SELECT inventory_location_id

Line 3750: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, l_org, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'

3746: WHERE organization_id = l_org
3747: AND subinventory_code = p_subinventory_code
3748: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3749: AND concatenated_segments LIKE (p_concatenated_segments||'%')
3750: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, l_org, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'
3751: ORDER BY concatenated_segments;
3752: END IF;
3753: END get_valid_to_locs;
3754:

Line 3806: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, l_org, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'

3802: AND a.inventory_location_id = b.secondary_locator
3803: AND inv_project.get_locsegs(a.inventory_location_id, l_org) LIKE (p_concatenated_segments||'%')
3804: AND NVL(a.project_id, -1) = NVL(p_project_id, -1)
3805: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
3806: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, l_org, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'
3807: ORDER BY 2;
3808: ELSE --Locators not restricted
3809: OPEN x_locators FOR
3810: SELECT inventory_location_id

Line 3820: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, l_org, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'

3816: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3817: AND inv_project.get_locsegs(inventory_location_id, l_org) LIKE (p_concatenated_segments||'%')
3818: AND NVL(project_id, -1) = NVL(p_project_id, -1)
3819: AND NVL(task_id, -1) = NVL(p_task_id, -1)
3820: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, l_org, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'
3821: ORDER BY 2;
3822: END IF;
3823: END get_valid_prj_to_locs;
3824: -------------------------------------------------------------------------------

Line 3925: l_status_allowed := inv_material_status_grp.is_status_applicable

3921: RETURN;
3922: END IF;
3923:
3924: -- Check if the serial number is available to be transacted for this transaction
3925: l_status_allowed := inv_material_status_grp.is_status_applicable
3926: (p_wms_installed => p_wms_installed,
3927: p_trx_status_enabled => NULL,
3928: p_trx_type_id => p_transaction_type_id,
3929: p_lot_status_enabled => NULL,