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

Line 166: -- MSC_CALENDAR_DATES C

162: -- Option Dependent Resources Capacity Check
163: -- Add Link to Items
164: MSC_SYSTEM_ITEMS I
165: -- 2859130
166: -- MSC_CALENDAR_DATES C
167: -- Bug 2675504, 2665805,
168: --bug3394866
169: WHERE DR.PLAN_ID = p_plan_id
170: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_dept_id

Line 271: MSC_CALENDAR_DATES C

267: -- CTO Option Dependent Resources ODR
268: -- Option Dependent Resources Capacity Check
269: -- Add Link to Items
270: MSC_SYSTEM_ITEMS I,
271: MSC_CALENDAR_DATES C
272: -- Bug 2675504, 2665805,
273: --bug3394866
274: WHERE DR.PLAN_ID = p_plan_id
275: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_dept_id

Line 384: -- 2859130 MSC_CALENDAR_DATES C,

380: NVL(MUC.CONVERSION_RATE,1) * NVL(S.NEW_ORDER_QUANTITY, S.FIRM_QUANTITY) SD_QTY
381:
382: FROM MSC_DEPARTMENT_RESOURCES DR,
383: MSC_RESOURCE_REQUIREMENTS REQ,
384: -- 2859130 MSC_CALENDAR_DATES C,
385: --- add table for resource batching
386: --- these tables are added to determine how much apacity has already been consumed by the
387: --- existing supplies
388: MSC_SYSTEM_ITEMS I,

Line 510: MSC_CALENDAR_DATES C,

506: NVL(MUC.CONVERSION_RATE,1) * NVL(S.NEW_ORDER_QUANTITY, S.FIRM_QUANTITY) SD_QTY
507:
508: FROM MSC_DEPARTMENT_RESOURCES DR,
509: MSC_RESOURCE_REQUIREMENTS REQ,
510: MSC_CALENDAR_DATES C,
511: --- add table for resource batching
512: --- these tables are added to determine how much apacity has already been consumed by the
513: --- existing supplies
514: MSC_SYSTEM_ITEMS I,

Line 704: -- 2859130 MSC_CALENDAR_DATES C

700: -- CTO Option Dependent Resources
701: -- Option Dependent Resources Capacity Check
702: -- Add Link to Items
703: MSC_SYSTEM_ITEMS I
704: -- 2859130 MSC_CALENDAR_DATES C
705: -- Bug 2675504, 2665805,
706: --bug3394866
707: WHERE DR.PLAN_ID = p_plan_id
708: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_dept_id

Line 909: MSC_CALENDAR_DATES C

905: -- CTO Option Dependent Resources
906: -- Option Dependent Resources Capacity Check
907: -- Add Link to Items
908: MSC_SYSTEM_ITEMS I,
909: MSC_CALENDAR_DATES C
910: -- Bug 2675504, 2665805,
911: --bug3394866
912: WHERE DR.PLAN_ID = p_plan_id
913: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_dept_id

Line 1117: -- 2859130 MSC_CALENDAR_DATES C,

1113: FND_GLOBAL.User_ID,
1114: FND_GLOBAL.User_ID
1115: FROM MSC_DEPARTMENT_RESOURCES DR,
1116: MSC_RESOURCE_REQUIREMENTS REQ,
1117: -- 2859130 MSC_CALENDAR_DATES C,
1118: ---tables added for resource batching
1119: MSC_SYSTEM_ITEMS I,
1120: MSC_SUPPLIES S,
1121: MSC_UOM_CONVERSIONS MUC

Line 1340: MSC_CALENDAR_DATES C,

1336: FND_GLOBAL.User_ID,
1337: FND_GLOBAL.User_ID
1338: FROM MSC_DEPARTMENT_RESOURCES DR,
1339: MSC_RESOURCE_REQUIREMENTS REQ,
1340: MSC_CALENDAR_DATES C,
1341: ---tables added for resource batching
1342: MSC_SYSTEM_ITEMS I,
1343: MSC_SUPPLIES S,
1344: MSC_UOM_CONVERSIONS MUC

Line 2045: FROM MSC_CALENDAR_DATES C,

