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 6294: MSC_CALENDAR_DATES C1,

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

Line 6295: MSC_CALENDAR_DATES C2

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

Line 6585: MSC_CALENDAR_DATES C1,

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

Line 6586: MSC_CALENDAR_DATES C2

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

Line 6786: MSC_CALENDAR_DATES C1,

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

Line 6787: MSC_CALENDAR_DATES C2

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

Line 6938: MSC_CALENDAR_DATES C1,

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

Line 6939: MSC_CALENDAR_DATES C2

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

Line 7125: FROM MSC_CALENDAR_DATES C2,

7121: 1 actual_resource_usage,
7122: l_null_num reverse_cumulative_yield,
7123: l_null_char department_code,
7124: l_null_char resource_Code
7125: FROM MSC_CALENDAR_DATES C2,
7126: MSC_CALENDAR_DATES C1,
7127: MSC_ROUTINGS RTG,
7128: MSC_SYSTEM_ITEMS I
7129: WHERE I.PLAN_ID = RTG.PLAN_ID

Line 7126: MSC_CALENDAR_DATES C1,

7122: l_null_num reverse_cumulative_yield,
7123: l_null_char department_code,
7124: l_null_char resource_Code
7125: FROM MSC_CALENDAR_DATES C2,
7126: MSC_CALENDAR_DATES C1,
7127: MSC_ROUTINGS RTG,
7128: MSC_SYSTEM_ITEMS I
7129: WHERE I.PLAN_ID = RTG.PLAN_ID
7130: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID

Line 7253: MSC_CALENDAR_DATES C1,

7249: MSC_ROUTING_OPERATIONS OP,
7250: MSC_OPERATION_RESOURCE_SEQS SEQ,
7251: MSC_OPERATION_RESOURCES RES,
7252: MSC_DEPARTMENT_RESOURCES DR,
7253: MSC_CALENDAR_DATES C1,
7254: MSC_CALENDAR_DATES C2
7255:
7256: WHERE I.PLAN_ID = RTG.PLAN_ID
7257: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID

Line 7254: MSC_CALENDAR_DATES C2

7250: MSC_OPERATION_RESOURCE_SEQS SEQ,
7251: MSC_OPERATION_RESOURCES RES,
7252: MSC_DEPARTMENT_RESOURCES DR,
7253: MSC_CALENDAR_DATES C1,
7254: MSC_CALENDAR_DATES C2
7255:
7256: WHERE I.PLAN_ID = RTG.PLAN_ID
7257: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID
7258: AND I.INVENTORY_ITEM_ID = RTG.ASSEMBLY_ITEM_ID

Line 7339: FROM MSC_CALENDAR_DATES C2,

7335: 1 actual_resource_usage,
7336: l_null_num reverse_cumulative_yield,
7337: l_null_char department_code,
7338: l_null_char resource_Code
7339: FROM MSC_CALENDAR_DATES C2,
7340: MSC_CALENDAR_DATES C1,
7341: MSC_ROUTINGS RTG,
7342: MSC_SYSTEM_ITEMS I
7343: WHERE I.PLAN_ID = RTG.PLAN_ID

Line 7340: MSC_CALENDAR_DATES C1,

7336: l_null_num reverse_cumulative_yield,
7337: l_null_char department_code,
7338: l_null_char resource_Code
7339: FROM MSC_CALENDAR_DATES C2,
7340: MSC_CALENDAR_DATES C1,
7341: MSC_ROUTINGS RTG,
7342: MSC_SYSTEM_ITEMS I
7343: WHERE I.PLAN_ID = RTG.PLAN_ID
7344: AND I.SR_INSTANCE_ID = RTG.SR_INSTANCE_ID

Line 7442: msc_calendar_dates c1,

7438: l_res_requirements.resource_code
7439:
7440: FROM msc_department_resources dr,
7441: msc_bor_requirements b,
7442: msc_calendar_dates c1,
7443: msc_calendar_dates c2
7444: WHERE B.PLAN_ID = p_plan_id
7445: AND B.SR_INSTANCE_ID = p_instance_id
7446: AND B.ORGANIZATION_ID = p_organization_id

