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 587: FROM -- MSC_CALENDAR_DATES C, -- 2859130

583: ))),
584: -- rajjain end 07/19/2002
585: p_demand_class,
586: p_level_id),0)) SD_QTY --4365873
587: FROM -- MSC_CALENDAR_DATES C, -- 2859130
588: MSC_DEMANDS D
589: WHERE D.PLAN_ID = p_plan_id
590: AND D.SR_INSTANCE_ID = p_instance_id
591: AND D.INVENTORY_ITEM_ID = p_item_id

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

676: -- c.next_date -- 2859130
677: trunc(nvl(s.firm_date, s.new_schedule_date))),*/
678: NULL, 1,
679: 0)) SD_QTY
680: FROM -- MSC_CALENDAR_DATES C, -- 2859130
681: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
682: WHERE S.PLAN_ID = p_plan_id
683: AND S.SR_INSTANCE_ID = p_instance_id
684: AND S.INVENTORY_ITEM_ID = p_item_id

Line 984: FROM MSC_CALENDAR_DATES C,

980: )),
981: -- rajjain end 07/19/2002
982: p_demand_class,
983: p_level_id),0)) SD_QTY --4365873
984: FROM MSC_CALENDAR_DATES C,
985: MSC_DEMANDS D
986: WHERE D.PLAN_ID = p_plan_id
987: AND D.SR_INSTANCE_ID = p_instance_id
988: AND D.INVENTORY_ITEM_ID = p_item_id

Line 1085: FROM MSC_CALENDAR_DATES C,

1081: S.CUSTOMER_ID,
1082: S.SHIP_TO_SITE_ID,
1083: S.SR_INSTANCE_ID,
1084: S.ORGANIZATION_ID
1085: FROM MSC_CALENDAR_DATES C,
1086: MSC_SUPPLIES S
1087: WHERE S.PLAN_ID = p_plan_id
1088: AND S.SR_INSTANCE_ID = p_instance_id
1089: AND S.INVENTORY_ITEM_ID = p_item_id

Line 1620: FROM -- MSC_CALENDAR_DATES C,

1616: p_demand_class,
1617: trunc(nvl(s.firm_date, s.new_schedule_date))),*/
1618: NULL, 1,
1619: 0)) SD_QTY
1620: FROM -- MSC_CALENDAR_DATES C,
1621: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
1622: WHERE S.PLAN_ID = p_plan_id
1623: AND S.SR_INSTANCE_ID = p_instance_id
1624: AND S.INVENTORY_ITEM_ID = p_item_id

Line 1931: FROM MSC_CALENDAR_DATES C,

1927: )),
1928: -- rajjain end 07/19/2002
1929: p_demand_class,
1930: p_level_id),0)) SD_QTY --4365873
1931: FROM MSC_CALENDAR_DATES C,
1932: MSC_DEMANDS D
1933: WHERE D.PLAN_ID = p_plan_id
1934: AND D.SR_INSTANCE_ID = p_instance_id
1935: AND D.INVENTORY_ITEM_ID = p_item_id

Line 2031: FROM MSC_CALENDAR_DATES C,

2027: S.CUSTOMER_ID,
2028: S.SHIP_TO_SITE_ID,
2029: S.SR_INSTANCE_ID,
2030: S.ORGANIZATION_ID
2031: FROM MSC_CALENDAR_DATES C,
2032: MSC_SUPPLIES S
2033: WHERE S.PLAN_ID = p_plan_id
2034: AND S.SR_INSTANCE_ID = p_instance_id
2035: AND S.INVENTORY_ITEM_ID = p_item_id

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

2556: MTP.PARTNER_NAME, --bug3263368
2557: D.DEMAND_CLASS, --bug3263368
2558: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2559: D.REQUEST_SHIP_DATE) --bug3263368
2560: FROM -- MSC_CALENDAR_DATES C, --2859130
2561: MSC_DEMANDS D,
2562: MSC_TRADING_PARTNERS MTP,--bug3263368
2563: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2564: WHERE D.PLAN_ID = p_plan_id

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

