[Home] [Help]
155: DECODE(REQ.record_source, 2, REQ.RESOURCE_HOURS,
156: REQ.DAILY_RESOURCE_HOURS))) SD_QTY
157: -- For ATP created records use resource_hours
158: -- End Bug 3348095
159: FROM MSC_DEPARTMENT_RESOURCES DR,
160: MSC_RESOURCE_REQUIREMENTS REQ,
161: -- CTO Option Dependent Resources ODR
162: -- Option Dependent Resources Capacity Check
163: -- Add Link to Items
261: DECODE(REQ.record_source, 2, REQ.RESOURCE_HOURS,
262: REQ.DAILY_RESOURCE_HOURS))) SD_QTY
263: -- For ATP created records use resource_hours
264: -- End Bug 3348095
265: FROM MSC_DEPARTMENT_RESOURCES DR,
266: MSC_RESOURCE_REQUIREMENTS REQ,
267: -- CTO Option Dependent Resources ODR
268: -- Option Dependent Resources Capacity Check
269: -- Add Link to Items
378: *
379: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
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
504: *
505: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
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
694: FND_GLOBAL.User_ID,
695: l_sysdate,
696: FND_GLOBAL.User_ID,
697: FND_GLOBAL.User_ID
698: FROM MSC_DEPARTMENT_RESOURCES DR,
699: MSC_RESOURCE_REQUIREMENTS REQ,
700: -- CTO Option Dependent Resources
701: -- Option Dependent Resources Capacity Check
702: -- Add Link to Items
899: FND_GLOBAL.User_ID,
900: l_sysdate,
901: FND_GLOBAL.User_ID,
902: FND_GLOBAL.User_ID
903: FROM MSC_DEPARTMENT_RESOURCES DR,
904: MSC_RESOURCE_REQUIREMENTS REQ,
905: -- CTO Option Dependent Resources
906: -- Option Dependent Resources Capacity Check
907: -- Add Link to Items
1111: FND_GLOBAL.User_ID,
1112: l_sysdate,
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,
1334: FND_GLOBAL.User_ID,
1335: l_sysdate,
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,
1503: -- For ATP created records use end_date otherwise start_date
1504: SELECT TRUNC(NVL(REQ.END_DATE, REQ.START_DATE)) SD_DATE,
1505: -- End Bug 3348095
1506: -1 * REQ.RESOURCE_HOURS SD_QTY -- Summary enhancement: Need to bother only about ATP generated records
1507: FROM MSC_DEPARTMENT_RESOURCES DR,
1508: MSC_RESOURCE_REQUIREMENTS REQ,
1509: MSC_PLANS P -- For summary enhancement
1510: --bug3394866
1511: WHERE DR.PLAN_ID = p_plan_id
6110: MSC_ROUTINGS RTG,
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
6289: MSC_BOM_COMPONENTS mbc,
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
6580: MSC_ROUTINGS RTG,
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
6781: MSC_ROUTINGS RTG,
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
6933: MSC_BOM_COMPONENTS mbc,
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
7248: MSC_ROUTINGS RTG,
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
7436: l_res_requirements.reverse_cumulative_yield,
7437: l_res_requirements.department_code,
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