Line 7443: msc_calendar_dates c2

7439:
7440: FROM msc_department_resources dr,
7441: msc_bor_requirements b,
7442: msc_calendar_dates c1,
7443: msc_calendar_dates c2
7444: WHERE B.PLAN_ID = p_plan_id
7445: AND B.SR_INSTANCE_ID = p_instance_id
7446: AND B.ORGANIZATION_ID = p_organization_id
7447: AND B.ASSEMBLY_ITEM_ID = l_inv_item_id

Line 8134: MSC_CALENDAR.DATE_OFFSET

8130: -- Use Org's Manuf. Calendar
8131:
8132: ---2178544
8133: l_requested_date := GREATEST(l_requested_date,
8134: MSC_CALENDAR.DATE_OFFSET
8135: (p_organization_id,
8136: p_instance_id,
8137: 1,
8138: MSC_ATP_PVT.G_PTF_DATE,

Line 8205: l_res_availability_date := MSC_CALENDAR.DATE_OFFSET

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

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

8207: p_instance_id,
8208: 1,
8209: l_res_atp_date,
8210: NVL(l_lead_time, 0));
8211: /* x_atp_date := GREATEST(MSC_CALENDAR.DATE_OFFSET
8212: (p_organization_id,
8213: p_instance_id,
8214: 1,
8215: l_res_atp_date,

Line 8369: l_res_start_date := LEAST(MSC_CALENDAR.DATE_OFFSET

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

Line 8705: l_res_start_date := LEAST(MSC_CALENDAR.DATE_OFFSET

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

Line 9376: MSC_CALENDAR_DATES C2,

9372: mbc.rounding_direction rounding_direction,
9373: mbc.component_yield_factor component_yield_factor,
9374: MBC.USAGE_QUANTITY*mbc.component_yield_factor usage_qty --4775920
9375: FROM MSC_SYSTEM_ITEMS I2,
9376: MSC_CALENDAR_DATES C2,
9377: MSC_CALENDAR_DATES C1,
9378: MSC_BOM_COMPONENTS MBC,
9379: MSC_BOMS BOMS,
9380: MSC_SYSTEM_ITEMS I,

Line 9377: MSC_CALENDAR_DATES C1,

9373: mbc.component_yield_factor component_yield_factor,
9374: MBC.USAGE_QUANTITY*mbc.component_yield_factor usage_qty --4775920
9375: FROM MSC_SYSTEM_ITEMS I2,
9376: MSC_CALENDAR_DATES C2,
9377: MSC_CALENDAR_DATES C1,
9378: MSC_BOM_COMPONENTS MBC,
9379: MSC_BOMS BOMS,
9380: MSC_SYSTEM_ITEMS I,
9381: MSC_OPERATION_COMPONENTS OPC,

Line 9524: MSC_CALENDAR_DATES C2,

9520: mbc.rounding_direction,
9521: mbc.component_yield_factor, --4570421
9522: MBC.USAGE_QUANTITY*mbc.component_yield_factor --4775920
9523: FROM MSC_SYSTEM_ITEMS I2,
9524: MSC_CALENDAR_DATES C2,
9525: MSC_CALENDAR_DATES C1,
9526: MSC_BOM_COMPONENTS MBC,
9527: MSC_BOMS BOMS
9528: WHERE BOMS.PLAN_ID = p_plan_id

Line 9525: MSC_CALENDAR_DATES C1,

9521: mbc.component_yield_factor, --4570421
9522: MBC.USAGE_QUANTITY*mbc.component_yield_factor --4775920
9523: FROM MSC_SYSTEM_ITEMS I2,
9524: MSC_CALENDAR_DATES C2,
9525: MSC_CALENDAR_DATES C1,
9526: MSC_BOM_COMPONENTS MBC,
9527: MSC_BOMS BOMS
9528: WHERE BOMS.PLAN_ID = p_plan_id
9529: AND BOMS.SR_INSTANCE_ID = p_instance_id

Line 9577: msc_calendar_dates c2,

9573: mbt.source_organization_id,
9574: -- krajan : 2462661
9575: mbt.atp_flag
9576: FROM msc_bom_temp mbt,
9577: msc_calendar_dates c2,
9578: msc_calendar_dates c1,
9579: msc_trading_partners tp
9580: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID
9581: --AND mbt.assembly_identifier = MSC_ATP_PVT.G_ASSEMBLY_LINE_ID

Line 9578: msc_calendar_dates c1,

9574: -- krajan : 2462661
9575: mbt.atp_flag
9576: FROM msc_bom_temp mbt,
9577: msc_calendar_dates c2,
9578: msc_calendar_dates c1,
9579: msc_trading_partners tp
9580: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID
9581: --AND mbt.assembly_identifier = MSC_ATP_PVT.G_ASSEMBLY_LINE_ID
9582: AND mbt.assembly_identifier = MSC_ATP_PVT.G_COMP_LINE_ID

Line 10020: l_request_date := MSC_CALENDAR.DATE_OFFSET

10016: msc_sch_wb.atp_debug('l_lead_time = ' || l_lead_time);
10017: END IF;
10018:
10019: IF nvl(l_lead_time, 0) > 0 AND p_search = 1 THEN
10020: l_request_date := MSC_CALENDAR.DATE_OFFSET
10021: (p_organization_id,
10022: p_instance_id,
10023: 1,
10024: l_explode_comp.requested_date(i),

Line 11046: x_atp_date := GREATEST(MSC_CALENDAR.DATE_OFFSET

11042: msc_sch_wb.atp_debug('Get_Comp_Requirements: ' || 'p_search = 2');
11043: END IF;
11044:
11045: IF l_atp_rec.ship_date IS NOT NULL THEN
11046: x_atp_date := GREATEST(MSC_CALENDAR.DATE_OFFSET
11047: (p_organization_id,
11048: p_instance_id,
11049: 1,
11050: l_atp_rec.ship_date,

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

11308: l_calendar_code := p_sup_atp_info_rec.manufacturing_cal_code;
11309:
11310: l_calendar_exception_set_id := -1;
11311: -- l_enforce_sup_capacity := NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.enforce_sup_capacity, 2); -- Enforce Pur LT
11312: l_sysdate := MSC_CALENDAR.PREV_WORK_DAY(l_calendar_code, p_sup_atp_info_rec.instance_id, sysdate);
11313: 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);
11314:
11315: /* Enforce Pur LT - capacity is always enforced
11316: Removed code to check the plan type. This was earlier required as capacity constraints were earlier enforced

Line 11313: 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);

11309:
11310: l_calendar_exception_set_id := -1;
11311: -- l_enforce_sup_capacity := NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.enforce_sup_capacity, 2); -- Enforce Pur LT
11312: l_sysdate := MSC_CALENDAR.PREV_WORK_DAY(l_calendar_code, p_sup_atp_info_rec.instance_id, sysdate);
11313: 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);
11314:
11315: /* Enforce Pur LT - capacity is always enforced
11316: Removed code to check the plan type. This was earlier required as capacity constraints were earlier enforced
11317: only for unconstrained plans or if the plan option to enforce capacity was enforced. Now this is not required

Line 11340: l_last_cap_next_date := MSC_CALENDAR.NEXT_WORK_DAY(

11336: Date is passed from there. If the passed date is NULL then it means capacity is not defined.*/
11337: -- IF (p_sup_atp_info_rec.supplier_id = -99) OR (l_plan_type = 1 AND l_enforce_sup_capacity = 2) THEN
11338: IF (p_sup_atp_info_rec.supplier_id = -99) OR p_sup_atp_info_rec.last_cap_date IS NULL THEN
11339: l_capacity_defined := 0;
11340: l_last_cap_next_date := MSC_CALENDAR.NEXT_WORK_DAY(
11341: l_calendar_code,
11342: p_sup_atp_info_rec.instance_id,
11343: GREATEST(l_plan_start_date, MSC_ATP_PVT.G_PTF_DATE, p_sup_atp_info_rec.sup_cap_cum_date));
11344: ELSE

Line 11346: l_last_cap_next_date := MSC_CALENDAR.NEXT_WORK_DAY(

11342: p_sup_atp_info_rec.instance_id,
11343: GREATEST(l_plan_start_date, MSC_ATP_PVT.G_PTF_DATE, p_sup_atp_info_rec.sup_cap_cum_date));
11344: ELSE
11345: l_capacity_defined := 1;
11346: l_last_cap_next_date := MSC_CALENDAR.NEXT_WORK_DAY(
11347: l_calendar_code,
11348: p_sup_atp_info_rec.instance_id,
11349: p_sup_atp_info_rec.last_cap_date + 1);
11350: END IF;

Line 11485: -- 2. Removed join with msc_calendar_dates

11481: -- are the changes:
11482: -- 1. We use new_dock_date or new_ship_date depending on whether supplier capacity is dock capacity or
11483: -- ship capacity.
11484: -- Earlier we used to look at new_schedule_date and offset post_processing_lead_time.
11485: -- 2. Removed join with msc_calendar_dates
11486: --=======================================================================================================
11487:
11488: IF (NVL(p_sup_atp_info_rec.insert_flag, 0) = 0) THEN
11489: IF (l_tolerence_defined = 0) AND (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') THEN

Line 11671: FROM msc_calendar_dates c,

11667: p_sup_atp_info_rec.supplier_id,
11668: p_sup_atp_info_rec.supplier_site_id,
11669: -- ship_rec_cal
11670: c.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))) quantity
11671: FROM msc_calendar_dates c,
11672: msc_supplier_capacities s
11673: WHERE s.inventory_item_id = l_inv_item_id
11674: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11675: AND s.plan_id = p_sup_atp_info_rec.plan_id

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

