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_AATP_PVT dependencies on MSC_CALENDAR_DATES

Line 524: FROM -- MSC_CALENDAR_DATES C, -- 2859130

520: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)))),
521: -- rajjain end 07/19/2002
522: p_demand_class,
523: p_level_id),0)) SD_QTY --4365873
524: FROM -- MSC_CALENDAR_DATES C, -- 2859130
525: MSC_DEMANDS D
526: WHERE D.PLAN_ID = p_plan_id
527: AND D.SR_INSTANCE_ID = p_instance_id
528: AND D.INVENTORY_ITEM_ID = p_item_id

Line 617: FROM -- MSC_CALENDAR_DATES C, -- 2859130

613: -- c.next_date -- 2859130
614: trunc(nvl(s.firm_date, s.new_schedule_date))),*/
615: NULL, 1,
616: 0)) SD_QTY
617: FROM -- MSC_CALENDAR_DATES C, -- 2859130
618: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
619: WHERE S.PLAN_ID = p_plan_id
620: AND S.SR_INSTANCE_ID = p_instance_id
621: AND S.INVENTORY_ITEM_ID = p_item_id

Line 895: FROM MSC_CALENDAR_DATES C,

891: c.calendar_date,p_level_id, NULL)))),
892: -- rajjain end 07/19/2002
893: p_demand_class,
894: p_level_id),0)) SD_QTY --4365873
895: FROM MSC_CALENDAR_DATES C,
896: MSC_DEMANDS D
897: WHERE D.PLAN_ID = p_plan_id
898: AND D.SR_INSTANCE_ID = p_instance_id
899: AND D.INVENTORY_ITEM_ID = p_item_id

Line 996: FROM MSC_CALENDAR_DATES C,

992: S.CUSTOMER_ID,
993: S.SHIP_TO_SITE_ID,
994: S.SR_INSTANCE_ID,
995: S.ORGANIZATION_ID
996: FROM MSC_CALENDAR_DATES C,
997: MSC_SUPPLIES S
998: WHERE S.PLAN_ID = p_plan_id
999: AND S.SR_INSTANCE_ID = p_instance_id
1000: AND S.INVENTORY_ITEM_ID = p_item_id

Line 1489: FROM -- MSC_CALENDAR_DATES C,

1485: p_demand_class,
1486: trunc(nvl(s.firm_date, s.new_schedule_date))),*/
1487: NULL, 1,
1488: 0)) SD_QTY
1489: FROM -- MSC_CALENDAR_DATES C,
1490: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
1491: WHERE S.PLAN_ID = p_plan_id
1492: AND S.SR_INSTANCE_ID = p_instance_id
1493: AND S.INVENTORY_ITEM_ID = p_item_id

Line 1775: FROM MSC_CALENDAR_DATES C,

1771: c.calendar_date,p_level_id, NULL)))),
1772: -- rajjain end 07/19/2002
1773: p_demand_class,
1774: p_level_id),0)) SD_QTY --4365873
1775: FROM MSC_CALENDAR_DATES C,
1776: MSC_DEMANDS D
1777: WHERE D.PLAN_ID = p_plan_id
1778: AND D.SR_INSTANCE_ID = p_instance_id
1779: AND D.INVENTORY_ITEM_ID = p_item_id

Line 1875: FROM MSC_CALENDAR_DATES C,

1871: S.CUSTOMER_ID,
1872: S.SHIP_TO_SITE_ID,
1873: S.SR_INSTANCE_ID,
1874: S.ORGANIZATION_ID
1875: FROM MSC_CALENDAR_DATES C,
1876: MSC_SUPPLIES S
1877: WHERE S.PLAN_ID = p_plan_id
1878: AND S.SR_INSTANCE_ID = p_instance_id
1879: AND S.INVENTORY_ITEM_ID = p_item_id

Line 2362: FROM -- MSC_CALENDAR_DATES C, --2859130

2358: MTP.PARTNER_NAME, --bug3263368
2359: D.DEMAND_CLASS, --bug3263368
2360: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2361: D.REQUEST_SHIP_DATE) --bug3263368
2362: FROM -- MSC_CALENDAR_DATES C, --2859130
2363: MSC_DEMANDS D,
2364: MSC_TRADING_PARTNERS MTP,--bug3263368
2365: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2366: WHERE D.PLAN_ID = p_plan_id