2041: BULK COLLECT INTO x_atp_dates, x_atp_qtys
2042: FROM (
2043: SELECT C.PRIOR_DATE SD_DATE,
2044: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
2045: FROM MSC_CALENDAR_DATES C,
2046: MSC_DEMANDS D,
2047: MSC_ATP_RULES R,
2048: MSC_SYSTEM_ITEMS I
2049: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id

Line 2102: --MSC_CALENDAR_DATES C,

2098: -1*(D.PRIMARY_UOM_QUANTITY-GREATEST(NVL(D.RESERVATION_QUANTITY,0),
2099: D.COMPLETED_QUANTITY)) SD_QTY
2100: FROM
2101: -- Bug 1756263, performance fix, use EXISTS subquery instead.
2102: --MSC_CALENDAR_DATES C,
2103: MSC_SALES_ORDERS D,
2104: MSC_ATP_RULES R,
2105: MSC_SYSTEM_ITEMS I,
2106: MSC_CALENDAR_DATES C

Line 2106: MSC_CALENDAR_DATES C

2102: --MSC_CALENDAR_DATES C,
2103: MSC_SALES_ORDERS D,
2104: MSC_ATP_RULES R,
2105: MSC_SYSTEM_ITEMS I,
2106: MSC_CALENDAR_DATES C
2107: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2108: AND I.ORGANIZATION_ID = p_org_id
2109: AND I.SR_INSTANCE_ID = p_instance_id
2110: AND I.PLAN_ID = p_plan_id

Line 2156: FROM MSC_CALENDAR_DATES C,

2152: -1,S.Daily_rate* (TRUNC(C.Calendar_date) - TRUNC(S.First_Unit_Start_date) +1)- S.qty_completed,
2153: S.Daily_rate),
2154: 5, NVL(S.DAILY_RATE, NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY)),
2155: (NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) - NVL(S.NON_NETTABLE_QTY, 0)) )SD_QTY
2156: FROM MSC_CALENDAR_DATES C,
2157: MSC_SUPPLIES S,
2158: MSC_ATP_RULES R,
2159: MSC_SYSTEM_ITEMS I,
2160: MSC_SUB_INVENTORIES MSI

Line 2271: -- remove join to msc_calendar_dates

2267: msc_sch_wb.atp_debug('Begin get_mat_avail_opt');
2268: END IF;
2269:
2270: -- 2859130 repetitive schedule demands (4) not supported
2271: -- remove join to msc_calendar_dates
2272: SELECT SD_DATE, SUM(SD_QTY)
2273: BULK COLLECT INTO x_atp_dates, x_atp_qtys
2274: FROM (
2275: SELECT -- C.PRIOR_DATE SD_DATE, -- 2859130

Line 2371: FROM MSC_CALENDAR_DATES C,

2367: -1* DECODE(D.ORIGINATION_TYPE,
2368: 4, D.DAILY_DEMAND_RATE,
2369: --D.USING_REQUIREMENT_QUANTITY) SD_QTY
2370: (D.USING_REQUIREMENT_QUANTITY - NVL(d.reserved_quantity, 0))) SD_QTY --5027568
2371: FROM MSC_CALENDAR_DATES C,
2372: MSC_DEMANDS D,
2373: MSC_SYSTEM_ITEMS I
2374: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2375: AND I.ORGANIZATION_ID = p_org_id

Line 2421: FROM MSC_CALENDAR_DATES C,

2417: UNION ALL
2418: SELECT -- C.NEXT_DATE SD_DATE, -- 2859130
2419: C.CALENDAR_DATE SD_DATE,
2420: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
2421: FROM MSC_CALENDAR_DATES C,
2422: MSC_SUPPLIES S,
2423: MSC_SYSTEM_ITEMS I
2424: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2425: AND I.ORGANIZATION_ID = p_org_id

Line 2563: FROM MSC_CALENDAR_DATES C,

2559: MTP.PARTNER_NAME, --bug3263368
2560: D.DEMAND_CLASS, --bug3263368
2561: trunc(DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE, --4135752
2562: D.REQUEST_SHIP_DATE)) --bug3263368
2563: FROM MSC_CALENDAR_DATES C,
2564: MSC_DEMANDS D,
2565: MSC_ATP_RULES R,
2566: MSC_SYSTEM_ITEMS I,
2567: MSC_TRADING_PARTNERS MTP,--bug3263368

Line 2650: MSC_CALENDAR_DATES C,

2646: FROM
2647: MSC_SALES_ORDERS D,
2648: MSC_ATP_RULES R,
2649: MSC_SYSTEM_ITEMS I,
2650: MSC_CALENDAR_DATES C,
2651: MSC_TRADING_PARTNERS MTP,--bug3263368
2652: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2653: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2654: AND I.ORGANIZATION_ID = p_org_id

Line 2760: FROM MSC_CALENDAR_DATES C,

2756: l_null_char, --bug3814584
2757: l_null_char, --bug3814584
2758: l_null_char, --bug3814584
2759: l_null_date --bug3814584
2760: FROM MSC_CALENDAR_DATES C,
2761: MSC_SUPPLIES S,
2762: MSC_ATP_RULES R,
2763: MSC_SYSTEM_ITEMS I,
2764: MSC_SUB_INVENTORIES MSI

Line 3172: MSC_CALENDAR_DATES C,

3168: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
3169: D.REQUEST_SHIP_DATE) --bug3263368
3170: FROM MSC_SYSTEM_ITEMS I,
3171: MSC_DEMANDS D,
3172: MSC_CALENDAR_DATES C,
3173: MSC_TRADING_PARTNERS MTP,--bug3263368
3174: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
3175: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
3176: AND I.ORGANIZATION_ID = p_org_id

Line 3267: MSC_CALENDAR_DATES C