11678: AND NVL(s.supplier_site_id, -1) = NVL(p_sup_atp_info_rec.supplier_site_id, -1)
11679: AND c.calendar_date BETWEEN trunc(s.from_date)
11680: --AND NVL(s.to_date,l_cutoff_date)
11681: AND trunc(NVL(s.to_date,least(p_sup_atp_info_rec.last_cap_date,l_cutoff_date))) --4055719
11682: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)
11683: AND c.calendar_code = l_calendar_code
11684: AND c.exception_set_id = l_calendar_exception_set_id
11685: AND c.sr_instance_id = s.sr_instance_id -- Changed from l_instance_id ?
11686: AND c.calendar_date >= p_sup_atp_info_rec.sup_cap_cum_date

Line 11757: FROM msc_calendar_dates c,

11753: p_sup_atp_info_rec.supplier_id,
11754: p_sup_atp_info_rec.supplier_site_id,
11755: -- ship_rec_cal
11756: c.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))) quantity
11757: FROM msc_calendar_dates c,
11758: msc_supplier_capacities s
11759: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
11760: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11761: AND s.plan_id = p_sup_atp_info_rec.plan_id

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

11764: AND NVL(s.supplier_site_id, -1) = NVL(p_sup_atp_info_rec.supplier_site_id, -1)
11765: AND c.calendar_date BETWEEN trunc(s.from_date)
11766: --AND NVL(s.to_date,l_cutoff_date)
11767: AND trunc(NVL(s.to_date,least(p_sup_atp_info_rec.last_cap_date,l_cutoff_date))) --4055719
11768: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)
11769: AND c.calendar_code = l_calendar_code
11770: AND c.exception_set_id = l_calendar_exception_set_id
11771: AND c.sr_instance_id = s.sr_instance_id -- Changed from l_instance_id ?
11772: AND c.calendar_date >= trunc(p_sup_atp_info_rec.sup_cap_cum_date) --4135752

