DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on FND_LOOKUP_VALUES_VL

Line 1798: FROM fnd_lookup_values_vl flv,

1794: )
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

Line 1824: FROM fnd_lookup_values_vl flv,

1820: FROM DUAL
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'

Line 2198: FROM fnd_lookup_values_vl flv,

2194: )
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

Line 2224: FROM fnd_lookup_values_vl flv,

2220: FROM DUAL
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'

Line 2675: FROM fnd_lookup_values_vl flv,

2671: )
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

Line 2701: FROM fnd_lookup_values_vl flv,

2697: FROM DUAL
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'

Line 3117: FROM fnd_lookup_values_vl flv,

3113: )
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

Line 3143: FROM fnd_lookup_values_vl flv,

3139: FROM DUAL
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'

Line 3568: FROM fnd_lookup_values_vl flv,

3564: )
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

Line 3594: FROM fnd_lookup_values_vl flv,

3590: FROM DUAL
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'

Line 5823: FROM fnd_lookup_values_vl flv,

5819: AND AA.organization_id = from_org_id -- Added corresponding to Bug 6510185
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

Line 5849: FROM fnd_lookup_values_vl flv,

5845: FROM DUAL
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'

Line 8083: FROM fnd_lookup_values_vl flv,

8079: )
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

Line 8109: FROM fnd_lookup_values_vl flv,

8105: FROM DUAL
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'

Line 8452: FROM fnd_lookup_values_vl flv,

8448: )
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

Line 8478: FROM fnd_lookup_values_vl flv,

8474: FROM DUAL
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'

Line 8864: FROM fnd_lookup_values_vl flv,

8860: )
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

Line 8890: FROM fnd_lookup_values_vl flv,

8886: FROM DUAL
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'

Line 9265: FROM fnd_lookup_values_vl flv,

9261: )
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

Line 9291: FROM fnd_lookup_values_vl flv,

9287: FROM DUAL
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'

Line 9653: FROM fnd_lookup_values_vl flv,

9649: )
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

Line 9679: FROM fnd_lookup_values_vl flv,

9675: FROM DUAL
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'

Line 11447: FROM fnd_lookup_values_vl flv,

11443: AND AA.organization_id = from_org_id -- Added corresponding to Bug 6510185
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

Line 11473: FROM fnd_lookup_values_vl flv,

11469: FROM DUAL
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'