DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on FND_LOOKUP_VALUES_VL

Line 1745: FROM fnd_lookup_values_vl flv,

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

Line 1771: FROM fnd_lookup_values_vl flv,

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

Line 2145: FROM fnd_lookup_values_vl flv,

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

Line 2171: FROM fnd_lookup_values_vl flv,

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

Line 2622: FROM fnd_lookup_values_vl flv,

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

Line 2648: FROM fnd_lookup_values_vl flv,

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

Line 3063: FROM fnd_lookup_values_vl flv,

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

Line 3089: FROM fnd_lookup_values_vl flv,

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

Line 3514: FROM fnd_lookup_values_vl flv,

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

Line 3540: FROM fnd_lookup_values_vl flv,

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

Line 5731: FROM fnd_lookup_values_vl flv,

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

Line 5757: FROM fnd_lookup_values_vl flv,

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

Line 7942: FROM fnd_lookup_values_vl flv,

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

Line 7968: FROM fnd_lookup_values_vl flv,

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

Line 8310: FROM fnd_lookup_values_vl flv,

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

Line 8336: FROM fnd_lookup_values_vl flv,

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

Line 8721: FROM fnd_lookup_values_vl flv,

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

Line 8747: FROM fnd_lookup_values_vl flv,

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

Line 9121: FROM fnd_lookup_values_vl flv,

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

Line 9147: FROM fnd_lookup_values_vl flv,

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

Line 9508: FROM fnd_lookup_values_vl flv,

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

Line 9534: FROM fnd_lookup_values_vl flv,

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

Line 11294: FROM fnd_lookup_values_vl flv,

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

Line 11320: FROM fnd_lookup_values_vl flv,

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