[Home] [Help]
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
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
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,
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 ;
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 ;
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
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,
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
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,
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
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
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
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,
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
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,
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
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
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
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
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
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
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
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
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,
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,
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
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
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
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
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
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
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
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
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
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
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
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