APPS.MSC_REL_PLAN_PUB dependencies on MSC_CALENDAR_DATES

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 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