APPS.MSC_ATP_PROC dependencies on FND_COMMON_LOOKUPS

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

3748: ',:last_update_by' ||
3749: ',:last_update_login ' ||
3750: ' FROM msc_interorg_ship_methods msim '||
3751: ' , msc_regions_temp mrt '||
3752: -- ' , fnd_common_lookups fnd '||
3753: ' WHERE mrt.session_id = :x_session_id '||
3754: ' AND msim.plan_id = -1 '||
3755: ' AND msim.from_location_id = :l_from_location_id '||
3756: ' AND msim.sr_instance_id = :source_instance_id '||

Line 3835: FROM FND_common_lookups fnd

3831: IF l_sources.SHIP_METHOD(counter) IS NOT null THEN
3832: BEGIN
3833: select fnd.meaning
3834: into l_other_cols.ship_method_text(counter)
3835: FROM FND_common_lookups fnd
3836: where FND.LOOKUP_CODE = l_sources.SHIP_METHOD(counter)
3837: AND FND.LOOKUP_TYPE = 'SHIP_METHOD'
3838: AND fND.APPLICATION_ID = 401;
3839: EXCEPTION

Line 4009: fROM FND_common_lookups FND

4005: END IF;
4006: BEGIN
4007: select fnd.meaning
4008: into x_other_cols.ship_method_text(counter)
4009: fROM FND_common_lookups FND
4010: where FND.LOOKUP_CODE = x_atp_sources.SHIP_METHOD(counter)
4011: AND FND.LOOKUP_TYPE = 'SHIP_METHOD'
4012: AND fND.APPLICATION_ID = 401;
4013: EXCEPTION