3263: l_null_char, --bug3814584
3264: l_null_date --bug3814584
3265: FROM MSC_SYSTEM_ITEMS I,
3266: MSC_SUPPLIES S,
3267: MSC_CALENDAR_DATES C
3268: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
3269: AND I.ORGANIZATION_ID = p_org_id
3270: AND I.SR_INSTANCE_ID = p_instance_id
3271: AND I.PLAN_ID = p_plan_id

Line 4843: -- msc_calendar.select_calendar_defaults(p_mat_atp_info_rec.organization_id,p_mat_atp_info_rec.instance_id,

4839: END IF;
4840:
4841: --- bug 1819638: get next working day.
4842:
4843: -- msc_calendar.select_calendar_defaults(p_mat_atp_info_rec.organization_id,p_mat_atp_info_rec.instance_id,
4844: -- l_calendar_code, l_exception_set_id);
4845: /* Modularize Item and Org Info */
4846: -- changed call, re-use info already obtained.
4847: MSC_ATP_PROC.get_global_org_info(p_mat_atp_info_rec.instance_id, p_mat_atp_info_rec.organization_id);

Line 4879: FROM msc_calendar_dates cal

4875:
4876: BEGIN
4877: SELECT cal.next_seq_num, cal.next_date
4878: INTO l_sysdate_seq_num, l_sys_next_date
4879: FROM msc_calendar_dates cal
4880: WHERE cal.exception_set_id = l_calendar_exception_set_id
4881: AND cal.calendar_code = l_calendar_code
4882: AND cal.calendar_date = TRUNC(sysdate)
4883: AND cal.sr_instance_id = p_mat_atp_info_rec.instance_id ;

Line 4890: l_sys_next_osc_date := MSC_CALENDAR.NEXT_WORK_DAY(

4886: IF p_mat_atp_info_rec.shipping_cal_code = l_calendar_code THEN
4887: -- OMC and OSC are same or looking at components for make case
4888: l_sys_next_osc_date := l_sys_next_date;
4889: ELSE
4890: l_sys_next_osc_date := MSC_CALENDAR.NEXT_WORK_DAY(
4891: p_mat_atp_info_rec.shipping_cal_code,
4892: p_mat_atp_info_rec.instance_id,
4893: TRUNC(sysdate));
4894: END IF;

Line 5235: l_subst_limit_date := MSC_CALENDAR.DATE_OFFSET(

5231: ELSE
5232: IF PG_DEBUG in ('Y', 'C') THEN
5233: msc_sch_wb.atp_debug('Get_Material_Atp_Info: ' || 'Do substitution check');
5234: END IF;
5235: l_subst_limit_date := MSC_CALENDAR.DATE_OFFSET(
5236: p_mat_atp_info_rec.organization_id,
5237: p_mat_atp_info_rec.instance_id,
5238: 1,
5239: p_mat_atp_info_rec.requested_date,

Line 5430: FROM msc_calendar_dates cal

5426: --Bug 2287148
5427: BEGIN
5428: SELECT cal.next_seq_num,cal.next_date
5429: INTO l_sysdate_seq_num,l_sys_next_date
5430: FROM msc_calendar_dates cal
5431: WHERE cal.exception_set_id = l_calendar_exception_set_id
5432: AND cal.calendar_code = l_calendar_code
5433: AND cal.calendar_date = TRUNC(sysdate)
5434: AND cal.sr_instance_id = p_instance_id ;

Line 6115: MSC_CALENDAR_DATES C1,

6111: MSC_ROUTING_OPERATIONS OP,
6112: MSC_OPERATION_RESOURCE_SEQS SEQ,
6113: MSC_OPERATION_RESOURCES RES,
6114: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6115: MSC_CALENDAR_DATES C1,
6116: MSC_CALENDAR_DATES C2
6117:
6118: WHERE mcbom1.session_id = MSC_ATP_PVT.G_SESSION_ID
6119: AND mcbom1.sr_instance_id = p_instance_id

Line 6116: MSC_CALENDAR_DATES C2

6112: MSC_OPERATION_RESOURCE_SEQS SEQ,
6113: MSC_OPERATION_RESOURCES RES,
6114: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6115: MSC_CALENDAR_DATES C1,
6116: MSC_CALENDAR_DATES C2
6117:
6118: WHERE mcbom1.session_id = MSC_ATP_PVT.G_SESSION_ID
6119: AND mcbom1.sr_instance_id = p_instance_id
6120: -- Bug 3358981 line is a model then include,

Line 6291: MSC_CALENDAR_DATES C1,

6287: MSC_OPERATION_COMPONENTS moc,
6288: MSC_OPERATION_RESOURCE_SEQS SEQ,
6289: MSC_OPERATION_RESOURCES RES,
6290: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6291: MSC_CALENDAR_DATES C1,
6292: MSC_CALENDAR_DATES C2
6293:
6294: WHERE mcbom1.session_id = MSC_ATP_PVT.G_SESSION_ID
6295: AND mcbom1.sr_instance_id = p_instance_id

Line 6292: MSC_CALENDAR_DATES C2

6288: MSC_OPERATION_RESOURCE_SEQS SEQ,
6289: MSC_OPERATION_RESOURCES RES,
6290: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6291: MSC_CALENDAR_DATES C1,
6292: MSC_CALENDAR_DATES C2
6293:
6294: WHERE mcbom1.session_id = MSC_ATP_PVT.G_SESSION_ID
6295: AND mcbom1.sr_instance_id = p_instance_id
6296: -- Bug 3358981 line is a model then include,

Line 6581: MSC_CALENDAR_DATES C1,

6577: MSC_ROUTING_OPERATIONS OP,
6578: MSC_OPERATION_RESOURCE_SEQS SEQ,
6579: MSC_OPERATION_RESOURCES RES,
6580: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6581: MSC_CALENDAR_DATES C1,
6582: MSC_CALENDAR_DATES C2
6583:
6584: WHERE I.PLAN_ID = RTG.PLAN_ID
6585: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID

Line 6582: MSC_CALENDAR_DATES C2

6578: MSC_OPERATION_RESOURCE_SEQS SEQ,
6579: MSC_OPERATION_RESOURCES RES,
6580: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6581: MSC_CALENDAR_DATES C1,
6582: MSC_CALENDAR_DATES C2
6583:
6584: WHERE I.PLAN_ID = RTG.PLAN_ID
6585: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID
6586: AND I.INVENTORY_ITEM_ID = RTG.ASSEMBLY_ITEM_ID

Line 6782: MSC_CALENDAR_DATES C1,

6778: MSC_ROUTING_OPERATIONS OP,
6779: MSC_OPERATION_RESOURCE_SEQS SEQ,
6780: MSC_OPERATION_RESOURCES RES,
6781: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6782: MSC_CALENDAR_DATES C1,
6783: MSC_CALENDAR_DATES C2
6784:
6785: WHERE mcbom1.session_id = MSC_ATP_PVT.G_SESSION_ID
6786: AND mcbom1.sr_instance_id = p_instance_id

Line 6783: MSC_CALENDAR_DATES C2

6779: MSC_OPERATION_RESOURCE_SEQS SEQ,
6780: MSC_OPERATION_RESOURCES RES,
6781: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6782: MSC_CALENDAR_DATES C1,
6783: MSC_CALENDAR_DATES C2
6784:
6785: WHERE mcbom1.session_id = MSC_ATP_PVT.G_SESSION_ID
6786: AND mcbom1.sr_instance_id = p_instance_id
6787: -- Bug 3358981 line is a model then include,

Line 6934: MSC_CALENDAR_DATES C1,

6930: MSC_OPERATION_COMPONENTS moc,
6931: MSC_OPERATION_RESOURCE_SEQS SEQ,
6932: MSC_OPERATION_RESOURCES RES,
6933: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6934: MSC_CALENDAR_DATES C1,
6935: MSC_CALENDAR_DATES C2
6936:
6937: WHERE mcbom1.session_id = MSC_ATP_PVT.G_SESSION_ID
6938: AND mcbom1.sr_instance_id = p_instance_id

Line 6935: MSC_CALENDAR_DATES C2

6931: MSC_OPERATION_RESOURCE_SEQS SEQ,
6932: MSC_OPERATION_RESOURCES RES,
6933: MSC_DEPARTMENT_RESOURCES DR, -- this is the sharing dept
6934: MSC_CALENDAR_DATES C1,
6935: MSC_CALENDAR_DATES C2
6936:
6937: WHERE mcbom1.session_id = MSC_ATP_PVT.G_SESSION_ID
6938: AND mcbom1.sr_instance_id = p_instance_id
6939: -- Bug 3358981 line is a model then include,

Line 7121: FROM MSC_CALENDAR_DATES C2,

7117: 1 actual_resource_usage,
7118: l_null_num reverse_cumulative_yield,
7119: l_null_char department_code,
7120: l_null_char resource_Code
7121: FROM MSC_CALENDAR_DATES C2,
7122: MSC_CALENDAR_DATES C1,
7123: MSC_ROUTINGS RTG,
7124: MSC_SYSTEM_ITEMS I
7125: WHERE I.PLAN_ID = RTG.PLAN_ID

Line 7122: MSC_CALENDAR_DATES C1,

7118: l_null_num reverse_cumulative_yield,
7119: l_null_char department_code,
7120: l_null_char resource_Code
7121: FROM MSC_CALENDAR_DATES C2,
7122: MSC_CALENDAR_DATES C1,
7123: MSC_ROUTINGS RTG,
7124: MSC_SYSTEM_ITEMS I
7125: WHERE I.PLAN_ID = RTG.PLAN_ID
7126: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID

Line 7249: MSC_CALENDAR_DATES C1,

7245: MSC_ROUTING_OPERATIONS OP,
7246: MSC_OPERATION_RESOURCE_SEQS SEQ,
7247: MSC_OPERATION_RESOURCES RES,
7248: MSC_DEPARTMENT_RESOURCES DR,
7249: MSC_CALENDAR_DATES C1,
7250: MSC_CALENDAR_DATES C2
7251:
7252: WHERE I.PLAN_ID = RTG.PLAN_ID
7253: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID

Line 7250: MSC_CALENDAR_DATES C2

7246: MSC_OPERATION_RESOURCE_SEQS SEQ,
7247: MSC_OPERATION_RESOURCES RES,
7248: MSC_DEPARTMENT_RESOURCES DR,
7249: MSC_CALENDAR_DATES C1,
7250: MSC_CALENDAR_DATES C2
7251:
7252: WHERE I.PLAN_ID = RTG.PLAN_ID
7253: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID
7254: AND I.INVENTORY_ITEM_ID = RTG.ASSEMBLY_ITEM_ID

Line 7335: FROM MSC_CALENDAR_DATES C2,

7331: 1 actual_resource_usage,
7332: l_null_num reverse_cumulative_yield,
7333: l_null_char department_code,
7334: l_null_char resource_Code
7335: FROM MSC_CALENDAR_DATES C2,
7336: MSC_CALENDAR_DATES C1,
7337: MSC_ROUTINGS RTG,
7338: MSC_SYSTEM_ITEMS I
7339: WHERE I.PLAN_ID = RTG.PLAN_ID

Line 7336: MSC_CALENDAR_DATES C1,

7332: l_null_num reverse_cumulative_yield,
7333: l_null_char department_code,
7334: l_null_char resource_Code
7335: FROM MSC_CALENDAR_DATES C2,
7336: MSC_CALENDAR_DATES C1,
7337: MSC_ROUTINGS RTG,
7338: MSC_SYSTEM_ITEMS I
7339: WHERE I.PLAN_ID = RTG.PLAN_ID
7340: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID

Line 7438: msc_calendar_dates c1,

7434: l_res_requirements.resource_code
7435:
7436: FROM msc_department_resources dr,
7437: msc_bor_requirements b,
7438: msc_calendar_dates c1,
7439: msc_calendar_dates c2
7440: WHERE B.PLAN_ID = p_plan_id
7441: AND B.SR_INSTANCE_ID = p_instance_id
7442: AND B.ORGANIZATION_ID = p_organization_id

Line 7439: msc_calendar_dates c2

7435:
7436: FROM msc_department_resources dr,
7437: msc_bor_requirements b,
7438: msc_calendar_dates c1,
7439: msc_calendar_dates c2
7440: WHERE B.PLAN_ID = p_plan_id
7441: AND B.SR_INSTANCE_ID = p_instance_id
7442: AND B.ORGANIZATION_ID = p_organization_id
7443: AND B.ASSEMBLY_ITEM_ID = l_inv_item_id

Line 8130: MSC_CALENDAR.DATE_OFFSET

8126: -- Use Org's Manuf. Calendar
8127:
8128: ---2178544
8129: l_requested_date := GREATEST(l_requested_date,
8130: MSC_CALENDAR.DATE_OFFSET
8131: (p_organization_id,
8132: p_instance_id,
8133: 1,
8134: MSC_ATP_PVT.G_PTF_DATE,

Line 8201: l_res_availability_date := MSC_CALENDAR.DATE_OFFSET

8197: END IF;
8198: --4198893,4198445 First calculate individual availability date. This date will be used to calculate
8199: --start date.
8200: IF nvl(l_lead_time, 0) > 0 THEN
8201: l_res_availability_date := MSC_CALENDAR.DATE_OFFSET
8202: (p_organization_id,
8203: p_instance_id,
8204: 1,
8205: l_res_atp_date,

Line 8207: /* x_atp_date := GREATEST(MSC_CALENDAR.DATE_OFFSET

8203: p_instance_id,
8204: 1,
8205: l_res_atp_date,
8206: NVL(l_lead_time, 0));
8207: /* x_atp_date := GREATEST(MSC_CALENDAR.DATE_OFFSET
8208: (p_organization_id,
8209: p_instance_id,
8210: 1,
8211: l_res_atp_date,

Line 8365: l_res_start_date := LEAST(MSC_CALENDAR.DATE_OFFSET

8361:
8362: -- Bug 3348095
8363: -- Calculate the start date given the end date in backward case.
8364: IF (l_res_start_date IS NULL) THEN
8365: l_res_start_date := LEAST(MSC_CALENDAR.DATE_OFFSET
8366: (p_organization_id,
8367: p_instance_id,
8368: 1,
8369: l_requested_date,

Line 8701: l_res_start_date := LEAST(MSC_CALENDAR.DATE_OFFSET

8697: END IF;
8698:
8699: -- Bug 3348095
8700: -- Calculate the start date given the end date in forward case.
8701: l_res_start_date := LEAST(MSC_CALENDAR.DATE_OFFSET
8702: (p_organization_id,
8703: p_instance_id,
8704: 1,
8705: l_res_availability_date,

Line 9371: MSC_CALENDAR_DATES C2,

9367: mbc.rounding_direction rounding_direction,
9368: mbc.component_yield_factor component_yield_factor,
9369: MBC.USAGE_QUANTITY*mbc.component_yield_factor usage_qty --4775920
9370: FROM MSC_SYSTEM_ITEMS I2,
9371: MSC_CALENDAR_DATES C2,
9372: MSC_CALENDAR_DATES C1,
9373: MSC_BOM_COMPONENTS MBC,
9374: MSC_BOMS BOMS,
9375: MSC_SYSTEM_ITEMS I,

Line 9372: MSC_CALENDAR_DATES C1,

9368: mbc.component_yield_factor component_yield_factor,
9369: MBC.USAGE_QUANTITY*mbc.component_yield_factor usage_qty --4775920
9370: FROM MSC_SYSTEM_ITEMS I2,
9371: MSC_CALENDAR_DATES C2,
9372: MSC_CALENDAR_DATES C1,
9373: MSC_BOM_COMPONENTS MBC,
9374: MSC_BOMS BOMS,
9375: MSC_SYSTEM_ITEMS I,
9376: MSC_OPERATION_COMPONENTS OPC,

Line 9518: MSC_CALENDAR_DATES C2,

9514: mbc.rounding_direction,
9515: mbc.component_yield_factor, --4570421
9516: MBC.USAGE_QUANTITY*mbc.component_yield_factor --4775920
9517: FROM MSC_SYSTEM_ITEMS I2,
9518: MSC_CALENDAR_DATES C2,
9519: MSC_CALENDAR_DATES C1,
9520: MSC_BOM_COMPONENTS MBC,
9521: MSC_BOMS BOMS
9522: WHERE BOMS.PLAN_ID = p_plan_id

Line 9519: MSC_CALENDAR_DATES C1,

9515: mbc.component_yield_factor, --4570421
9516: MBC.USAGE_QUANTITY*mbc.component_yield_factor --4775920
9517: FROM MSC_SYSTEM_ITEMS I2,
9518: MSC_CALENDAR_DATES C2,
9519: MSC_CALENDAR_DATES C1,
9520: MSC_BOM_COMPONENTS MBC,
9521: MSC_BOMS BOMS
9522: WHERE BOMS.PLAN_ID = p_plan_id
9523: AND BOMS.SR_INSTANCE_ID = p_instance_id

Line 9571: msc_calendar_dates c2,

9567: mbt.source_organization_id,
9568: -- krajan : 2462661
9569: mbt.atp_flag
9570: FROM msc_bom_temp mbt,
9571: msc_calendar_dates c2,
9572: msc_calendar_dates c1,
9573: msc_trading_partners tp
9574: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID
9575: --AND mbt.assembly_identifier = MSC_ATP_PVT.G_ASSEMBLY_LINE_ID

Line 9572: msc_calendar_dates c1,

9568: -- krajan : 2462661
9569: mbt.atp_flag
9570: FROM msc_bom_temp mbt,
9571: msc_calendar_dates c2,
9572: msc_calendar_dates c1,
9573: msc_trading_partners tp
9574: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID
9575: --AND mbt.assembly_identifier = MSC_ATP_PVT.G_ASSEMBLY_LINE_ID
9576: AND mbt.assembly_identifier = MSC_ATP_PVT.G_COMP_LINE_ID

Line 10014: l_request_date := MSC_CALENDAR.DATE_OFFSET

10010: msc_sch_wb.atp_debug('l_lead_time = ' || l_lead_time);
10011: END IF;
10012:
10013: IF nvl(l_lead_time, 0) > 0 THEN
10014: l_request_date := MSC_CALENDAR.DATE_OFFSET
10015: (p_organization_id,
10016: p_instance_id,
10017: 1,
10018: l_explode_comp.requested_date(i),

Line 11021: x_atp_date := GREATEST(MSC_CALENDAR.DATE_OFFSET

11017: msc_sch_wb.atp_debug('Get_Comp_Requirements: ' || 'p_search = 2');
11018: END IF;
11019:
11020: IF l_atp_rec.ship_date IS NOT NULL THEN
11021: x_atp_date := GREATEST(MSC_CALENDAR.DATE_OFFSET
11022: (p_organization_id,
11023: p_instance_id,
11024: 1,
11025: l_atp_rec.ship_date,

Line 11279: l_sysdate := MSC_CALENDAR.PREV_WORK_DAY(l_calendar_code, p_sup_atp_info_rec.instance_id, sysdate);

11275: l_calendar_code := p_sup_atp_info_rec.manufacturing_cal_code;
11276:
11277: l_calendar_exception_set_id := -1;
11278: -- l_enforce_sup_capacity := NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.enforce_sup_capacity, 2); -- Enforce Pur LT
11279: l_sysdate := MSC_CALENDAR.PREV_WORK_DAY(l_calendar_code, p_sup_atp_info_rec.instance_id, sysdate);
11280: l_requested_date := MSC_CALENDAR.PREV_WORK_DAY(l_calendar_code, p_sup_atp_info_rec.instance_id, p_sup_atp_info_rec.requested_date);
11281:
11282: /* Enforce Pur LT - capacity is always enforced
11283: Removed code to check the plan type. This was earlier required as capacity constraints were earlier enforced

Line 11280: l_requested_date := MSC_CALENDAR.PREV_WORK_DAY(l_calendar_code, p_sup_atp_info_rec.instance_id, p_sup_atp_info_rec.requested_date);

11276:
11277: l_calendar_exception_set_id := -1;
11278: -- l_enforce_sup_capacity := NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.enforce_sup_capacity, 2); -- Enforce Pur LT
11279: l_sysdate := MSC_CALENDAR.PREV_WORK_DAY(l_calendar_code, p_sup_atp_info_rec.instance_id, sysdate);
11280: l_requested_date := MSC_CALENDAR.PREV_WORK_DAY(l_calendar_code, p_sup_atp_info_rec.instance_id, p_sup_atp_info_rec.requested_date);
11281:
11282: /* Enforce Pur LT - capacity is always enforced
11283: Removed code to check the plan type. This was earlier required as capacity constraints were earlier enforced
11284: only for unconstrained plans or if the plan option to enforce capacity was enforced. Now this is not required

Line 11307: l_last_cap_next_date := MSC_CALENDAR.NEXT_WORK_DAY(

11303: Date is passed from there. If the passed date is NULL then it means capacity is not defined.*/
11304: -- IF (p_sup_atp_info_rec.supplier_id = -99) OR (l_plan_type = 1 AND l_enforce_sup_capacity = 2) THEN
11305: IF (p_sup_atp_info_rec.supplier_id = -99) OR p_sup_atp_info_rec.last_cap_date IS NULL THEN
11306: l_capacity_defined := 0;
11307: l_last_cap_next_date := MSC_CALENDAR.NEXT_WORK_DAY(
11308: l_calendar_code,
11309: p_sup_atp_info_rec.instance_id,
11310: GREATEST(l_plan_start_date, MSC_ATP_PVT.G_PTF_DATE, p_sup_atp_info_rec.sup_cap_cum_date));
11311: ELSE

Line 11313: l_last_cap_next_date := MSC_CALENDAR.NEXT_WORK_DAY(

11309: p_sup_atp_info_rec.instance_id,
11310: GREATEST(l_plan_start_date, MSC_ATP_PVT.G_PTF_DATE, p_sup_atp_info_rec.sup_cap_cum_date));
11311: ELSE
11312: l_capacity_defined := 1;
11313: l_last_cap_next_date := MSC_CALENDAR.NEXT_WORK_DAY(
11314: l_calendar_code,
11315: p_sup_atp_info_rec.instance_id,
11316: p_sup_atp_info_rec.last_cap_date + 1);
11317: END IF;

Line 11452: -- 2. Removed join with msc_calendar_dates

11448: -- are the changes:
11449: -- 1. We use new_dock_date or new_ship_date depending on whether supplier capacity is dock capacity or
11450: -- ship capacity.
11451: -- Earlier we used to look at new_schedule_date and offset post_processing_lead_time.
11452: -- 2. Removed join with msc_calendar_dates
11453: --=======================================================================================================
11454:
11455: IF (NVL(p_sup_atp_info_rec.insert_flag, 0) = 0) THEN
11456: IF (l_tolerence_defined = 0) AND (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') THEN

Line 11638: FROM msc_calendar_dates c,

11634: p_sup_atp_info_rec.supplier_id,
11635: p_sup_atp_info_rec.supplier_site_id,
11636: -- ship_rec_cal
11637: c.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))) quantity
11638: FROM msc_calendar_dates c,
11639: msc_supplier_capacities s
11640: WHERE s.inventory_item_id = l_inv_item_id
11641: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11642: AND s.plan_id = p_sup_atp_info_rec.plan_id

Line 11649: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)

11645: AND NVL(s.supplier_site_id, -1) = NVL(p_sup_atp_info_rec.supplier_site_id, -1)
11646: AND c.calendar_date BETWEEN trunc(s.from_date)
11647: --AND NVL(s.to_date,l_cutoff_date)
11648: AND trunc(NVL(s.to_date,least(p_sup_atp_info_rec.last_cap_date,l_cutoff_date))) --4055719
11649: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)
11650: AND c.calendar_code = l_calendar_code
11651: AND c.exception_set_id = l_calendar_exception_set_id
11652: AND c.sr_instance_id = s.sr_instance_id -- Changed from l_instance_id ?
11653: AND c.calendar_date >= p_sup_atp_info_rec.sup_cap_cum_date

Line 11724: FROM msc_calendar_dates c,

11720: p_sup_atp_info_rec.supplier_id,
11721: p_sup_atp_info_rec.supplier_site_id,
11722: -- ship_rec_cal
11723: c.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))) quantity
11724: FROM msc_calendar_dates c,
11725: msc_supplier_capacities s
11726: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
11727: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11728: AND s.plan_id = p_sup_atp_info_rec.plan_id

