[Home] [Help]
214: msc_plan_organizations_v ov,
215: msc_system_items item,
216: msc_companies c,
217: msc_company_sites s,
218: msc_trading_partners t,
219: msc_trading_partner_maps m,
220: msc_plans p
221: WHERE p.plan_id = mst.plan_id
222: and mst.plan_id = p_plan_id
375: DECODE(rec.order_type, DIS_JOB_BY, -1, NON_ST_JOB_BY, -1,
376: REP_SCHED_BY, -1, PLANNED_BY, -1,
377: FLOW_SCHED_BY, -1, 1))) new_quantity
378: FROM msc_plans p,
379: msc_trading_partners param,
380: msc_system_items msi,
381: msc_supplies rec,
382: msc_plan_buckets mpb,
383: msc_plan_organizations_v ov,
382: msc_plan_buckets mpb,
383: msc_plan_organizations_v ov,
384: msc_companies c,
385: msc_company_sites s,
386: msc_trading_partners t,
387: msc_trading_partner_maps m
388: WHERE p.plan_id = p_plan_id
389: AND p.plan_id = msi.plan_id
390: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id)
513: nvl(LEAST(SUM(DECODE(mgr.origination_type,
514: 29,nvl(mgr.probability,0),
515: null)) ,1) ,1)) new_quantity
516: FROM msc_plans p,
517: msc_trading_partners param,
518: msc_system_items msi,
519: msc_demands mgr,
520: msc_plan_buckets mpb,
521: msc_plan_organizations_v ov,
520: msc_plan_buckets mpb,
521: msc_plan_organizations_v ov,
522: msc_companies c,
523: msc_company_sites s,
524: msc_trading_partners t,
525: msc_trading_partner_maps m
526: WHERE p.plan_id = p_plan_id
527: AND p.plan_id = mgr.plan_id
528: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id )
664: DECODE(rec.order_type, DIS_JOB_BY, -1, NON_ST_JOB_BY, -1,
665: REP_SCHED_BY, -1, PLANNED_BY, -1,
666: FLOW_SCHED_BY, -1, 1))) new_quantity
667: FROM msc_plans p,
668: msc_trading_partners param,
669: msc_system_items msi,
670: msc_supplies rec,
671: msc_companies c,
672: msc_company_sites s,
669: msc_system_items msi,
670: msc_supplies rec,
671: msc_companies c,
672: msc_company_sites s,
673: msc_trading_partners t,
674: msc_trading_partner_maps m
675: WHERE p.plan_id = p_plan_id
676: AND p.plan_id = msi.plan_id
677: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id)
791: nvl(LEAST(SUM(DECODE(mgr.origination_type,
792: 29,nvl(mgr.probability,0),
793: null)) ,1) ,1)) new_quantity
794: FROM msc_plans p,
795: msc_trading_partners param,
796: msc_system_items msi,
797: msc_demands mgr,
798: msc_companies c,
799: msc_company_sites s,
796: msc_system_items msi,
797: msc_demands mgr,
798: msc_companies c,
799: msc_company_sites s,
800: msc_trading_partners t,
801: msc_trading_partner_maps m
802: WHERE p.plan_id = p_plan_id
803: AND p.plan_id = mgr.plan_id
804: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id )
1027: --dbms_output.put_line('p_sr_instance_id := ' || p_sr_instance_id);
1028:
1029: select sr_tp_id
1030: into p_org_id
1031: from msc_trading_partners
1032: where organization_code = p_org_code and
1033: sr_instance_id = p_sr_instance_id and
1034: partner_type = 3 and
1035: company_id is null;
1098:
1099: IF p_supplier_id IS NOT NULL THEN
1100: SELECT partner_name
1101: INTO l_supp_name
1102: FROM msc_trading_partners
1103: WHERE partner_id = p_supplier_id;
1104: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPPLIER',l_language_code) || ': ' || l_supp_name || fnd_global.local_chr(10);
1105: END IF;
1106:
1611: t_pub_site(j)
1612: from msc_companies c,
1613: msc_company_sites s,
1614: msc_trading_partner_maps m,
1615: msc_trading_partners t
1616: where t.sr_tp_id = t_org_id(j) and
1617: t.sr_instance_id = t_sr_instance_id(j) and
1618: t.partner_type = 3 and
1619: m.tp_key = t.partner_id and
3309: exists (select cs.company_site_id
3310: from msc_plan_organizations o,
3311: msc_company_sites cs,
3312: msc_trading_partner_maps m,
3313: msc_trading_partners p
3314: where o.plan_id = p_plan_id and
3315: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
3316: p.sr_instance_id = nvl(p_sr_instance_id,
3317: o.sr_instance_id) and
3339: exists (select cs.company_site_id
3340: from msc_plan_organizations o,
3341: msc_company_sites cs,
3342: msc_trading_partner_maps m,
3343: msc_trading_partners p
3344: where o.plan_id = p_plan_id and
3345: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
3346: p.sr_instance_id = nvl(p_sr_instance_id,
3347: o.sr_instance_id) and