eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_PLAN_ORGANIZATIONS_V

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