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
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
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:
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