[Home] [Help]
1742: AND EXISTS
1743: (
1744: SELECT 1
1745: FROM fnd_lookup_values_vl flv,
1746: ego_criteria_templates_v ectv,
1747: ego_criteria_v ecv,
1748: mtl_system_items_b msibs -- to assembly item
1749: WHERE ecv.customization_application_id = 702
1750: AND ecv.region_application_id = 702
1768: WHERE NOT EXISTS
1769: (
1770: SELECT 1
1771: FROM fnd_lookup_values_vl flv,
1772: ego_criteria_templates_v ectv,
1773: mtl_system_items_b msibs -- to assembly item
1774: WHERE flv.lookup_type = 'ITEM_TYPE'
1775: AND flv.enabled_flag = 'Y'
1776: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
2142: AND EXISTS
2143: (
2144: SELECT 1
2145: FROM fnd_lookup_values_vl flv,
2146: ego_criteria_templates_v ectv,
2147: ego_criteria_v ecv,
2148: mtl_system_items_b msibs -- to assembly item
2149: WHERE ecv.customization_application_id = 702
2150: AND ecv.region_application_id = 702
2168: WHERE NOT EXISTS
2169: (
2170: SELECT 1
2171: FROM fnd_lookup_values_vl flv,
2172: ego_criteria_templates_v ectv,
2173: mtl_system_items_b msibs -- to assembly item
2174: WHERE flv.lookup_type = 'ITEM_TYPE'
2175: AND flv.enabled_flag = 'Y'
2176: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
2619: AND EXISTS
2620: (
2621: SELECT 1
2622: FROM fnd_lookup_values_vl flv,
2623: ego_criteria_templates_v ectv,
2624: ego_criteria_v ecv,
2625: mtl_system_items_b msibs -- to assembly item
2626: WHERE ecv.customization_application_id = 702
2627: AND ecv.region_application_id = 702
2645: WHERE NOT EXISTS
2646: (
2647: SELECT 1
2648: FROM fnd_lookup_values_vl flv,
2649: ego_criteria_templates_v ectv,
2650: mtl_system_items_b msibs -- to assembly item
2651: WHERE flv.lookup_type = 'ITEM_TYPE'
2652: AND flv.enabled_flag = 'Y'
2653: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
3060: AND EXISTS
3061: (
3062: SELECT 1
3063: FROM fnd_lookup_values_vl flv,
3064: ego_criteria_templates_v ectv,
3065: ego_criteria_v ecv,
3066: mtl_system_items_b msibs -- to assembly item
3067: WHERE ecv.customization_application_id = 702
3068: AND ecv.region_application_id = 702
3086: WHERE NOT EXISTS
3087: (
3088: SELECT 1
3089: FROM fnd_lookup_values_vl flv,
3090: ego_criteria_templates_v ectv,
3091: mtl_system_items_b msibs -- to assembly item
3092: WHERE flv.lookup_type = 'ITEM_TYPE'
3093: AND flv.enabled_flag = 'Y'
3094: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
3511: AND EXISTS
3512: (
3513: SELECT 1
3514: FROM fnd_lookup_values_vl flv,
3515: ego_criteria_templates_v ectv,
3516: ego_criteria_v ecv,
3517: mtl_system_items_b msibs -- to assembly item
3518: WHERE ecv.customization_application_id = 702
3519: AND ecv.region_application_id = 702
3537: WHERE NOT EXISTS
3538: (
3539: SELECT 1
3540: FROM fnd_lookup_values_vl flv,
3541: ego_criteria_templates_v ectv,
3542: mtl_system_items_b msibs -- to assembly item
3543: WHERE flv.lookup_type = 'ITEM_TYPE'
3544: AND flv.enabled_flag = 'Y'
3545: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
5728: AND EXISTS
5729: (
5730: SELECT 1
5731: FROM fnd_lookup_values_vl flv,
5732: ego_criteria_templates_v ectv,
5733: ego_criteria_v ecv,
5734: mtl_system_items_b msibs -- to assembly item
5735: WHERE ecv.customization_application_id = 702
5736: AND ecv.region_application_id = 702
5754: WHERE NOT EXISTS
5755: (
5756: SELECT 1
5757: FROM fnd_lookup_values_vl flv,
5758: ego_criteria_templates_v ectv,
5759: mtl_system_items_b msibs -- to assembly item
5760: WHERE flv.lookup_type = 'ITEM_TYPE'
5761: AND flv.enabled_flag = 'Y'
5762: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
7939: AND EXISTS
7940: (
7941: SELECT 1
7942: FROM fnd_lookup_values_vl flv,
7943: ego_criteria_templates_v ectv,
7944: ego_criteria_v ecv,
7945: mtl_system_items_b msibs -- to assembly item
7946: WHERE ecv.customization_application_id = 702
7947: AND ecv.region_application_id = 702
7965: WHERE NOT EXISTS
7966: (
7967: SELECT 1
7968: FROM fnd_lookup_values_vl flv,
7969: ego_criteria_templates_v ectv,
7970: mtl_system_items_b msibs -- to assembly item
7971: WHERE flv.lookup_type = 'ITEM_TYPE'
7972: AND flv.enabled_flag = 'Y'
7973: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
8307: AND EXISTS
8308: (
8309: SELECT 1
8310: FROM fnd_lookup_values_vl flv,
8311: ego_criteria_templates_v ectv,
8312: ego_criteria_v ecv,
8313: mtl_system_items_b msibs -- to assembly item
8314: WHERE ecv.customization_application_id = 702
8315: AND ecv.region_application_id = 702
8333: WHERE NOT EXISTS
8334: (
8335: SELECT 1
8336: FROM fnd_lookup_values_vl flv,
8337: ego_criteria_templates_v ectv,
8338: mtl_system_items_b msibs -- to assembly item
8339: WHERE flv.lookup_type = 'ITEM_TYPE'
8340: AND flv.enabled_flag = 'Y'
8341: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
8718: AND EXISTS
8719: (
8720: SELECT 1
8721: FROM fnd_lookup_values_vl flv,
8722: ego_criteria_templates_v ectv,
8723: ego_criteria_v ecv,
8724: mtl_system_items_b msibs -- to assembly item
8725: WHERE ecv.customization_application_id = 702
8726: AND ecv.region_application_id = 702
8744: WHERE NOT EXISTS
8745: (
8746: SELECT 1
8747: FROM fnd_lookup_values_vl flv,
8748: ego_criteria_templates_v ectv,
8749: mtl_system_items_b msibs -- to assembly item
8750: WHERE flv.lookup_type = 'ITEM_TYPE'
8751: AND flv.enabled_flag = 'Y'
8752: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
9118: AND EXISTS
9119: (
9120: SELECT 1
9121: FROM fnd_lookup_values_vl flv,
9122: ego_criteria_templates_v ectv,
9123: ego_criteria_v ecv,
9124: mtl_system_items_b msibs -- to assembly item
9125: WHERE ecv.customization_application_id = 702
9126: AND ecv.region_application_id = 702
9144: WHERE NOT EXISTS
9145: (
9146: SELECT 1
9147: FROM fnd_lookup_values_vl flv,
9148: ego_criteria_templates_v ectv,
9149: mtl_system_items_b msibs -- to assembly item
9150: WHERE flv.lookup_type = 'ITEM_TYPE'
9151: AND flv.enabled_flag = 'Y'
9152: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
9505: AND EXISTS
9506: (
9507: SELECT 1
9508: FROM fnd_lookup_values_vl flv,
9509: ego_criteria_templates_v ectv,
9510: ego_criteria_v ecv,
9511: mtl_system_items_b msibs -- to assembly item
9512: WHERE ecv.customization_application_id = 702
9513: AND ecv.region_application_id = 702
9531: WHERE NOT EXISTS
9532: (
9533: SELECT 1
9534: FROM fnd_lookup_values_vl flv,
9535: ego_criteria_templates_v ectv,
9536: mtl_system_items_b msibs -- to assembly item
9537: WHERE flv.lookup_type = 'ITEM_TYPE'
9538: AND flv.enabled_flag = 'Y'
9539: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
11291: AND EXISTS
11292: (
11293: SELECT 1
11294: FROM fnd_lookup_values_vl flv,
11295: ego_criteria_templates_v ectv,
11296: ego_criteria_v ecv,
11297: mtl_system_items_b msibs -- to assembly item
11298: WHERE ecv.customization_application_id = 702
11299: AND ecv.region_application_id = 702
11317: WHERE NOT EXISTS
11318: (
11319: SELECT 1
11320: FROM fnd_lookup_values_vl flv,
11321: ego_criteria_templates_v ectv,
11322: mtl_system_items_b msibs -- to assembly item
11323: WHERE flv.lookup_type = 'ITEM_TYPE'
11324: AND flv.enabled_flag = 'Y'
11325: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)