APPS.MSC_ATP_PROC dependencies on FND_COMMON_LOOKUPS

Line 3743: -- ' , fnd_common_lookups fnd '||

3739: ',:last_update_by' ||
3740: ',:last_update_login ' ||
3741: ' FROM msc_interorg_ship_methods msim '||
3742: ' , msc_regions_temp mrt '||
3743: -- ' , fnd_common_lookups fnd '||
3744: ' WHERE mrt.session_id = :x_session_id '||
3745: ' AND msim.plan_id = -1 '||
3746: ' AND msim.from_location_id = :l_from_location_id '||
3747: ' AND msim.sr_instance_id = :source_instance_id '||

Line 3826: FROM FND_common_lookups fnd

3822: IF l_sources.SHIP_METHOD(counter) IS NOT null THEN
3823: BEGIN
3824: select fnd.meaning
3825: into l_other_cols.ship_method_text(counter)
3826: FROM FND_common_lookups fnd
3827: where FND.LOOKUP_CODE = l_sources.SHIP_METHOD(counter)
3828: AND FND.LOOKUP_TYPE = 'SHIP_METHOD'
3829: AND fND.APPLICATION_ID = 401;
3830: EXCEPTION

Line 4000: fROM FND_common_lookups FND

3996: END IF;
3997: BEGIN
3998: select fnd.meaning
3999: into x_other_cols.ship_method_text(counter)
4000: fROM FND_common_lookups FND
4001: where FND.LOOKUP_CODE = x_atp_sources.SHIP_METHOD(counter)
4002: AND FND.LOOKUP_TYPE = 'SHIP_METHOD'
4003: AND fND.APPLICATION_ID = 401;
4004: EXCEPTION