Line 11735: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)

11731: AND NVL(s.supplier_site_id, -1) = NVL(p_sup_atp_info_rec.supplier_site_id, -1)
11732: AND c.calendar_date BETWEEN trunc(s.from_date)
11733: --AND NVL(s.to_date,l_cutoff_date)
11734: AND trunc(NVL(s.to_date,least(p_sup_atp_info_rec.last_cap_date,l_cutoff_date))) --4055719
11735: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)
11736: AND c.calendar_code = l_calendar_code
11737: AND c.exception_set_id = l_calendar_exception_set_id
11738: AND c.sr_instance_id = s.sr_instance_id -- Changed from l_instance_id ?
11739: AND c.calendar_date >= trunc(p_sup_atp_info_rec.sup_cap_cum_date) --4135752

Line 11874: FROM msc_calendar_dates c,

11870: FND_GLOBAL.User_ID,
11871: l_sysdate,
11872: FND_GLOBAL.User_ID,
11873: FND_GLOBAL.User_ID
11874: FROM msc_calendar_dates c,
11875: msc_supplier_capacities s
11876: WHERE s.inventory_item_id = l_inv_item_id
11877: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11878: AND s.plan_id = p_sup_atp_info_rec.plan_id

Line 11885: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)

11881: AND NVL(s.supplier_site_id, -1) = NVL(p_sup_atp_info_rec.supplier_site_id, -1)
11882: AND c.calendar_date BETWEEN trunc(s.from_date)
11883: --AND NVL(s.to_date,l_cutoff_date)
11884: AND trunc(NVL(s.to_date,least(p_sup_atp_info_rec.last_cap_date,l_cutoff_date))) --4055719
11885: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)
11886: AND c.calendar_code = l_calendar_code
11887: AND c.exception_set_id = l_calendar_exception_set_id
11888: AND c.sr_instance_id = s.sr_instance_id -- Changed from l_instance_id ?
11889: AND c.calendar_date >= trunc(p_sup_atp_info_rec.sup_cap_cum_date) --4135752

