[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,
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
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,
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
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
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
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,
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
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,
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
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
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
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
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
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
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
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
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,
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,
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
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
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
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
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
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
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
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
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
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
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
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