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.

APPS.MSC_REL_PLAN_PUB dependencies on MSC_CALENDAR

Line 155: FROM msc_calendar_dates cal3,

151: lv_date date;
152: BEGIN
153: SELECT cal4.calendar_date
154: into lv_date
155: FROM msc_calendar_dates cal3,
156: msc_calendar_dates cal4
157: WHERE cal3.sr_instance_id = lv_inst_id
158: AND cal3.exception_set_id = -1
159: AND cal3.calendar_date = lv_calendar_date

Line 156: msc_calendar_dates cal4

152: BEGIN
153: SELECT cal4.calendar_date
154: into lv_date
155: FROM msc_calendar_dates cal3,
156: msc_calendar_dates cal4
157: WHERE cal3.sr_instance_id = lv_inst_id
158: AND cal3.exception_set_id = -1
159: AND cal3.calendar_date = lv_calendar_date
160: AND cal3.calendar_code = lv_calendar_code

Line 3795: DECODE(trunc(msc_calendar.date_offset

3791: DECODE(NVL(s.implement_alternate_bom, ''-23453''),
3792: NVL(s.alternate_bom_designator, ''-23453''),
3793: DECODE(NVL(s.implement_alternate_routing, ''-23453''),
3794: NVL(s.alternate_routing_designator, ''-23453''),
3795: DECODE(trunc(msc_calendar.date_offset
3796: (s.organization_id,
3797: s.sr_instance_id,
3798: 1, --daily bucket
3799: s.need_by_date ,

Line 5791: DECODE(trunc(msc_calendar.date_offset

5787: DECODE(NVL(s.implement_alternate_bom, ''-23453''),
5788: NVL(s.alternate_bom_designator, ''-23453''),
5789: DECODE(NVL(s.implement_alternate_routing, ''-23453''),
5790: NVL(s.alternate_routing_designator, ''-23453''),
5791: DECODE(trunc(msc_calendar.date_offset
5792: (s.organization_id,
5793: s.sr_instance_id,
5794: 1, --daily bucket
5795: s.need_by_date ,

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

6017: s.new_wip_start_date),
6018: s.implement_date,
6019: /* Added to code to release the greatest of sysdate OR the BOM/Routing revision date */
6020: decode( lv_details_enabled(j),1, -- If details and daily buckets
6021: GREATEST(trunc(sysdate),trunc(msc_calendar.date_offset
6022: (s.organization_id,
6023: s.sr_instance_id,
6024: 1, --daily bucket
6025: s.need_by_date ,

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

6027: nvl(msi.variable_lead_time,0) * s.implement_quantity)*-1 ) )
6028: )+(1439/1440)
6029: ,NULL),
6030: decode( lv_details_enabled(j),1, -- If details and daily buckets
6031: GREATEST(trunc(sysdate),trunc( msc_calendar.date_offset
6032: (s.organization_id,
6033: s.sr_instance_id,
6034: 1, --daily bucket
6035: s.need_by_date ,

Line 8788: --msc_calendar_dates cal1,

8784: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
8785: s.transaction_id,-- For Outbound Changes for XML
8786: s.sr_instance_id
8787: FROM msc_projects mpp,
8788: --msc_calendar_dates cal1,
8789: --msc_calendar_dates cal2,
8790: msc_tp_id_lid supplier,
8791: msc_trading_partner_sites mtps,
8792: msc_trading_partners mp, -- mtl_parameters mp,

Line 8789: --msc_calendar_dates cal2,

8785: s.transaction_id,-- For Outbound Changes for XML
8786: s.sr_instance_id
8787: FROM msc_projects mpp,
8788: --msc_calendar_dates cal1,
8789: --msc_calendar_dates cal2,
8790: msc_tp_id_lid supplier,
8791: msc_trading_partner_sites mtps,
8792: msc_trading_partners mp, -- mtl_parameters mp,
8793: msc_trading_partners mp1,

Line 8931: -- msc_calendar_dates cal1,

8927: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
8928: s.transaction_id, -- Outbound Changes for XML
8929: s.sr_instance_id
8930: FROM msc_projects mpp,
8931: -- msc_calendar_dates cal1,
8932: -- msc_calendar_dates cal2,
8933: msc_tp_id_lid supplier,
8934: msc_trading_partner_sites mtps,
8935: msc_trading_partners mp, -- mtl_parameters mp,

Line 8932: -- msc_calendar_dates cal2,

8928: s.transaction_id, -- Outbound Changes for XML
8929: s.sr_instance_id
8930: FROM msc_projects mpp,
8931: -- msc_calendar_dates cal1,
8932: -- msc_calendar_dates cal2,
8933: msc_tp_id_lid supplier,
8934: msc_trading_partner_sites mtps,
8935: msc_trading_partners mp, -- mtl_parameters mp,
8936: msc_trading_partners mp1,

Line 9073: -- msc_calendar_dates cal1,

9069: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
9070: s.transaction_id, --outbound changes for XML
9071: s.sr_instance_id
9072: FROM msc_projects mpp,
9073: -- msc_calendar_dates cal1,
9074: -- msc_calendar_dates cal2,
9075: msc_tp_id_lid supplier,
9076: msc_trading_partner_sites mtps,
9077: msc_trading_partners mp, -- mtl_parameters mp,

Line 9074: -- msc_calendar_dates cal2,

9070: s.transaction_id, --outbound changes for XML
9071: s.sr_instance_id
9072: FROM msc_projects mpp,
9073: -- msc_calendar_dates cal1,
9074: -- msc_calendar_dates cal2,
9075: msc_tp_id_lid supplier,
9076: msc_trading_partner_sites mtps,
9077: msc_trading_partners mp, -- mtl_parameters mp,
9078: msc_trading_partners mp1,

Line 9228: FROM --msc_calendar_dates cal1,

9224: s.transaction_id,
9225: nvl(s.implement_uom_code,msi.uom_code),
9226: s.sr_instance_id,
9227: g_batch_id
9228: FROM --msc_calendar_dates cal1,
9229: --msc_calendar_dates cal2,
9230: msc_trading_partners mp,
9231: msc_system_items msi,
9232: msc_supplies s,

Line 9229: --msc_calendar_dates cal2,

9225: nvl(s.implement_uom_code,msi.uom_code),
9226: s.sr_instance_id,
9227: g_batch_id
9228: FROM --msc_calendar_dates cal1,
9229: --msc_calendar_dates cal2,
9230: msc_trading_partners mp,
9231: msc_system_items msi,
9232: msc_supplies s,
9233: msc_apps_instances mai, -- IR/ISO resch Proj

Line 9287: FROM --msc_calendar_dates cal1,

9283: s.transaction_id,
9284: nvl(s.implement_uom_code,msi.uom_code),
9285: s.sr_instance_id,
9286: g_batch_id
9287: FROM --msc_calendar_dates cal1,
9288: --msc_calendar_dates cal2,
9289: msc_trading_partners mp,
9290: msc_system_items msi,
9291: msc_supplies s,

Line 9288: --msc_calendar_dates cal2,

9284: nvl(s.implement_uom_code,msi.uom_code),
9285: s.sr_instance_id,
9286: g_batch_id
9287: FROM --msc_calendar_dates cal1,
9288: --msc_calendar_dates cal2,
9289: msc_trading_partners mp,
9290: msc_system_items msi,
9291: msc_supplies s,
9292: msc_plan_organizations_v orgs

Line 9396: FROM --msc_calendar_dates cal1,

9392: lv_new_need_by_date,
9393: lv_po_header_id,
9394: lv_po_line_id,
9395: lv_po_number
9396: FROM --msc_calendar_dates cal1,
9397: --msc_calendar_dates cal2,
9398: msc_trading_partners mp,
9399: msc_system_items msi,
9400: msc_supplies s,

Line 9397: --msc_calendar_dates cal2,

9393: lv_po_header_id,
9394: lv_po_line_id,
9395: lv_po_number
9396: FROM --msc_calendar_dates cal1,
9397: --msc_calendar_dates cal2,
9398: msc_trading_partners mp,
9399: msc_system_items msi,
9400: msc_supplies s,
9401: msc_plan_organizations_v orgs