2693: null, --bug3263368 ORIG_CUSTOMER_SITE_NAME
2694: null, --bug3263368 ORIG_CUSTOMER_NAME
2695: null, --bug3263368 ORIG_DEMAND_CLASS
2696: null --bug3263368 ORIG_REQUEST_DATE
2697: FROM -- MSC_CALENDAR_DATES C, -- 2859130
2698: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
2699: WHERE S.PLAN_ID = p_plan_id
2700: AND S.SR_INSTANCE_ID = p_instance_id
2701: AND S.INVENTORY_ITEM_ID = p_item_id

Line 3099: FROM MSC_CALENDAR_DATES C,

3095: D.DEMAND_CLASS, --bug3263368
3096: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
3097: D.REQUEST_SHIP_DATE) --bug3263368
3098:
3099: FROM MSC_CALENDAR_DATES C,
3100: MSC_DEMANDS D,
3101: MSC_TRADING_PARTNERS MTP,--bug3263368
3102: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
3103:

Line 3253: FROM MSC_CALENDAR_DATES C,

3249: S.SHIP_TO_SITE_ID,
3250: S.ORGANIZATION_ID,
3251: C.CALENDAR_DATE
3252:
3253: FROM MSC_CALENDAR_DATES C,
3254: MSC_SUPPLIES S
3255: WHERE S.PLAN_ID = p_plan_id
3256: AND S.SR_INSTANCE_ID = p_instance_id
3257: AND S.INVENTORY_ITEM_ID = p_item_id

Line 6218: -- 2859130 MSC_CALENDAR_DATES C,

6214: /*New*/
6215: FROM MSC_DEPARTMENT_RESOURCES DR,
6216: MSC_SUPPLIES S,
6217: MSC_RESOURCE_REQUIREMENTS REQ,
6218: -- 2859130 MSC_CALENDAR_DATES C,
6219: MSC_SYSTEM_ITEMS I,
6220: MSC_UOM_CONVERSIONS MUC
6221: WHERE DR.PLAN_ID = p_plan_id
6222: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 6391: MSC_CALENDAR_DATES C,

6387: /*New*/
6388: FROM MSC_DEPARTMENT_RESOURCES DR,
6389: MSC_SUPPLIES S,
6390: MSC_RESOURCE_REQUIREMENTS REQ,
6391: MSC_CALENDAR_DATES C,
6392: MSC_SYSTEM_ITEMS I,
6393: MSC_UOM_CONVERSIONS MUC
6394: WHERE DR.PLAN_ID = p_plan_id
6395: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 6613: -- 2859130 MSC_CALENDAR_DATES C

6609: FROM MSC_DEPARTMENT_RESOURCES DR,
6610: MSC_SUPPLIES S,
6611: MSC_SYSTEM_ITEMS I, -- CTO ODR
6612: MSC_RESOURCE_REQUIREMENTS REQ
6613: -- 2859130 MSC_CALENDAR_DATES C
6614: WHERE DR.PLAN_ID = p_plan_id
6615: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6616: AND DR.RESOURCE_ID = p_resource_id
6617: AND DR.SR_INSTANCE_ID = p_instance_id

Line 6777: MSC_CALENDAR_DATES C

6773: FROM MSC_DEPARTMENT_RESOURCES DR,
6774: MSC_SUPPLIES S,
6775: MSC_SYSTEM_ITEMS I, -- CTO ODR
6776: MSC_RESOURCE_REQUIREMENTS REQ,
6777: MSC_CALENDAR_DATES C
6778: WHERE DR.PLAN_ID = p_plan_id
6779: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6780: AND DR.RESOURCE_ID = p_resource_id
6781: AND DR.SR_INSTANCE_ID = p_instance_id

Line 7091: -- 2859130 MSC_CALENDAR_DATES C,