Line 2499: FROM -- MSC_CALENDAR_DATES C, -- 2859130

2495: null, --bug3263368 ORIG_CUSTOMER_SITE_NAME
2496: null, --bug3263368 ORIG_CUSTOMER_NAME
2497: null, --bug3263368 ORIG_DEMAND_CLASS
2498: null --bug3263368 ORIG_REQUEST_DATE
2499: FROM -- MSC_CALENDAR_DATES C, -- 2859130
2500: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
2501: WHERE S.PLAN_ID = p_plan_id
2502: AND S.SR_INSTANCE_ID = p_instance_id
2503: AND S.INVENTORY_ITEM_ID = p_item_id

Line 2875: FROM MSC_CALENDAR_DATES C,

2871: D.DEMAND_CLASS, --bug3263368
2872: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2873: D.REQUEST_SHIP_DATE) --bug3263368
2874:
2875: FROM MSC_CALENDAR_DATES C,
2876: MSC_DEMANDS D,
2877: MSC_TRADING_PARTNERS MTP,--bug3263368
2878: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2879:

Line 3029: FROM MSC_CALENDAR_DATES C,

3025: S.SHIP_TO_SITE_ID,
3026: S.ORGANIZATION_ID,
3027: C.CALENDAR_DATE
3028:
3029: FROM MSC_CALENDAR_DATES C,
3030: MSC_SUPPLIES S
3031: WHERE S.PLAN_ID = p_plan_id
3032: AND S.SR_INSTANCE_ID = p_instance_id
3033: AND S.INVENTORY_ITEM_ID = p_item_id

Line 5988: -- 2859130 MSC_CALENDAR_DATES C,

5984: /*New*/
5985: FROM MSC_DEPARTMENT_RESOURCES DR,
5986: MSC_SUPPLIES S,
5987: MSC_RESOURCE_REQUIREMENTS REQ,
5988: -- 2859130 MSC_CALENDAR_DATES C,
5989: MSC_SYSTEM_ITEMS I,
5990: MSC_UOM_CONVERSIONS MUC
5991: WHERE DR.PLAN_ID = p_plan_id
5992: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 6161: MSC_CALENDAR_DATES C,

6157: /*New*/
6158: FROM MSC_DEPARTMENT_RESOURCES DR,
6159: MSC_SUPPLIES S,
6160: MSC_RESOURCE_REQUIREMENTS REQ,
6161: MSC_CALENDAR_DATES C,
6162: MSC_SYSTEM_ITEMS I,
6163: MSC_UOM_CONVERSIONS MUC
6164: WHERE DR.PLAN_ID = p_plan_id
6165: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 6383: -- 2859130 MSC_CALENDAR_DATES C

6379: FROM MSC_DEPARTMENT_RESOURCES DR,
6380: MSC_SUPPLIES S,
6381: MSC_SYSTEM_ITEMS I, -- CTO ODR
6382: MSC_RESOURCE_REQUIREMENTS REQ
6383: -- 2859130 MSC_CALENDAR_DATES C
6384: WHERE DR.PLAN_ID = p_plan_id
6385: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6386: AND DR.RESOURCE_ID = p_resource_id
6387: AND DR.SR_INSTANCE_ID = p_instance_id

Line 6547: MSC_CALENDAR_DATES C

6543: FROM MSC_DEPARTMENT_RESOURCES DR,
6544: MSC_SUPPLIES S,
6545: MSC_SYSTEM_ITEMS I, -- CTO ODR
6546: MSC_RESOURCE_REQUIREMENTS REQ,
6547: MSC_CALENDAR_DATES C
6548: WHERE DR.PLAN_ID = p_plan_id
6549: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6550: AND DR.RESOURCE_ID = p_resource_id
6551: AND DR.SR_INSTANCE_ID = p_instance_id

Line 6861: -- 2859130 MSC_CALENDAR_DATES C,