Line 12044: FROM msc_calendar_dates c,

12040: FND_GLOBAL.User_ID,
12041: l_sysdate,
12042: FND_GLOBAL.User_ID,
12043: FND_GLOBAL.User_ID
12044: FROM msc_calendar_dates c,
12045: msc_supplier_capacities s
12046: WHERE s.inventory_item_id = l_inv_item_id
12047: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
12048: AND s.plan_id = p_sup_atp_info_rec.plan_id

Line 12055: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)

12051: AND NVL(s.supplier_site_id, -1) = NVL(p_sup_atp_info_rec.supplier_site_id, -1)
12052: AND c.calendar_date BETWEEN trunc(s.from_date)
12053: --AND NVL(s.to_date,l_cutoff_date)
12054: AND trunc(NVL(s.to_date,least(p_sup_atp_info_rec.last_cap_date,l_cutoff_date))) --4055719
12055: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)
12056: AND c.calendar_code = l_calendar_code
12057: AND c.exception_set_id = l_calendar_exception_set_id
12058: AND c.sr_instance_id = s.sr_instance_id -- Changed from l_instance_id ?
12059: AND c.calendar_date >= p_sup_atp_info_rec.sup_cap_cum_date

Line 12288: l_last_cap_date := MSC_CALENDAR.DATE_OFFSET(p_sup_atp_info_rec.organization_id,

12284: --first get the next working from the last day on which capacity is defined.
12285: IF PG_DEBUG in ('Y', 'C') THEN
12286: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'l_last_cap_date := ' || l_last_cap_date);
12287: END IF;
12288: l_last_cap_date := MSC_CALENDAR.DATE_OFFSET(p_sup_atp_info_rec.organization_id,
12289: p_sup_atp_info_rec.instance_id,
12290: 1,
12291: l_last_cap_date,
12292: 1);

Line 12612: FROM msc_calendar_dates c,

12608: FROM (
12609: SELECT c.calendar_date l_date,
12610: s.weight_capacity weight,
12611: s.volume_capacity volume
12612: FROM msc_calendar_dates c,
12613: msc_interorg_ship_methods s,
12614: msc_trading_partners tp,
12615: msc_plans p
12616: WHERE s.plan_id = p_plan_id

Line 13010: msc_calendar_dates c,

13006: p_scenario_id col27, -- scenario_id
13007: null col28, -- pegging_id
13008: null col29 -- end_pegging_id
13009: FROM
13010: msc_calendar_dates c,
13011: msc_interorg_ship_methods s,
13012: msc_trading_partners tp,
13013: msc_plans p
13014: WHERE

Line 13170: msc_calendar_dates c,

13166: p_scenario_id col27, -- scenairo_id
13167: null col28, -- pegging_id
13168: null col29 -- end_pegging_id
13169: FROM
13170: msc_calendar_dates c,
13171: msc_interorg_ship_methods s,
13172: msc_trading_partners tp,
13173: msc_plans p
13174: WHERE