DBA Data[Home] [Help]

APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on FND_LOOKUP_VALUES

Line 179: fnd_lookup_values flv

175: msc_company_relationships r,
176: msc_plan_buckets mpb,
177: msc_full_pegging mfp,
178: msc_supplies sup,
179: fnd_lookup_values flv
180: where
181: /* msc_system_items msi pk:
182: SR_INSTANCE_ID
183: PLAN_ID

Line 414: fnd_lookup_values flv

410: msc_trading_partners t1,
411: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
412: msc_company_relationships r,
413: msc_plan_buckets mpb,
414: fnd_lookup_values flv
415: where
416: /* msc_system_items msi pk:
417: SR_INSTANCE_ID
418: PLAN_ID

Line 603: from fnd_lookup_values

599:
600: BEGIN
601: select MEANING
602: into G_SHIP_CONTROL
603: from fnd_lookup_values
604: where LOOKUP_TYPE = 'MSC_X_SHIPPING_CONTROL'
605: and LOOKUP_CODE =2
606: and language = l_language_code;
607:

Line 610: from fnd_lookup_values

606: and language = l_language_code;
607:
608: select MEANING
609: into G_ARRIVE_CONTROL
610: from fnd_lookup_values
611: where LOOKUP_TYPE = 'MSC_X_SHIPPING_CONTROL'
612: and LOOKUP_CODE =1
613: and language = l_language_code;
614: EXCEPTION