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_REL_PLAN_PUB dependencies on MSC_CALENDAR

Line 163: FROM msc_calendar_dates cal3,

159: lv_date date;
160: BEGIN
161: SELECT cal4.calendar_date
162: into lv_date
163: FROM msc_calendar_dates cal3,
164: msc_calendar_dates cal4
165: WHERE cal3.sr_instance_id = lv_inst_id
166: AND cal3.exception_set_id = -1
167: AND cal3.calendar_date = lv_calendar_date

Line 164: msc_calendar_dates cal4

160: BEGIN
161: SELECT cal4.calendar_date
162: into lv_date
163: FROM msc_calendar_dates cal3,
164: msc_calendar_dates cal4
165: WHERE cal3.sr_instance_id = lv_inst_id
166: AND cal3.exception_set_id = -1
167: AND cal3.calendar_date = lv_calendar_date
168: AND cal3.calendar_code = lv_calendar_code

Line 4344: DECODE(trunc(msc_calendar.date_offset

4340: DECODE(NVL(s.implement_alternate_bom, ''-23453''),
4341: NVL(s.alternate_bom_designator, ''-23453''),
4342: DECODE(NVL(s.implement_alternate_routing, ''-23453''),
4343: NVL(s.alternate_routing_designator, ''-23453''),
4344: DECODE(trunc(msc_calendar.date_offset
4345: (s.organization_id,
4346: s.sr_instance_id,
4347: 1, --daily bucket
4348: s.need_by_date ,

Line 6370: DECODE(trunc(msc_calendar.date_offset

6366: DECODE(NVL(s.implement_alternate_bom, ''-23453''),
6367: NVL(s.alternate_bom_designator, ''-23453''),
6368: DECODE(NVL(s.implement_alternate_routing, ''-23453''),
6369: NVL(s.alternate_routing_designator, ''-23453''),
6370: DECODE(trunc(msc_calendar.date_offset
6371: (s.organization_id,
6372: s.sr_instance_id,
6373: 1, --daily bucket
6374: s.need_by_date ,

Line 6669: trunc(msc_calendar.date_offset(

6665: decode( lv_details_enabled(j),1, -- If details and daily buckets
6666: GREATEST(trunc(sysdate),
6667: decode(v_rp_plan,
6668: 1,trunc(s.new_wip_start_date),
6669: trunc(msc_calendar.date_offset(
6670: s.organization_id,
6671: s.sr_instance_id,
6672: 1, --daily bucket
6673: s.need_by_date ,

Line 6679: GREATEST(trunc(sysdate),trunc( msc_calendar.date_offset

6675: nvl(msi.variable_lead_time,0) * s.implement_quantity)*-1 ) ) )
6676: )+(1439/1440)
6677: ,NULL),
6678: decode( lv_details_enabled(j),1, -- If details and daily buckets
6679: GREATEST(trunc(sysdate),trunc( msc_calendar.date_offset
6680: (s.organization_id,
6681: s.sr_instance_id,
6682: 1, --daily bucket
6683: s.need_by_date ,

Line 9648: --msc_calendar_dates cal1,

9644: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
9645: s.transaction_id,-- For Outbound Changes for XML
9646: s.sr_instance_id
9647: FROM msc_projects mpp,
9648: --msc_calendar_dates cal1,
9649: --msc_calendar_dates cal2,
9650: msc_tp_id_lid supplier,
9651: msc_trading_partner_sites mtps,
9652: msc_trading_partners mp, -- mtl_parameters mp,

Line 9649: --msc_calendar_dates cal2,

9645: s.transaction_id,-- For Outbound Changes for XML
9646: s.sr_instance_id
9647: FROM msc_projects mpp,
9648: --msc_calendar_dates cal1,
9649: --msc_calendar_dates cal2,
9650: msc_tp_id_lid supplier,
9651: msc_trading_partner_sites mtps,
9652: msc_trading_partners mp, -- mtl_parameters mp,
9653: msc_trading_partners mp1,

Line 9794: -- msc_calendar_dates cal1,

9790: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
9791: s.transaction_id, -- Outbound Changes for XML
9792: s.sr_instance_id
9793: FROM msc_projects mpp,
9794: -- msc_calendar_dates cal1,
9795: -- msc_calendar_dates cal2,
9796: msc_tp_id_lid supplier,
9797: msc_trading_partner_sites mtps,
9798: msc_trading_partners mp, -- mtl_parameters mp,

Line 9795: -- msc_calendar_dates cal2,

9791: s.transaction_id, -- Outbound Changes for XML
9792: s.sr_instance_id
9793: FROM msc_projects mpp,
9794: -- msc_calendar_dates cal1,
9795: -- msc_calendar_dates cal2,
9796: msc_tp_id_lid supplier,
9797: msc_trading_partner_sites mtps,
9798: msc_trading_partners mp, -- mtl_parameters mp,
9799: msc_trading_partners mp1,

Line 9939: -- msc_calendar_dates cal1,

9935: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
9936: s.transaction_id, --outbound changes for XML
9937: s.sr_instance_id
9938: FROM msc_projects mpp,
9939: -- msc_calendar_dates cal1,
9940: -- msc_calendar_dates cal2,
9941: msc_tp_id_lid supplier,
9942: msc_trading_partner_sites mtps,
9943: msc_trading_partners mp, -- mtl_parameters mp,

Line 9940: -- msc_calendar_dates cal2,

9936: s.transaction_id, --outbound changes for XML
9937: s.sr_instance_id
9938: FROM msc_projects mpp,
9939: -- msc_calendar_dates cal1,
9940: -- msc_calendar_dates cal2,
9941: msc_tp_id_lid supplier,
9942: msc_trading_partner_sites mtps,
9943: msc_trading_partners mp, -- mtl_parameters mp,
9944: msc_trading_partners mp1,

Line 10097: FROM --msc_calendar_dates cal1,

10093: s.transaction_id,
10094: nvl(s.implement_uom_code,msi.uom_code),
10095: s.sr_instance_id,
10096: g_batch_id
10097: FROM --msc_calendar_dates cal1,
10098: --msc_calendar_dates cal2,
10099: msc_trading_partners mp,
10100: msc_system_items msi,
10101: msc_supplies s,

Line 10098: --msc_calendar_dates cal2,

10094: nvl(s.implement_uom_code,msi.uom_code),
10095: s.sr_instance_id,
10096: g_batch_id
10097: FROM --msc_calendar_dates cal1,
10098: --msc_calendar_dates cal2,
10099: msc_trading_partners mp,
10100: msc_system_items msi,
10101: msc_supplies s,
10102: msc_apps_instances mai, -- IR/ISO resch Proj

Line 10156: FROM --msc_calendar_dates cal1,

10152: s.transaction_id,
10153: nvl(s.implement_uom_code,msi.uom_code),
10154: s.sr_instance_id,
10155: g_batch_id
10156: FROM --msc_calendar_dates cal1,
10157: --msc_calendar_dates cal2,
10158: msc_trading_partners mp,
10159: msc_system_items msi,
10160: msc_supplies s,

Line 10157: --msc_calendar_dates cal2,

10153: nvl(s.implement_uom_code,msi.uom_code),
10154: s.sr_instance_id,
10155: g_batch_id
10156: FROM --msc_calendar_dates cal1,
10157: --msc_calendar_dates cal2,
10158: msc_trading_partners mp,
10159: msc_system_items msi,
10160: msc_supplies s,
10161: msc_plan_organizations_v orgs

Line 10265: FROM --msc_calendar_dates cal1,

10261: lv_new_need_by_date,
10262: lv_po_header_id,
10263: lv_po_line_id,
10264: lv_po_number
10265: FROM --msc_calendar_dates cal1,
10266: --msc_calendar_dates cal2,
10267: msc_trading_partners mp,
10268: msc_system_items msi,
10269: msc_supplies s,

Line 10266: --msc_calendar_dates cal2,

10262: lv_po_header_id,
10263: lv_po_line_id,
10264: lv_po_number
10265: FROM --msc_calendar_dates cal1,
10266: --msc_calendar_dates cal2,
10267: msc_trading_partners mp,
10268: msc_system_items msi,
10269: msc_supplies s,
10270: msc_plan_organizations_v orgs