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.WMS_TASK_DISPATCH_GEN dependencies on INV_MATERIAL_STATUS_GRP

Line 4670: IF inv_material_status_grp.is_status_applicable(

4666: LOOP
4667: FETCH ser_csr INTO l_serial_number;
4668: EXIT WHEN ser_csr%NOTFOUND;
4669:
4670: IF inv_material_status_grp.is_status_applicable(
4671: p_wms_installed => p_wms_installed
4672: , p_trx_status_enabled => NULL
4673: , p_trx_type_id => p_transaction_type_id
4674: , p_lot_status_enabled => NULL

Line 4702: IF inv_material_status_grp.is_status_applicable(

4698: ELSE
4699: l_serial_number := NULL;
4700:
4701: -- Check whether the LPN status is applicable for this transaction
4702: IF inv_material_status_grp.is_status_applicable(
4703: p_wms_installed => p_wms_installed
4704: , p_trx_status_enabled => NULL
4705: , p_trx_type_id => p_transaction_type_id
4706: , p_lot_status_enabled => NULL

Line 14205: AND inv_material_status_grp.is_status_applicable(

14201: AND mln.inventory_item_id = p_item_id
14202: AND mln.lot_number LIKE(p_lot_number || '%')
14203: AND mtlt.lot_number = mln.lot_number
14204: AND mtlt.transaction_temp_id = p_txn_temp_id
14205: AND inv_material_status_grp.is_status_applicable(
14206: p_wms_installed
14207: , NULL
14208: , p_transaction_type_id
14209: , NULL

Line 14239: AND inv_material_status_grp.is_status_applicable(

14235: AND wlc.inventory_item_id = p_item_id
14236: AND wlc.organization_id = p_organization_id
14237: AND moq.subinventory_code = NVL(p_subinventory_code, moq.subinventory_code)
14238: AND NVL(moq.locator_id, -1) = NVL(NVL(p_locator_id, moq.locator_id), -1)
14239: AND inv_material_status_grp.is_status_applicable(
14240: p_wms_installed
14241: , NULL
14242: , p_transaction_type_id
14243: , NULL

Line 14273: AND inv_material_status_grp.is_status_applicable(

14269: AND mtlt.transaction_temp_id = p_txn_temp_id
14270: AND moq.containerized_flag = 2
14271: AND moq.subinventory_code = NVL(p_subinventory_code, moq.subinventory_code)
14272: AND NVL(moq.locator_id, -1) = NVL(NVL(p_locator_id, moq.locator_id), -1)
14273: AND inv_material_status_grp.is_status_applicable(
14274: p_wms_installed
14275: , NULL
14276: , p_transaction_type_id
14277: , NULL

Line 14306: AND inv_material_status_grp.is_status_applicable(

14302: AND wlc.inventory_item_id = p_item_id
14303: AND wlc.organization_id = p_organization_id
14304: AND moq.subinventory_code = NVL(p_subinventory_code, moq.subinventory_code)
14305: AND NVL(moq.locator_id, -1) = NVL(NVL(p_locator_id, moq.locator_id), -1)
14306: AND inv_material_status_grp.is_status_applicable(
14307: p_wms_installed
14308: , NULL
14309: , p_transaction_type_id
14310: , NULL

Line 14354: IF inv_material_status_grp.is_status_applicable(

14350: , l_item_id
14351: FROM mtl_material_transactions_temp mmtt
14352: WHERE mmtt.transaction_temp_id = p_temp_id;
14353:
14354: IF inv_material_status_grp.is_status_applicable(
14355: p_wms_installed => p_wms_installed
14356: , p_trx_status_enabled => NULL
14357: , p_trx_type_id => l_transaction_type_id
14358: , p_lot_status_enabled => NULL

Line 14368: AND inv_material_status_grp.is_status_applicable(

14364: , p_lot_number => NULL
14365: , p_serial_number => NULL
14366: , p_object_type => 'Z'
14367: ) = 'Y'
14368: AND inv_material_status_grp.is_status_applicable(
14369: p_wms_installed => p_wms_installed
14370: , p_trx_status_enabled => NULL
14371: , p_trx_type_id => l_transaction_type_id
14372: , p_lot_status_enabled => NULL