DBA Data[Home] [Help]

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 13952: AND inv_material_status_grp.is_status_applicable(

13948: AND mln.inventory_item_id = p_item_id
13949: AND mln.lot_number LIKE(p_lot_number || '%')
13950: AND mtlt.lot_number = mln.lot_number
13951: AND mtlt.transaction_temp_id = p_txn_temp_id
13952: AND inv_material_status_grp.is_status_applicable(
13953: p_wms_installed
13954: , NULL
13955: , p_transaction_type_id
13956: , NULL

Line 13986: AND inv_material_status_grp.is_status_applicable(

13982: AND wlc.inventory_item_id = p_item_id
13983: AND wlc.organization_id = p_organization_id
13984: AND moq.subinventory_code = NVL(p_subinventory_code, moq.subinventory_code)
13985: AND NVL(moq.locator_id, -1) = NVL(NVL(p_locator_id, moq.locator_id), -1)
13986: AND inv_material_status_grp.is_status_applicable(
13987: p_wms_installed
13988: , NULL
13989: , p_transaction_type_id
13990: , NULL

Line 14020: AND inv_material_status_grp.is_status_applicable(

14016: AND mtlt.transaction_temp_id = p_txn_temp_id
14017: AND moq.containerized_flag = 2
14018: AND moq.subinventory_code = NVL(p_subinventory_code, moq.subinventory_code)
14019: AND NVL(moq.locator_id, -1) = NVL(NVL(p_locator_id, moq.locator_id), -1)
14020: AND inv_material_status_grp.is_status_applicable(
14021: p_wms_installed
14022: , NULL
14023: , p_transaction_type_id
14024: , NULL

Line 14053: AND inv_material_status_grp.is_status_applicable(

14049: AND wlc.inventory_item_id = p_item_id
14050: AND wlc.organization_id = p_organization_id
14051: AND moq.subinventory_code = NVL(p_subinventory_code, moq.subinventory_code)
14052: AND NVL(moq.locator_id, -1) = NVL(NVL(p_locator_id, moq.locator_id), -1)
14053: AND inv_material_status_grp.is_status_applicable(
14054: p_wms_installed
14055: , NULL
14056: , p_transaction_type_id
14057: , NULL

Line 14101: IF inv_material_status_grp.is_status_applicable(

14097: , l_item_id
14098: FROM mtl_material_transactions_temp mmtt
14099: WHERE mmtt.transaction_temp_id = p_temp_id;
14100:
14101: IF inv_material_status_grp.is_status_applicable(
14102: p_wms_installed => p_wms_installed
14103: , p_trx_status_enabled => NULL
14104: , p_trx_type_id => l_transaction_type_id
14105: , p_lot_status_enabled => NULL

Line 14115: AND inv_material_status_grp.is_status_applicable(

14111: , p_lot_number => NULL
14112: , p_serial_number => NULL
14113: , p_object_type => 'Z'
14114: ) = 'Y'
14115: AND inv_material_status_grp.is_status_applicable(
14116: p_wms_installed => p_wms_installed
14117: , p_trx_status_enabled => NULL
14118: , p_trx_type_id => l_transaction_type_id
14119: , p_lot_status_enabled => NULL