6857: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
6858: FROM MSC_DEPARTMENT_RESOURCES DR,
6859: MSC_SUPPLIES S,
6860: MSC_RESOURCE_REQUIREMENTS REQ,
6861: -- 2859130 MSC_CALENDAR_DATES C,
6862: MSC_SYSTEM_ITEMS I,
6863: MSC_UOM_CONVERSIONS MUC
6864: WHERE DR.PLAN_ID = p_plan_id
6865: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 7152: MSC_CALENDAR_DATES C,

7148: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
7149: FROM MSC_DEPARTMENT_RESOURCES DR,
7150: MSC_SUPPLIES S,
7151: MSC_RESOURCE_REQUIREMENTS REQ,
7152: MSC_CALENDAR_DATES C,
7153: MSC_SYSTEM_ITEMS I,
7154: MSC_UOM_CONVERSIONS MUC
7155: WHERE DR.PLAN_ID = p_plan_id
7156: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 7489: -- 2859130 MSC_CALENDAR_DATES C

7485: FROM MSC_DEPARTMENT_RESOURCES DR,
7486: MSC_SUPPLIES S,
7487: MSC_SYSTEM_ITEMS I, -- CTO ODR
7488: MSC_RESOURCE_REQUIREMENTS REQ
7489: -- 2859130 MSC_CALENDAR_DATES C
7490: WHERE DR.PLAN_ID = p_plan_id
7491: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7492: AND DR.RESOURCE_ID = p_resource_id
7493: AND DR.SR_INSTANCE_ID = p_instance_id

Line 7768: MSC_CALENDAR_DATES C

7764: FROM MSC_DEPARTMENT_RESOURCES DR,
7765: MSC_SUPPLIES S,
7766: MSC_SYSTEM_ITEMS I, -- CTO ODR
7767: MSC_RESOURCE_REQUIREMENTS REQ,
7768: MSC_CALENDAR_DATES C
7769: WHERE DR.PLAN_ID = p_plan_id
7770: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7771: AND DR.RESOURCE_ID = p_resource_id
7772: AND DR.SR_INSTANCE_ID = p_instance_id

Line 8750: -- 2. Removed join with msc_calendar_dates

8746: -- are the changes:
8747: -- 1. We use new_dock_date or new_ship_date depending on whether supplier capacity is dock capacity or
8748: -- ship capacity.
8749: -- Earlier we used to look at new_schedule_date and offset post_processing_lead_time.
8750: -- 2. Removed join with msc_calendar_dates
8751: --=======================================================================================================
8752: -- get the daily net availability for DCi
8753: IF (NVL(p_sup_atp_info_rec.insert_flag, 0) = 0 OR l_demand_class <> p_sup_atp_info_rec.demand_class) THEN
8754: IF l_check_cap_model_flag = 1 THEN

Line 8786: FROM msc_calendar_dates c,

8782: s.inventory_item_id,
8783: s.sr_instance_id,
8784: S.ORGANIZATION_ID,
8785: S.capacity
8786: FROM msc_calendar_dates c,
8787: msc_supplier_capacities s
8788: --WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
8789: WHERE s.inventory_item_id = l_inv_item_id
8790: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id

Line 8946: FROM msc_calendar_dates c,

8942: s.inventory_item_id,
8943: s.sr_instance_id,
8944: S.ORGANIZATION_ID,
8945: S.capacity
8946: FROM msc_calendar_dates c,
8947: msc_supplier_capacities s
8948: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
8949: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
8950: AND s.plan_id = p_sup_atp_info_rec.plan_id

Line 9186: FROM msc_calendar_dates c,

9182: s.sr_instance_id,
9183: s.organization_id,
9184: c.seq_num
9185:
9186: FROM msc_calendar_dates c,
9187: msc_supplier_capacities s
9188: --WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9189: WHERE s.inventory_item_id = l_inv_item_id
9190: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id

Line 9470: FROM msc_calendar_dates c,

9466: s.inventory_item_id,
9467: s.sr_instance_id,
9468: s.organization_id,
9469: c.seq_num
9470: FROM msc_calendar_dates c,
9471: msc_supplier_capacities s
9472: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9473: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
9474: AND s.plan_id = p_sup_atp_info_rec.plan_id