[Home] [Help]
217: msc_plan_organizations_v ov,
218: msc_system_items item,
219: msc_companies c,
220: msc_company_sites s,
221: msc_trading_partners t,
222: msc_trading_partner_maps m,
223: msc_plans p
224: WHERE p.plan_id = mst.plan_id
225: and mst.plan_id = p_plan_id
378: DECODE(rec.order_type, DIS_JOB_BY, -1, NON_ST_JOB_BY, -1,
379: REP_SCHED_BY, -1, PLANNED_BY, -1,
380: FLOW_SCHED_BY, -1, 1))) new_quantity
381: FROM msc_plans p,
382: msc_trading_partners param,
383: msc_system_items msi,
384: msc_supplies rec,
385: msc_plan_buckets mpb,
386: msc_plan_organizations_v ov,
385: msc_plan_buckets mpb,
386: msc_plan_organizations_v ov,
387: msc_companies c,
388: msc_company_sites s,
389: msc_trading_partners t,
390: msc_trading_partner_maps m
391: WHERE p.plan_id = p_plan_id
392: AND p.plan_id = msi.plan_id
393: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id)
516: nvl(LEAST(SUM(DECODE(mgr.origination_type,
517: 29,nvl(mgr.probability,0),
518: null)) ,1) ,1)) new_quantity
519: FROM msc_plans p,
520: msc_trading_partners param,
521: msc_system_items msi,
522: msc_demands mgr,
523: msc_plan_buckets mpb,
524: msc_plan_organizations_v ov,
523: msc_plan_buckets mpb,
524: msc_plan_organizations_v ov,
525: msc_companies c,
526: msc_company_sites s,
527: msc_trading_partners t,
528: msc_trading_partner_maps m
529: WHERE p.plan_id = p_plan_id
530: AND p.plan_id = mgr.plan_id
531: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id )
667: DECODE(rec.order_type, DIS_JOB_BY, -1, NON_ST_JOB_BY, -1,
668: REP_SCHED_BY, -1, PLANNED_BY, -1,
669: FLOW_SCHED_BY, -1, 1))) new_quantity
670: FROM msc_plans p,
671: msc_trading_partners param,
672: msc_system_items msi,
673: msc_supplies rec,
674: msc_companies c,
675: msc_company_sites s,
672: msc_system_items msi,
673: msc_supplies rec,
674: msc_companies c,
675: msc_company_sites s,
676: msc_trading_partners t,
677: msc_trading_partner_maps m
678: WHERE p.plan_id = p_plan_id
679: AND p.plan_id = msi.plan_id
680: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id)
794: nvl(LEAST(SUM(DECODE(mgr.origination_type,
795: 29,nvl(mgr.probability,0),
796: null)) ,1) ,1)) new_quantity
797: FROM msc_plans p,
798: msc_trading_partners param,
799: msc_system_items msi,
800: msc_demands mgr,
801: msc_companies c,
802: msc_company_sites s,
799: msc_system_items msi,
800: msc_demands mgr,
801: msc_companies c,
802: msc_company_sites s,
803: msc_trading_partners t,
804: msc_trading_partner_maps m
805: WHERE p.plan_id = p_plan_id
806: AND p.plan_id = mgr.plan_id
807: AND msi.inventory_item_id = nvl(p_item_id, msi.inventory_item_id )
1043: --dbms_output.put_line('p_sr_instance_id := ' || p_sr_instance_id);
1044:
1045: select sr_tp_id
1046: into p_org_id
1047: from msc_trading_partners
1048: where organization_code = p_org_code and
1049: sr_instance_id = p_sr_instance_id and
1050: partner_type = 3 and
1051: company_id is null;
1114:
1115: IF p_supplier_id IS NOT NULL THEN
1116: SELECT partner_name
1117: INTO l_supp_name
1118: FROM msc_trading_partners
1119: WHERE partner_id = p_supplier_id;
1120: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPPLIER',l_language_code) || ': ' || l_supp_name || fnd_global.local_chr(10);
1121: END IF;
1122:
1627: t_pub_site(j)
1628: from msc_companies c,
1629: msc_company_sites s,
1630: msc_trading_partner_maps m,
1631: msc_trading_partners t
1632: where t.sr_tp_id = t_org_id(j) and
1633: t.sr_instance_id = t_sr_instance_id(j) and
1634: t.partner_type = 3 and
1635: m.tp_key = t.partner_id and
3325: exists (select cs.company_site_id
3326: from msc_plan_organizations o,
3327: msc_company_sites cs,
3328: msc_trading_partner_maps m,
3329: msc_trading_partners p
3330: where o.plan_id = p_plan_id and
3331: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
3332: p.sr_instance_id = nvl(p_sr_instance_id,
3333: o.sr_instance_id) and
3355: exists (select cs.company_site_id
3356: from msc_plan_organizations o,
3357: msc_company_sites cs,
3358: msc_trading_partner_maps m,
3359: msc_trading_partners p
3360: where o.plan_id = p_plan_id and
3361: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
3362: p.sr_instance_id = nvl(p_sr_instance_id,
3363: o.sr_instance_id) and