APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_STATUS_TRANSACTION_CONTROL

Line 369: mtl_status_transaction_control mtc

365: FROM dual
366: WHERE EXISTS
367: (SELECT 1
368: FROM mtl_onhand_quantities_detail moqd,
369: mtl_status_transaction_control mtc
370: WHERE moqd.organization_id = p_organization_id
371: AND moqd.inventory_item_id = p_inventory_item_id
372: AND moqd.subinventory_code = p_sub_code
373: AND nvl(moqd.locator_id,-999) = nvl(p_locator_id,-999) --6974887

Line 402: mtl_status_transaction_control mtc

398: FROM dual
399: WHERE EXISTS
400: (SELECT 1
401: FROM mtl_onhand_quantities_detail moqd,
402: mtl_status_transaction_control mtc
403: WHERE moqd.organization_id = l_xfer_org_id
404: AND moqd.inventory_item_id = p_inventory_item_id
405: AND NVL(moqd.lot_number,'@@@') = NVL(p_lot_number,'@@@')
406: AND moqd.lpn_id = p_xfer_lpn_id

Line 430: mtl_status_transaction_control mtc

426: FROM dual
427: WHERE EXISTS
428: (SELECT 1
429: FROM mtl_onhand_quantities_detail moqd,
430: mtl_status_transaction_control mtc
431: WHERE moqd.organization_id = l_xfer_org_id
432: AND moqd.inventory_item_id = p_inventory_item_id
433: AND moqd.subinventory_code = l_xfer_sub_code
434: AND nvl(moqd.locator_id,-999) = nvl(l_xfer_locator_id,-999) --6974887 --could be null for INV sub-inventories(doubt)

Line 490: mtl_status_transaction_control mtc

486: FROM dual
487: WHERE EXISTS
488: (SELECT 1
489: FROM mtl_onhand_quantities_detail moqd,
490: mtl_status_transaction_control mtc
491: WHERE moqd.organization_id = p_organization_id
492: AND moqd.subinventory_code = p_sub_code
493: AND moqd.locator_id = p_locator_id
494: -- AND NVL(moqd.lot_number,'@@@') = NVL(p_lot_number,'@@@')

Line 524: mtl_status_transaction_control mtc

520: WHERE EXISTS
521: (SELECT 1
522: FROM wms_lpn_contents wlc ,
523: mtl_serial_numbers msn,
524: mtl_status_transaction_control mtc
525: WHERE wlc.parent_lpn_id IN
526: (SELECT lpn_id
527: FROM wms_license_plate_numbers START
528: WITH lpn_id = p_fromlpn_id CONNECT BY parent_lpn_id = PRIOR lpn_id

Line 554: mtl_status_transaction_control mtc

550: FROM dual
551: WHERE EXISTS
552: (SELECT 1
553: FROM mtl_onhand_quantities_detail moqd,
554: mtl_status_transaction_control mtc
555: WHERE moqd.organization_id = l_xfer_org_id
556: AND moqd.lpn_id = p_xfer_lpn_id
557: AND moqd.status_id = mtc.status_id
558: AND mtc.transaction_type_id = p_trx_type_id

Line 613: from mtl_status_transaction_control

609: IF p_status_id <> nvl(g_status_id,-9999) OR
610: p_transaction_type_id <> nvl(g_transaction_type_id,-9999) THEN
611: select is_allowed
612: into allowed
613: from mtl_status_transaction_control
614: where status_id = p_status_id
615: and transaction_type_id = p_transaction_type_id;
616:
617: g_status_id := p_status_id;

Line 4091: mtl_status_transaction_control mtc

4087: FROM dual
4088: WHERE EXISTS
4089: (SELECT 1
4090: FROM mtl_onhand_quantities_detail moqd,
4091: mtl_status_transaction_control mtc
4092: WHERE moqd.organization_id = p_xfer_org_id
4093: AND moqd.inventory_item_id = l_mmtt_cur.inventory_item_id
4094: AND NVL(moqd.lot_number,'@@@') = NVL(l_mtlt_cur.lot_number,'@@@')
4095: AND moqd.lpn_id = p_xfer_lpn_id