7087: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
7088: FROM MSC_DEPARTMENT_RESOURCES DR,
7089: MSC_SUPPLIES S,
7090: MSC_RESOURCE_REQUIREMENTS REQ,
7091: -- 2859130 MSC_CALENDAR_DATES C,
7092: MSC_SYSTEM_ITEMS I,
7093: MSC_UOM_CONVERSIONS MUC
7094: WHERE DR.PLAN_ID = p_plan_id
7095: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 7382: MSC_CALENDAR_DATES C,

7378: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
7379: FROM MSC_DEPARTMENT_RESOURCES DR,
7380: MSC_SUPPLIES S,
7381: MSC_RESOURCE_REQUIREMENTS REQ,
7382: MSC_CALENDAR_DATES C,
7383: MSC_SYSTEM_ITEMS I,
7384: MSC_UOM_CONVERSIONS MUC
7385: WHERE DR.PLAN_ID = p_plan_id
7386: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id

Line 7719: -- 2859130 MSC_CALENDAR_DATES C

7715: FROM MSC_DEPARTMENT_RESOURCES DR,
7716: MSC_SUPPLIES S,
7717: MSC_SYSTEM_ITEMS I, -- CTO ODR
7718: MSC_RESOURCE_REQUIREMENTS REQ
7719: -- 2859130 MSC_CALENDAR_DATES C
7720: WHERE DR.PLAN_ID = p_plan_id
7721: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7722: AND DR.RESOURCE_ID = p_resource_id
7723: AND DR.SR_INSTANCE_ID = p_instance_id

Line 7998: MSC_CALENDAR_DATES C

7994: FROM MSC_DEPARTMENT_RESOURCES DR,
7995: MSC_SUPPLIES S,
7996: MSC_SYSTEM_ITEMS I, -- CTO ODR
7997: MSC_RESOURCE_REQUIREMENTS REQ,
7998: MSC_CALENDAR_DATES C
7999: WHERE DR.PLAN_ID = p_plan_id
8000: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
8001: AND DR.RESOURCE_ID = p_resource_id
8002: AND DR.SR_INSTANCE_ID = p_instance_id

Line 8981: -- 2. Removed join with msc_calendar_dates

8977: -- are the changes:
8978: -- 1. We use new_dock_date or new_ship_date depending on whether supplier capacity is dock capacity or
8979: -- ship capacity.
8980: -- Earlier we used to look at new_schedule_date and offset post_processing_lead_time.
8981: -- 2. Removed join with msc_calendar_dates
8982: --=======================================================================================================
8983: -- get the daily net availability for DCi
8984: IF (NVL(p_sup_atp_info_rec.insert_flag, 0) = 0 OR l_demand_class <> p_sup_atp_info_rec.demand_class) THEN
8985: IF l_check_cap_model_flag = 1 THEN

Line 9017: FROM msc_calendar_dates c,

9013: s.inventory_item_id,
9014: s.sr_instance_id,
9015: S.ORGANIZATION_ID,
9016: S.capacity
9017: FROM msc_calendar_dates c,
9018: msc_supplier_capacities s
9019: --WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9020: WHERE s.inventory_item_id = l_inv_item_id
9021: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id

Line 9177: FROM msc_calendar_dates c,

9173: s.inventory_item_id,
9174: s.sr_instance_id,
9175: S.ORGANIZATION_ID,
9176: S.capacity
9177: FROM msc_calendar_dates c,
9178: msc_supplier_capacities s
9179: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9180: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
9181: AND s.plan_id = p_sup_atp_info_rec.plan_id

Line 9417: FROM msc_calendar_dates c,

9413: s.sr_instance_id,
9414: s.organization_id,
9415: c.seq_num
9416:
9417: FROM msc_calendar_dates c,
9418: msc_supplier_capacities s
9419: --WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9420: WHERE s.inventory_item_id = l_inv_item_id
9421: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id

Line 9701: FROM msc_calendar_dates c,

9697: s.inventory_item_id,
9698: s.sr_instance_id,
9699: s.organization_id,
9700: c.seq_num
9701: FROM msc_calendar_dates c,
9702: msc_supplier_capacities s
9703: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
9704: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
9705: AND s.plan_id = p_sup_atp_info_rec.plan_id