[Home] [Help]
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
1804: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
2204: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
2681: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
3123: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
3574: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
5829: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
8089: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
8458: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
8870: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
9271: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
9659: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
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
11453: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'