APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on FND_LOOKUP_VALUES

Line 1557: FROM fnd_lookup_values

1553: lv_prod_short_name varchar2(30);
1554:
1555: CURSOR c_tab_list IS
1556: SELECT attribute1 application_id, attribute2 table_name
1557: FROM fnd_lookup_values
1558: WHERE lookup_type = 'MSC_STAGING_TABLE' AND
1559: enabled_flag = 'Y' AND
1560: view_application_id = 700 AND
1561: language = userenv('lang') AND

Line 1620: FROM fnd_lookup_values flv

1616: CURSOR c_tab_list IS
1617: SELECT flv.attribute1 application_id,
1618: flv.attribute2 table_name,
1619: substr(flv.attribute2, 8) || '_' || p_instance_id partition_name
1620: FROM fnd_lookup_values flv
1621: WHERE flv.lookup_type = 'MSC_STAGING_TABLE' AND
1622: flv.enabled_flag = 'Y' AND
1623: flv.view_application_id = 700 AND
1624: flv.language = userenv('lang') AND

Line 1672: FROM fnd_lookup_values

1668: lv_prod_short_name varchar2(30);
1669:
1670: CURSOR c_tab_list IS
1671: SELECT attribute1 application_id, attribute2 table_name
1672: FROM fnd_lookup_values
1673: WHERE lookup_type = 'MSC_STAGING_TABLE' AND
1674: enabled_flag = 'Y' AND
1675: view_application_id = 700 AND
1676: language = userenv('lang') AND

Line 1729: FROM fnd_lookup_values

1725: lv_prod_short_name varchar2(30);
1726:
1727: CURSOR c_tab_list IS
1728: SELECT attribute1 application_id, attribute2 table_name
1729: FROM fnd_lookup_values
1730: WHERE lookup_type = 'MSC_STAGING_TABLE' AND
1731: enabled_flag = 'Y' AND
1732: view_application_id = 700 AND
1733: language = userenv('lang') AND