APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_PLAN_ORGANIZATIONS

Line 175: from msc_plan_organizations_v ov,

171: decode(sup.firm_date, null, sup.new_ship_date , null), --ship_date
172: decode(sup.firm_date,null,nvl(sup.new_dock_date,msc_calendar.DATE_OFFSET(sup.organization_id, sup.sr_instance_id, 1, sup.new_schedule_date, - nvl(i.postprocessing_lead_time,0))),
173: msc_calendar.DATE_OFFSET(sup.organization_id,sup.sr_instance_id, 1,sup.firm_date, - nvl(i.postprocessing_lead_time,0))
174: ) --reciept_date
175: from msc_plan_organizations_v ov,
176: msc_system_items i,
177: msc_supplies sup,
178: msc_plan_buckets mpb
179: where ov.plan_id = p_plan_id and

Line 275: from msc_plan_organizations_v ov,

271: decode(sup.firm_date, null, sup.new_ship_date , null), --ship_date
272: decode(sup.firm_date,null,nvl(sup.new_dock_date,msc_calendar.DATE_OFFSET(sup.organization_id, sup.sr_instance_id, 1, sup.new_schedule_date, - nvl(i.postprocessing_lead_time,0))),
273: msc_calendar.DATE_OFFSET(sup.organization_id,sup.sr_instance_id, 1,sup.firm_date, - nvl(i.postprocessing_lead_time,0))
274: ) --reciept_date
275: from msc_plan_organizations_v ov,
276: msc_system_items i,
277: msc_supplies sup,
278: msc_trading_partners t1,
279: msc_plan_buckets mpb

Line 418: from msc_plan_organizations_v ov,

414: ), --reciept_date
415: -- order_number => order number for intransit shipment, NULL for Expected inbound shipment
416: sup.order_number order_number, -- use only for intransit_shipment_def and intransit_receipt_def
417: NULL line_number -- dummy type not to be used
418: from msc_plan_organizations_v ov,
419: msc_system_items i,
420: msc_supplies sup,
421: msc_trading_partners t1,
422: msc_plan_buckets mpb

Line 523: from msc_plan_organizations_v ov,

519: dem.schedule_arrival_date, --reciept_date
520: -- Order_number => .Order Only.ORDER ENTRY()
521: decode(instr(dem.order_number,'.'), 0 , dem.order_number, substr(dem.order_number,1,instr(dem.order_number,'.')-1 )),--
522: TRIM(decode(instr(dem.order_number,'(',-1,1),0,null,substr(dem.order_number,instr(dem.order_number,'(',-1,1) + 1,instr(dem.order_number,')',-1,1) - instr(dem.order_number,'(',-1,1) -1 ))) --
523: from msc_plan_organizations_v ov,
524: msc_system_items i,
525: msc_demands dem,
526: msc_trading_partners t1,
527: msc_plan_buckets mpb

Line 5127: from msc_plan_organizations o,

5123: RETURNS_FORECAST,DEFECTIVE_OUTBOUND_SHIPMENT) and -- bug#6893383
5124: sd.plan_id = -1 and
5125: sd.publisher_id = 1 and
5126: exists (select cs.company_site_id
5127: from msc_plan_organizations o,
5128: msc_company_sites cs,
5129: msc_trading_partner_maps m,
5130: msc_trading_partners p
5131: where o.plan_id = p_plan_id

Line 5146: msc_plan_organizations o

5142: sd.supplier_id = nvl(l_supplier_id, sd.supplier_id) and
5143: sd.supplier_site_id = nvl(l_supplier_site_id, sd.supplier_site_id) and
5144: exists (select nvl(i.base_item_id,i.inventory_item_id)
5145: from msc_system_items i,
5146: msc_plan_organizations o
5147: where o.plan_id = p_plan_id and
5148: i.plan_id = o.plan_id and
5149: O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID) AND
5150: O.SR_INSTANCE_ID = NVL(p_sr_instance_id , O.SR_INSTANCE_ID) AND

Line 5173: from msc_plan_organizations o,

5169: RETURNS_FORECAST,DEFECTIVE_OUTBOUND_SHIPMENT) and -- bug#6893383
5170: sd.plan_id = -1 and
5171: sd.publisher_id = 1 and
5172: exists (select cs.company_site_id
5173: from msc_plan_organizations o,
5174: msc_company_sites cs,
5175: msc_trading_partner_maps m,
5176: msc_trading_partners p
5177: where o.plan_id = p_plan_id and

Line 5192: msc_plan_organizations o

5188: sd.supplier_id = nvl(l_supplier_id, sd.supplier_id) and
5189: sd.supplier_site_id = nvl(l_supplier_site_id, sd.supplier_site_id) and
5190: exists (select nvl(i.base_item_id,i.inventory_item_id)
5191: from msc_system_items i,
5192: msc_plan_organizations o
5193: where o.plan_id = p_plan_id and
5194: i.plan_id = o.plan_id and
5195: i.organization_id = nvl(p_org_id,
5196: o.organization_id) and