APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_STATUS_TRANSACTION_CONTROL

Line 355: mtl_status_transaction_control mtc

351: FROM dual
352: WHERE EXISTS
353: (SELECT 1
354: FROM mtl_onhand_quantities_detail moqd,
355: mtl_status_transaction_control mtc
356: WHERE moqd.organization_id = p_organization_id
357: AND moqd.inventory_item_id = p_inventory_item_id
358: AND moqd.subinventory_code = p_sub_code
359: AND nvl(moqd.locator_id,-999) = nvl(p_locator_id,-999) --6974887

Line 388: mtl_status_transaction_control mtc

384: FROM dual
385: WHERE EXISTS
386: (SELECT 1
387: FROM mtl_onhand_quantities_detail moqd,
388: mtl_status_transaction_control mtc
389: WHERE moqd.organization_id = l_xfer_org_id
390: AND moqd.inventory_item_id = p_inventory_item_id
391: AND NVL(moqd.lot_number,'@@@') = NVL(p_lot_number,'@@@')
392: AND moqd.lpn_id = p_xfer_lpn_id

Line 416: mtl_status_transaction_control mtc

412: FROM dual
413: WHERE EXISTS
414: (SELECT 1
415: FROM mtl_onhand_quantities_detail moqd,
416: mtl_status_transaction_control mtc
417: WHERE moqd.organization_id = l_xfer_org_id
418: AND moqd.inventory_item_id = p_inventory_item_id
419: AND moqd.subinventory_code = l_xfer_sub_code
420: AND nvl(moqd.locator_id,-999) = nvl(l_xfer_locator_id,-999) --6974887 --could be null for INV sub-inventories(doubt)

Line 476: mtl_status_transaction_control mtc

472: FROM dual
473: WHERE EXISTS
474: (SELECT 1
475: FROM mtl_onhand_quantities_detail moqd,
476: mtl_status_transaction_control mtc
477: WHERE moqd.organization_id = p_organization_id
478: AND moqd.subinventory_code = p_sub_code
479: AND moqd.locator_id = p_locator_id
480: -- AND NVL(moqd.lot_number,'@@@') = NVL(p_lot_number,'@@@')

Line 510: mtl_status_transaction_control mtc

506: WHERE EXISTS
507: (SELECT 1
508: FROM wms_lpn_contents wlc ,
509: mtl_serial_numbers msn,
510: mtl_status_transaction_control mtc
511: WHERE wlc.parent_lpn_id IN
512: (SELECT lpn_id
513: FROM wms_license_plate_numbers START
514: WITH lpn_id = p_fromlpn_id CONNECT BY parent_lpn_id = PRIOR lpn_id

Line 540: mtl_status_transaction_control mtc

536: FROM dual
537: WHERE EXISTS
538: (SELECT 1
539: FROM mtl_onhand_quantities_detail moqd,
540: mtl_status_transaction_control mtc
541: WHERE moqd.organization_id = l_xfer_org_id
542: AND moqd.lpn_id = p_xfer_lpn_id
543: AND moqd.status_id = mtc.status_id
544: AND mtc.transaction_type_id = p_trx_type_id

Line 599: from mtl_status_transaction_control

595: IF p_status_id <> nvl(g_status_id,-9999) OR
596: p_transaction_type_id <> nvl(g_transaction_type_id,-9999) THEN
597: select is_allowed
598: into allowed
599: from mtl_status_transaction_control
600: where status_id = p_status_id
601: and transaction_type_id = p_transaction_type_id;
602:
603: g_status_id := p_status_id;

Line 3555: mtl_status_transaction_control mtc

3551: FROM dual
3552: WHERE EXISTS
3553: (SELECT 1
3554: FROM mtl_onhand_quantities_detail moqd,
3555: mtl_status_transaction_control mtc
3556: WHERE moqd.organization_id = p_xfer_org_id
3557: AND moqd.inventory_item_id = l_mmtt_cur.inventory_item_id
3558: AND NVL(moqd.lot_number,'@@@') = NVL(l_mtlt_cur.lot_number,'@@@')
3559: AND moqd.lpn_id = p_xfer_lpn_id