Line 11907: FROM msc_calendar_dates c,

11903: FND_GLOBAL.User_ID,
11904: l_sysdate,
11905: FND_GLOBAL.User_ID,
11906: FND_GLOBAL.User_ID
11907: FROM msc_calendar_dates c,
11908: msc_supplier_capacities s
11909: WHERE s.inventory_item_id = l_inv_item_id
11910: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11911: AND s.plan_id = p_sup_atp_info_rec.plan_id

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

11914: AND NVL(s.supplier_site_id, -1) = NVL(p_sup_atp_info_rec.supplier_site_id, -1)
11915: AND c.calendar_date BETWEEN trunc(s.from_date)
11916: --AND NVL(s.to_date,l_cutoff_date)
11917: AND trunc(NVL(s.to_date,least(p_sup_atp_info_rec.last_cap_date,l_cutoff_date))) --4055719
11918: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)
11919: AND c.calendar_code = l_calendar_code
11920: AND c.exception_set_id = l_calendar_exception_set_id
11921: AND c.sr_instance_id = s.sr_instance_id -- Changed from l_instance_id ?
11922: AND c.calendar_date >= trunc(p_sup_atp_info_rec.sup_cap_cum_date) --4135752

Line 12077: FROM msc_calendar_dates c,

12073: FND_GLOBAL.User_ID,
12074: l_sysdate,
12075: FND_GLOBAL.User_ID,
12076: FND_GLOBAL.User_ID
12077: FROM msc_calendar_dates c,
12078: msc_supplier_capacities s
12079: WHERE s.inventory_item_id = l_inv_item_id
12080: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
12081: AND s.plan_id = p_sup_atp_info_rec.plan_id

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

