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 172: from msc_plan_organizations_v ov,

168: decode(sup.firm_date, null, sup.new_ship_date , null), --ship_date
169: 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))),
170: msc_calendar.DATE_OFFSET(sup.organization_id,sup.sr_instance_id, 1,sup.firm_date, - nvl(i.postprocessing_lead_time,0))
171: ) --reciept_date
172: from msc_plan_organizations_v ov,
173: msc_system_items i,
174: msc_supplies sup,
175: msc_plan_buckets mpb
176: where ov.plan_id = p_plan_id and

Line 272: from msc_plan_organizations_v ov,

268: decode(sup.firm_date, null, sup.new_ship_date , null), --ship_date
269: 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))),
270: msc_calendar.DATE_OFFSET(sup.organization_id,sup.sr_instance_id, 1,sup.firm_date, - nvl(i.postprocessing_lead_time,0))
271: ) --reciept_date
272: from msc_plan_organizations_v ov,
273: msc_system_items i,
274: msc_supplies sup,
275: msc_trading_partners t1,
276: msc_plan_buckets mpb

Line 415: from msc_plan_organizations_v ov,

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

Line 520: from msc_plan_organizations_v ov,

516: dem.schedule_arrival_date, --reciept_date
517: -- Order_number => .Order Only.ORDER ENTRY()
518: decode(instr(dem.order_number,'.'), 0 , dem.order_number, substr(dem.order_number,1,instr(dem.order_number,'.')-1 )),--
519: 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 ))) --
520: from msc_plan_organizations_v ov,
521: msc_system_items i,
522: msc_demands dem,
523: msc_trading_partners t1,
524: msc_plan_buckets mpb