[Home] [Help]
1795: AND EXISTS
1796: (
1797: SELECT 1
1798: FROM fnd_lookup_values_vl flv,
1799: ego_criteria_templates_v ectv,
1800: ego_criteria_v ecv,
1801: mtl_system_items_b msibs -- to assembly item
1802: WHERE ecv.customization_application_id = 702
1803: AND ecv.region_application_id = 702
1821: WHERE NOT EXISTS
1822: (
1823: SELECT 1
1824: FROM fnd_lookup_values_vl flv,
1825: ego_criteria_templates_v ectv,
1826: mtl_system_items_b msibs -- to assembly item
1827: WHERE flv.lookup_type = 'ITEM_TYPE'
1828: AND flv.enabled_flag = 'Y'
1829: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
2195: AND EXISTS
2196: (
2197: SELECT 1
2198: FROM fnd_lookup_values_vl flv,
2199: ego_criteria_templates_v ectv,
2200: ego_criteria_v ecv,
2201: mtl_system_items_b msibs -- to assembly item
2202: WHERE ecv.customization_application_id = 702
2203: AND ecv.region_application_id = 702
2221: WHERE NOT EXISTS
2222: (
2223: SELECT 1
2224: FROM fnd_lookup_values_vl flv,
2225: ego_criteria_templates_v ectv,
2226: mtl_system_items_b msibs -- to assembly item
2227: WHERE flv.lookup_type = 'ITEM_TYPE'
2228: AND flv.enabled_flag = 'Y'
2229: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
2672: AND EXISTS
2673: (
2674: SELECT 1
2675: FROM fnd_lookup_values_vl flv,
2676: ego_criteria_templates_v ectv,
2677: ego_criteria_v ecv,
2678: mtl_system_items_b msibs -- to assembly item
2679: WHERE ecv.customization_application_id = 702
2680: AND ecv.region_application_id = 702
2698: WHERE NOT EXISTS
2699: (
2700: SELECT 1
2701: FROM fnd_lookup_values_vl flv,
2702: ego_criteria_templates_v ectv,
2703: mtl_system_items_b msibs -- to assembly item
2704: WHERE flv.lookup_type = 'ITEM_TYPE'
2705: AND flv.enabled_flag = 'Y'
2706: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
3114: AND EXISTS
3115: (
3116: SELECT 1
3117: FROM fnd_lookup_values_vl flv,
3118: ego_criteria_templates_v ectv,
3119: ego_criteria_v ecv,
3120: mtl_system_items_b msibs -- to assembly item
3121: WHERE ecv.customization_application_id = 702
3122: AND ecv.region_application_id = 702
3140: WHERE NOT EXISTS
3141: (
3142: SELECT 1
3143: FROM fnd_lookup_values_vl flv,
3144: ego_criteria_templates_v ectv,
3145: mtl_system_items_b msibs -- to assembly item
3146: WHERE flv.lookup_type = 'ITEM_TYPE'
3147: AND flv.enabled_flag = 'Y'
3148: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
3565: AND EXISTS
3566: (
3567: SELECT 1
3568: FROM fnd_lookup_values_vl flv,
3569: ego_criteria_templates_v ectv,
3570: ego_criteria_v ecv,
3571: mtl_system_items_b msibs -- to assembly item
3572: WHERE ecv.customization_application_id = 702
3573: AND ecv.region_application_id = 702
3591: WHERE NOT EXISTS
3592: (
3593: SELECT 1
3594: FROM fnd_lookup_values_vl flv,
3595: ego_criteria_templates_v ectv,
3596: mtl_system_items_b msibs -- to assembly item
3597: WHERE flv.lookup_type = 'ITEM_TYPE'
3598: AND flv.enabled_flag = 'Y'
3599: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
5820: AND EXISTS
5821: (
5822: SELECT 1
5823: FROM fnd_lookup_values_vl flv,
5824: ego_criteria_templates_v ectv,
5825: ego_criteria_v ecv,
5826: mtl_system_items_b msibs -- to assembly item
5827: WHERE ecv.customization_application_id = 702
5828: AND ecv.region_application_id = 702
5846: WHERE NOT EXISTS
5847: (
5848: SELECT 1
5849: FROM fnd_lookup_values_vl flv,
5850: ego_criteria_templates_v ectv,
5851: mtl_system_items_b msibs -- to assembly item
5852: WHERE flv.lookup_type = 'ITEM_TYPE'
5853: AND flv.enabled_flag = 'Y'
5854: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
8080: AND EXISTS
8081: (
8082: SELECT 1
8083: FROM fnd_lookup_values_vl flv,
8084: ego_criteria_templates_v ectv,
8085: ego_criteria_v ecv,
8086: mtl_system_items_b msibs -- to assembly item
8087: WHERE ecv.customization_application_id = 702
8088: AND ecv.region_application_id = 702
8106: WHERE NOT EXISTS
8107: (
8108: SELECT 1
8109: FROM fnd_lookup_values_vl flv,
8110: ego_criteria_templates_v ectv,
8111: mtl_system_items_b msibs -- to assembly item
8112: WHERE flv.lookup_type = 'ITEM_TYPE'
8113: AND flv.enabled_flag = 'Y'
8114: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
8449: AND EXISTS
8450: (
8451: SELECT 1
8452: FROM fnd_lookup_values_vl flv,
8453: ego_criteria_templates_v ectv,
8454: ego_criteria_v ecv,
8455: mtl_system_items_b msibs -- to assembly item
8456: WHERE ecv.customization_application_id = 702
8457: AND ecv.region_application_id = 702
8475: WHERE NOT EXISTS
8476: (
8477: SELECT 1
8478: FROM fnd_lookup_values_vl flv,
8479: ego_criteria_templates_v ectv,
8480: mtl_system_items_b msibs -- to assembly item
8481: WHERE flv.lookup_type = 'ITEM_TYPE'
8482: AND flv.enabled_flag = 'Y'
8483: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
8861: AND EXISTS
8862: (
8863: SELECT 1
8864: FROM fnd_lookup_values_vl flv,
8865: ego_criteria_templates_v ectv,
8866: ego_criteria_v ecv,
8867: mtl_system_items_b msibs -- to assembly item
8868: WHERE ecv.customization_application_id = 702
8869: AND ecv.region_application_id = 702
8887: WHERE NOT EXISTS
8888: (
8889: SELECT 1
8890: FROM fnd_lookup_values_vl flv,
8891: ego_criteria_templates_v ectv,
8892: mtl_system_items_b msibs -- to assembly item
8893: WHERE flv.lookup_type = 'ITEM_TYPE'
8894: AND flv.enabled_flag = 'Y'
8895: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
9262: AND EXISTS
9263: (
9264: SELECT 1
9265: FROM fnd_lookup_values_vl flv,
9266: ego_criteria_templates_v ectv,
9267: ego_criteria_v ecv,
9268: mtl_system_items_b msibs -- to assembly item
9269: WHERE ecv.customization_application_id = 702
9270: AND ecv.region_application_id = 702
9288: WHERE NOT EXISTS
9289: (
9290: SELECT 1
9291: FROM fnd_lookup_values_vl flv,
9292: ego_criteria_templates_v ectv,
9293: mtl_system_items_b msibs -- to assembly item
9294: WHERE flv.lookup_type = 'ITEM_TYPE'
9295: AND flv.enabled_flag = 'Y'
9296: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
9650: AND EXISTS
9651: (
9652: SELECT 1
9653: FROM fnd_lookup_values_vl flv,
9654: ego_criteria_templates_v ectv,
9655: ego_criteria_v ecv,
9656: mtl_system_items_b msibs -- to assembly item
9657: WHERE ecv.customization_application_id = 702
9658: AND ecv.region_application_id = 702
9676: WHERE NOT EXISTS
9677: (
9678: SELECT 1
9679: FROM fnd_lookup_values_vl flv,
9680: ego_criteria_templates_v ectv,
9681: mtl_system_items_b msibs -- to assembly item
9682: WHERE flv.lookup_type = 'ITEM_TYPE'
9683: AND flv.enabled_flag = 'Y'
9684: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
11444: AND EXISTS
11445: (
11446: SELECT 1
11447: FROM fnd_lookup_values_vl flv,
11448: ego_criteria_templates_v ectv,
11449: ego_criteria_v ecv,
11450: mtl_system_items_b msibs -- to assembly item
11451: WHERE ecv.customization_application_id = 702
11452: AND ecv.region_application_id = 702
11470: WHERE NOT EXISTS
11471: (
11472: SELECT 1
11473: FROM fnd_lookup_values_vl flv,
11474: ego_criteria_templates_v ectv,
11475: mtl_system_items_b msibs -- to assembly item
11476: WHERE flv.lookup_type = 'ITEM_TYPE'
11477: AND flv.enabled_flag = 'Y'
11478: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)