12084: AND NVL(s.supplier_site_id, -1) = NVL(p_sup_atp_info_rec.supplier_site_id, -1)
12085: AND c.calendar_date BETWEEN trunc(s.from_date)
12086: --AND NVL(s.to_date,l_cutoff_date)
12087: AND trunc(NVL(s.to_date,least(p_sup_atp_info_rec.last_cap_date,l_cutoff_date))) --4055719
12088: AND (c.seq_num IS NOT NULL OR p_sup_atp_info_rec.manufacturing_cal_code = MSC_CALENDAR.FOC)
12089: AND c.calendar_code = l_calendar_code
12090: AND c.exception_set_id = l_calendar_exception_set_id
12091: AND c.sr_instance_id = s.sr_instance_id -- Changed from l_instance_id ?
12092: AND c.calendar_date >= p_sup_atp_info_rec.sup_cap_cum_date

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

12317: --first get the next working from the last day on which capacity is defined.
12318: IF PG_DEBUG in ('Y', 'C') THEN
12319: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'l_last_cap_date := ' || l_last_cap_date);
12320: END IF;
12321: l_last_cap_date := MSC_CALENDAR.DATE_OFFSET(p_sup_atp_info_rec.organization_id,
12322: p_sup_atp_info_rec.instance_id,
12323: 1,
12324: l_last_cap_date,
12325: 1);

Line 12645: FROM msc_calendar_dates c,

12641: FROM (
12642: SELECT c.calendar_date l_date,
12643: s.weight_capacity weight,
12644: s.volume_capacity volume
12645: FROM msc_calendar_dates c,
12646: msc_interorg_ship_methods s,
12647: msc_trading_partners tp,
12648: msc_plans p
12649: WHERE s.plan_id = p_plan_id

Line 13043: msc_calendar_dates c,

13039: p_scenario_id col27, -- scenario_id
13040: null col28, -- pegging_id
13041: null col29 -- end_pegging_id
13042: FROM
13043: msc_calendar_dates c,
13044: msc_interorg_ship_methods s,
13045: msc_trading_partners tp,
13046: msc_plans p
13047: WHERE

Line 13203: msc_calendar_dates c,

13199: p_scenario_id col27, -- scenairo_id
13200: null col28, -- pegging_id
13201: null col29 -- end_pegging_id
13202: FROM
13203: msc_calendar_dates c,
13204: msc_interorg_ship_methods s,
13205: msc_trading_partners tp,
13206: msc_plans p
13207: WHERE