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