DBA Data[Home] [Help]

APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on FND_LOOKUP_VALUES

Line 188: fnd_lookup_values flv

184: msc_company_relationships r,
185: msc_plan_buckets mpb,
186: msc_full_pegging mfp,
187: msc_supplies sup,
188: fnd_lookup_values flv
189: where
190: /* msc_system_items msi pk:
191: SR_INSTANCE_ID
192: PLAN_ID

Line 423: fnd_lookup_values flv

419: msc_trading_partners t1,
420: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
421: msc_company_relationships r,
422: msc_plan_buckets mpb,
423: fnd_lookup_values flv
424: where
425: /* msc_system_items msi pk:
426: SR_INSTANCE_ID
427: PLAN_ID

Line 630: from fnd_lookup_values

626:
627: BEGIN
628: select MEANING
629: into G_SHIP_CONTROL
630: from fnd_lookup_values
631: where LOOKUP_TYPE = 'MSC_X_SHIPPING_CONTROL'
632: and LOOKUP_CODE =2
633: and language = l_language_code;
634:

Line 637: from fnd_lookup_values

633: and language = l_language_code;
634:
635: select MEANING
636: into G_ARRIVE_CONTROL
637: from fnd_lookup_values
638: where LOOKUP_TYPE = 'MSC_X_SHIPPING_CONTROL'
639: and LOOKUP_CODE =1
640: and language = l_language_code;
641: EXCEPTION