APPS.MSC_PURGE_LID dependencies on FND_LOOKUP_VALUES

Line 1841: ||' FROM fnd_lookup_values a,DBA_TAB_PARTITIONS b'

1837:
1838:
1839: lv_qry_str := 'SELECT table_name,partition_name '
1840:
1841: ||' FROM fnd_lookup_values a,DBA_TAB_PARTITIONS b'
1842:
1843: ||' WHERE a.attribute2 = b.table_name' -- (Not in MSC_%)see that meaning is there in upper case
1844:
1845: ||' AND b.table_owner = :B1'

Line 1927: FROM fnd_lookup_values a, dba_tables b

1923: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'******* Delete Rows for Instance *******');
1924:
1925: FOR tab IN ( SELECT attribute2 tname,ATTRIBUTE12 Plan_Id
1926:
1927: FROM fnd_lookup_values a, dba_tables b
1928:
1929: WHERE a.attribute2 = b.table_name
1930:
1931: AND b.owner = lv_schema

Line 2251: ||' FROM fnd_lookup_values a,DBA_TAB_PARTITIONS b'

2247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'******* Drop Plan Partition ***********');
2248:
2249: lv_qry_str := 'SELECT table_name,partition_name '
2250:
2251: ||' FROM fnd_lookup_values a,DBA_TAB_PARTITIONS b'
2252:
2253: ||' WHERE a.attribute2 = b.table_name' --
2254:
2255: ||' AND b.table_owner = :B1'

Line 2329: FROM fnd_lookup_values a,dba_tables b

2325: -- delete rows for Plan
2326:
2327: FOR tab IN (SELECT a.attribute2 tname
2328:
2329: FROM fnd_lookup_values a,dba_tables b
2330:
2331: WHERE a.attribute2 = b.table_name
2332:
2333: AND b.owner = lv_schema