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.

[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on INV_MATERIAL_STATUS_GRP

Line 3459: 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'

3455: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3456: AND b.subinventory_code = p_subinventory_code
3457: AND a.inventory_location_id = b.secondary_locator
3458: AND a.concatenated_segments LIKE (p_concatenated_segments||'%')
3459: 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'
3460: ORDER BY a.concatenated_segments;
3461: ELSE --Locators not restricted
3462: OPEN x_locators FOR
3463: SELECT inventory_location_id

Line 3471: 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'

3467: WHERE organization_id = l_org
3468: AND subinventory_code = p_subinventory_code
3469: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3470: AND concatenated_segments LIKE (p_concatenated_segments||'%')
3471: 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'
3472: ORDER BY concatenated_segments;
3473: END IF;
3474: END get_valid_to_locs;
3475:

Line 3527: 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'

3523: AND a.inventory_location_id = b.secondary_locator
3524: AND inv_project.get_locsegs(a.inventory_location_id, l_org) LIKE (p_concatenated_segments||'%')
3525: AND NVL(a.project_id, -1) = NVL(p_project_id, -1)
3526: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
3527: 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'
3528: ORDER BY 2;
3529: ELSE --Locators not restricted
3530: OPEN x_locators FOR
3531: SELECT inventory_location_id

Line 3541: 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'

3537: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3538: AND inv_project.get_locsegs(inventory_location_id, l_org) LIKE (p_concatenated_segments||'%')
3539: AND NVL(project_id, -1) = NVL(p_project_id, -1)
3540: AND NVL(task_id, -1) = NVL(p_task_id, -1)
3541: 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'
3542: ORDER BY 2;
3543: END IF;
3544: END get_valid_prj_to_locs;
3545: -------------------------------------------------------------------------------

Line 3646: l_status_allowed := inv_material_status_grp.is_status_applicable

3642: RETURN;
3643: END IF;
3644:
3645: -- Check if the serial number is available to be transacted for this transaction
3646: l_status_allowed := inv_material_status_grp.is_status_applicable
3647: (p_wms_installed => p_wms_installed,
3648: p_trx_status_enabled => NULL,
3649: p_trx_type_id => p_transaction_type_id,
3650: p_lot_status_enabled => NULL,