APPS.INV_UI_ITEM_LOVS dependencies on MTL_STATUS_TRANSACTION_CONTROL

Line 886: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

882: AND msik.inventory_item_id = mln.inventory_item_id
883: AND mln.lot_number = p_lot_number
884: AND mln.organization_id = p_organization_id
885: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
886: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
887: WHERE status_id = mln.status_id
888: AND transaction_type_id = p_transaction_type_id
889: AND is_allowed = 2))
890:

Line 955: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

951: AND (mcr.organization_id = msik.organization_id
952: OR
953: mcr.org_independent_flag = 'Y')
954: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
955: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
956: WHERE status_id = mln.status_id
957: AND transaction_type_id = p_transaction_type_id
958: AND is_allowed = 2))
959: ORDER BY concatenated_segments;

Line 1017: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

1013: AND msik.inventory_item_id = mln.inventory_item_id
1014: AND mln.lot_number = p_lot_number
1015: AND mln.organization_id = p_organization_id
1016: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
1017: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
1018: WHERE status_id = mln.status_id
1019: AND transaction_type_id = p_transaction_type_id
1020: AND is_allowed = 2))
1021:

Line 1086: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

1082: AND (mcr.organization_id = msik.organization_id
1083: OR
1084: mcr.org_independent_flag = 'Y')
1085: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
1086: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
1087: WHERE status_id = mln.status_id
1088: AND transaction_type_id = p_transaction_type_id
1089: AND is_allowed = 2))
1090: ORDER BY concatenated_segments;

Line 1147: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

1143: AND msik.inventory_item_id = mln.inventory_item_id
1144: AND mln.lot_number = p_lot_number
1145: AND mln.organization_id = p_organization_id
1146: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
1147: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
1148: WHERE status_id = mln.status_id
1149: AND transaction_type_id = p_transaction_type_id
1150: AND is_allowed = 2))
1151:

Line 1214: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control

1210: AND (mcr.organization_id = msik.organization_id
1211: OR
1212: mcr.org_independent_flag = 'Y')
1213: AND (NVL(msik.lot_status_enabled, 'N') = 'N'
1214: OR NOT EXISTS (SELECT 1 FROM mtl_status_transaction_control
1215: WHERE status_id = mln.status_id
1216: AND transaction_type_id = p_transaction_type_id
1217: AND is_allowed = 2))
1218: ORDER BY concatenated_segments;