APPS.INV_UI_ITEM_LOVS dependencies on MTL_STATUS_TRANSACTION_CONTROL

Line 778: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

774: AND msik.inventory_item_id = mln.inventory_item_id
775: AND mln.lot_number = p_lot_number
776: AND mln.organization_id = p_organization_id
777: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
778: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
779: WHERE status_id = mln.status_id
780: AND transaction_type_id = p_transaction_type_id
781: AND is_allowed = 2))
782:

Line 846: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

842: AND (mcr.organization_id = msik.organization_id
843: OR
844: mcr.org_independent_flag = 'Y')
845: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
846: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
847: WHERE status_id = mln.status_id
848: AND transaction_type_id = p_transaction_type_id
849: AND is_allowed = 2))
850: ORDER BY concatenated_segments;

Line 907: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

903: AND msik.inventory_item_id = mln.inventory_item_id
904: AND mln.lot_number = p_lot_number
905: AND mln.organization_id = p_organization_id
906: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
907: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
908: WHERE status_id = mln.status_id
909: AND transaction_type_id = p_transaction_type_id
910: AND is_allowed = 2))
911:

Line 975: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

971: AND (mcr.organization_id = msik.organization_id
972: OR
973: mcr.org_independent_flag = 'Y')
974: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
975: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
976: WHERE status_id = mln.status_id
977: AND transaction_type_id = p_transaction_type_id
978: AND is_allowed = 2))
979: ORDER BY concatenated_segments;

Line 1035: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

1031: AND msik.inventory_item_id = mln.inventory_item_id
1032: AND mln.lot_number = p_lot_number
1033: AND mln.organization_id = p_organization_id
1034: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
1035: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
1036: WHERE status_id = mln.status_id
1037: AND transaction_type_id = p_transaction_type_id
1038: AND is_allowed = 2))
1039:

Line 1101: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

1097: AND (mcr.organization_id = msik.organization_id
1098: OR
1099: mcr.org_independent_flag = 'Y')
1100: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
1101: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
1102: WHERE status_id = mln.status_id
1103: AND transaction_type_id = p_transaction_type_id
1104: AND is_allowed = 2))
1105: ORDER BY concatenated_segments;