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_POST_PRO dependencies on MSC_SYSTEM_ITEMS

Line 280: MSC_SYSTEM_ITEMS I,

276: (D.PRIMARY_UOM_QUANTITY-
277: GREATEST(NVL(D.RESERVATION_QUANTITY,0),
278: D.COMPLETED_QUANTITY)) sd_qty
279: FROM
280: MSC_SYSTEM_ITEMS I,
281: MSC_ATP_RULES R,
282: MSC_SALES_ORDERS D,
283: MSC_CALENDAR_DATES C,
284: MSC_CALENDAR_DATES C2,

Line 372: MSC_SYSTEM_ITEMS I,

368: NVL(TP.default_demand_class,'@@@')), '@@@') demand_class,
369: C.PRIOR_DATE SD_DATE, -- 2859130
370: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
371: FROM
372: MSC_SYSTEM_ITEMS I,
373: MSC_SYSTEM_ITEMS I2,
374: MSC_ATP_RULES R,
375: MSC_DEMANDS D,
376: MSC_CALENDAR_DATES C,

Line 373: MSC_SYSTEM_ITEMS I2,

369: C.PRIOR_DATE SD_DATE, -- 2859130
370: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
371: FROM
372: MSC_SYSTEM_ITEMS I,
373: MSC_SYSTEM_ITEMS I2,
374: MSC_ATP_RULES R,
375: MSC_DEMANDS D,
376: MSC_CALENDAR_DATES C,
377: MSC_CALENDAR_DATES C2,

Line 434: MSC_SYSTEM_ITEMS I,

430: -1,S.Daily_rate*(C.Calendar_date - TRUNC(S.First_Unit_Start_date)+1)
431: - S.qty_completed, S.Daily_rate),
432: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) ) SD_QTY
433: FROM
434: MSC_SYSTEM_ITEMS I,
435: MSC_SYSTEM_ITEMS I2,
436: MSC_ATP_RULES R,
437: MSC_SUPPLIES S,
438: MSC_SUB_INVENTORIES MSI,

Line 435: MSC_SYSTEM_ITEMS I2,

431: - S.qty_completed, S.Daily_rate),
432: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) ) SD_QTY
433: FROM
434: MSC_SYSTEM_ITEMS I,
435: MSC_SYSTEM_ITEMS I2,
436: MSC_ATP_RULES R,
437: MSC_SUPPLIES S,
438: MSC_SUB_INVENTORIES MSI,
439: MSC_CALENDAR_DATES C,

Line 771: -- IO Perf:3693983: Moved update of msc_system_items to Load_Plan_SD from atp_snapshot_hook

767: RETCODE := G_SUCCESS;
768: RETURN;
769: END IF;
770:
771: -- IO Perf:3693983: Moved update of msc_system_items to Load_Plan_SD from atp_snapshot_hook
772:
773: select organization_id, sr_instance_id
774: BULK COLLECT INTO l_organization_id, l_sr_instance_id
775: from msc_plan_organizations

Line 780: UPDATE msc_system_items mst1

776: WHERE plan_id=p_plan_id;
777:
778: --FORALL j IN l_organization_id.first.. l_organization_id.last
779: FOR j IN l_organization_id.first.. l_organization_id.last LOOP
780: UPDATE msc_system_items mst1
781: SET (REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG,ATP_RULE_ID,DEMAND_TIME_FENCE_DAYS) =(SELECT REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG,ATP_RULE_ID,DEMAND_TIME_FENCE_DAYS
782: FROM msc_system_items mst2
783: WHERE mst2.sr_instance_id=mst1.sr_instance_id
784: AND mst2.organization_id=mst1.organization_id

Line 782: FROM msc_system_items mst2

778: --FORALL j IN l_organization_id.first.. l_organization_id.last
779: FOR j IN l_organization_id.first.. l_organization_id.last LOOP
780: UPDATE msc_system_items mst1
781: SET (REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG,ATP_RULE_ID,DEMAND_TIME_FENCE_DAYS) =(SELECT REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG,ATP_RULE_ID,DEMAND_TIME_FENCE_DAYS
782: FROM msc_system_items mst2
783: WHERE mst2.sr_instance_id=mst1.sr_instance_id
784: AND mst2.organization_id=mst1.organization_id
785: AND mst2.INVENTORY_ITEM_ID=mst1.INVENTORY_ITEM_ID
786: AND mst2.plan_id=-1

Line 1449: -- ATP4drp Removed commented code for fetch from msc_system_items.

1445: ELSE
1446:
1447: BEGIN
1448: --bug3663487 start SQL_ID 9428030
1449: -- ATP4drp Removed commented code for fetch from msc_system_items.
1450: SELECT 1
1451: INTO l_time_phased
1452: FROM msc_system_items i ,msc_plan_organizations po
1453: WHERE po.plan_id = p_plan_id

Line 1452: FROM msc_system_items i ,msc_plan_organizations po

1448: --bug3663487 start SQL_ID 9428030
1449: -- ATP4drp Removed commented code for fetch from msc_system_items.
1450: SELECT 1
1451: INTO l_time_phased
1452: FROM msc_system_items i ,msc_plan_organizations po
1453: WHERE po.plan_id = p_plan_id
1454: AND i.aggregate_time_fence_date IS NOT NULL
1455: AND i.plan_id = po.plan_id
1456: AND i.organization_id = po.organization_id

Line 2035: MSC_SYSTEM_ITEMS I

2031: D.COMPLETED_QUANTITY)) ) sd_qty
2032: FROM
2033: MSC_SALES_ORDERS D,
2034: MSC_ATP_RULES R,
2035: MSC_SYSTEM_ITEMS I
2036: WHERE D.SR_INSTANCE_ID = l_instance_id
2037: AND I.REFRESH_NUMBER > l_refresh_number -- get all new flag items
2038: AND I.ORGANIZATION_ID = l_organization_id
2039: AND D.SR_INSTANCE_ID = I.SR_INSTANCE_ID

Line 2107: MSC_SYSTEM_ITEMS I

2103: sum(d.old_RESERVATION_QUANTITY) sd_qty
2104: FROM
2105: MSC_SALES_ORDERS D,
2106: MSC_ATP_RULES R,
2107: MSC_SYSTEM_ITEMS I
2108: WHERE D.SR_INSTANCE_ID = l_instance_id
2109: AND D.REFRESH_NUMBER > l_refresh_number
2110: AND I.ORGANIZATION_ID = l_organization_id
2111: AND D.SR_INSTANCE_ID = I.SR_INSTANCE_ID

Line 2200: MSC_SYSTEM_ITEMS I

2196: -- QUESTION ? Does the above SUM actually result in a DELTA??
2197: FROM
2198: MSC_SALES_ORDERS D,
2199: MSC_ATP_RULES R,
2200: MSC_SYSTEM_ITEMS I
2201: WHERE D.SR_INSTANCE_ID = l_instance_id
2202: AND D.REFRESH_NUMBER > l_refresh_number
2203: AND I.ORGANIZATION_ID = l_organization_id
2204: AND D.SR_INSTANCE_ID = I.SR_INSTANCE_ID

Line 2272: MSC_SYSTEM_ITEMS I

2268: -- ANSWER : We are subtratcting the sum of the old quantities.
2269: FROM
2270: MSC_SALES_ORDERS D,
2271: MSC_ATP_RULES R,
2272: MSC_SYSTEM_ITEMS I
2273: WHERE D.SR_INSTANCE_ID = l_instance_id
2274: AND D.REFRESH_NUMBER > l_refresh_number
2275: AND I.ORGANIZATION_ID = l_organization_id
2276: AND D.SR_INSTANCE_ID = I.SR_INSTANCE_ID

Line 2892: MSC_SYSTEM_ITEMS I,

2888: --2 SD_TYPE
2889: FROM MSC_CALENDAR_DATES C,
2890: MSC_DEMANDS D,
2891: MSC_ATP_RULES R,
2892: MSC_SYSTEM_ITEMS I,
2893: MSC_SYSTEM_ITEMS I2
2894: WHERE I.ATP_FLAG = 'Y' --- I.SR_INVENTORY_ITEM_ID = p_inventory_item_id
2895: AND I.ORGANIZATION_ID = l_organization_id
2896: AND I.SR_INSTANCE_ID = p_instance_id

Line 2893: MSC_SYSTEM_ITEMS I2

2889: FROM MSC_CALENDAR_DATES C,
2890: MSC_DEMANDS D,
2891: MSC_ATP_RULES R,
2892: MSC_SYSTEM_ITEMS I,
2893: MSC_SYSTEM_ITEMS I2
2894: WHERE I.ATP_FLAG = 'Y' --- I.SR_INVENTORY_ITEM_ID = p_inventory_item_id
2895: AND I.ORGANIZATION_ID = l_organization_id
2896: AND I.SR_INSTANCE_ID = p_instance_id
2897: AND I.PLAN_ID = -1

Line 2947: MSC_SYSTEM_ITEMS I,

2943: --2 SD_TYPE
2944: FROM MSC_CALENDAR_DATES C,
2945: MSC_DEMANDS D,
2946: MSC_ATP_RULES R,
2947: MSC_SYSTEM_ITEMS I,
2948: MSC_SYSTEM_ITEMS I2
2949: WHERE I.ATP_FLAG = 'Y' --- I.SR_INVENTORY_ITEM_ID = p_inventory_item_id
2950: AND I.ORGANIZATION_ID = l_organization_id
2951: AND I.SR_INSTANCE_ID = p_instance_id

Line 2948: MSC_SYSTEM_ITEMS I2

2944: FROM MSC_CALENDAR_DATES C,
2945: MSC_DEMANDS D,
2946: MSC_ATP_RULES R,
2947: MSC_SYSTEM_ITEMS I,
2948: MSC_SYSTEM_ITEMS I2
2949: WHERE I.ATP_FLAG = 'Y' --- I.SR_INVENTORY_ITEM_ID = p_inventory_item_id
2950: AND I.ORGANIZATION_ID = l_organization_id
2951: AND I.SR_INSTANCE_ID = p_instance_id
2952: AND I.PLAN_ID = -1

Line 3004: FROM MSC_SYSTEM_ITEMS I,

3000: -1,S.Daily_rate* (C.Calendar_date - TRUNC(S.First_Unit_Start_date) +1) -
3001: S.qty_completed, S.Daily_rate),
3002: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) ) SD_QTY
3003: -- Changed the order of the tables for 5098576/5199686
3004: FROM MSC_SYSTEM_ITEMS I,
3005: MSC_SYSTEM_ITEMS I2,
3006: MSC_SUPPLIES S,
3007: MSC_ATP_RULES R,
3008: MSC_SUB_INVENTORIES MSI,

Line 3005: MSC_SYSTEM_ITEMS I2,

3001: S.qty_completed, S.Daily_rate),
3002: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) ) SD_QTY
3003: -- Changed the order of the tables for 5098576/5199686
3004: FROM MSC_SYSTEM_ITEMS I,
3005: MSC_SYSTEM_ITEMS I2,
3006: MSC_SUPPLIES S,
3007: MSC_ATP_RULES R,
3008: MSC_SUB_INVENTORIES MSI,
3009: MSC_CALENDAR_DATES C

Line 3014: MSC_SYSTEM_ITEMS I,

3010:
3011: /* FROM MSC_CALENDAR_DATES C,
3012: MSC_SUPPLIES S,
3013: MSC_ATP_RULES R,
3014: MSC_SYSTEM_ITEMS I,
3015: --- bug 2162571 add to another table to get info about product family
3016: MSC_SYSTEM_ITEMS I2,
3017: MSC_SUB_INVENTORIES MSI*/ -- commented for 5098576/5199686
3018: WHERE I.ATP_FLAG = 'Y' ---I.SR_INVENTORY_ITEM_ID = p_inventory_item_id

Line 3016: MSC_SYSTEM_ITEMS I2,

3012: MSC_SUPPLIES S,
3013: MSC_ATP_RULES R,
3014: MSC_SYSTEM_ITEMS I,
3015: --- bug 2162571 add to another table to get info about product family
3016: MSC_SYSTEM_ITEMS I2,
3017: MSC_SUB_INVENTORIES MSI*/ -- commented for 5098576/5199686
3018: WHERE I.ATP_FLAG = 'Y' ---I.SR_INVENTORY_ITEM_ID = p_inventory_item_id
3019: AND I.ORGANIZATION_ID = l_organization_id
3020: AND I.SR_INSTANCE_ID = p_instance_id

Line 3115: MSC_SYSTEM_ITEMS I,

3111:
3112: /*FROM MSC_CALENDAR_DATES C,
3113: MSC_SUPPLIES S,
3114: MSC_ATP_RULES R,
3115: MSC_SYSTEM_ITEMS I,
3116: MSC_SYSTEM_ITEMS I2,
3117: MSC_SUB_INVENTORIES MSI*/
3118: -- Commented 5098576./5199686
3119: -- changed order of tables for 5098576/5199686

Line 3116: MSC_SYSTEM_ITEMS I2,

3112: /*FROM MSC_CALENDAR_DATES C,
3113: MSC_SUPPLIES S,
3114: MSC_ATP_RULES R,
3115: MSC_SYSTEM_ITEMS I,
3116: MSC_SYSTEM_ITEMS I2,
3117: MSC_SUB_INVENTORIES MSI*/
3118: -- Commented 5098576./5199686
3119: -- changed order of tables for 5098576/5199686
3120: FROM MSC_SYSTEM_ITEMS I,

Line 3120: FROM MSC_SYSTEM_ITEMS I,

3116: MSC_SYSTEM_ITEMS I2,
3117: MSC_SUB_INVENTORIES MSI*/
3118: -- Commented 5098576./5199686
3119: -- changed order of tables for 5098576/5199686
3120: FROM MSC_SYSTEM_ITEMS I,
3121: MSC_SYSTEM_ITEMS I2,
3122: MSC_SUPPLIES S,
3123: MSC_ATP_RULES R,
3124: MSC_SUB_INVENTORIES MSI,

Line 3121: MSC_SYSTEM_ITEMS I2,

3117: MSC_SUB_INVENTORIES MSI*/
3118: -- Commented 5098576./5199686
3119: -- changed order of tables for 5098576/5199686
3120: FROM MSC_SYSTEM_ITEMS I,
3121: MSC_SYSTEM_ITEMS I2,
3122: MSC_SUPPLIES S,
3123: MSC_ATP_RULES R,
3124: MSC_SUB_INVENTORIES MSI,
3125: MSC_CALENDAR_DATES C

Line 3779: ---first we check if _999999 partition exists on MSC_SYSTEM_ITEMS or not.

3775: msc_util.msc_log('l_share_partition := ' || l_share_partition);
3776:
3777: IF l_share_partition = 'Y' then
3778: msc_util.msc_log('Share partition is on');
3779: ---first we check if _999999 partition exists on MSC_SYSTEM_ITEMS or not.
3780: ---1) If it exists then the _999999 partition might or might not exist om
3781: --- the atp summary tables. In this case we check and create it if it doesn't exist
3782: ---2) If partition on msc_system_items doesn't exist then that means customer is running
3783: --- create APS partition proram for the first time. So we let create_partition_pvt

Line 3782: ---2) If partition on msc_system_items doesn't exist then that means customer is running

3778: msc_util.msc_log('Share partition is on');
3779: ---first we check if _999999 partition exists on MSC_SYSTEM_ITEMS or not.
3780: ---1) If it exists then the _999999 partition might or might not exist om
3781: --- the atp summary tables. In this case we check and create it if it doesn't exist
3782: ---2) If partition on msc_system_items doesn't exist then that means customer is running
3783: --- create APS partition proram for the first time. So we let create_partition_pvt
3784: --- in MSCPRPRB.pls create the patitions
3785: l_table_name := 'MSC_SYSTEM_ITEMS';
3786: l_partition_name := 'SYSTEM_ITEMS' || '_' || MAXVALUE;

Line 3785: l_table_name := 'MSC_SYSTEM_ITEMS';

3781: --- the atp summary tables. In this case we check and create it if it doesn't exist
3782: ---2) If partition on msc_system_items doesn't exist then that means customer is running
3783: --- create APS partition proram for the first time. So we let create_partition_pvt
3784: --- in MSCPRPRB.pls create the patitions
3785: l_table_name := 'MSC_SYSTEM_ITEMS';
3786: l_partition_name := 'SYSTEM_ITEMS' || '_' || MAXVALUE;
3787:
3788: BEGIN
3789: select count(*)

Line 3801: msc_util.msc_log('Count of partition om msc_system_items := ' || l_count);

3797: EXCEPTION
3798: WHEN OTHERS THEN
3799: l_count := 1;
3800: END;
3801: msc_util.msc_log('Count of partition om msc_system_items := ' || l_count);
3802: IF l_count > 0 THEN --- patiton on msc_system items exist
3803:
3804:
3805:

Line 3802: IF l_count > 0 THEN --- patiton on msc_system items exist

3798: WHEN OTHERS THEN
3799: l_count := 1;
3800: END;
3801: msc_util.msc_log('Count of partition om msc_system_items := ' || l_count);
3802: IF l_count > 0 THEN --- patiton on msc_system items exist
3803:
3804:
3805:
3806: For i in 2..atp_summ_tab.COUNT LOOP

Line 3847: msc_util.msc_log(' No partition on msc_system_items exist.');

3843: END IF; -- l_summary_flag <> 0 THEN
3844:
3845: END LOOP; --- For i in 2..atp_summ_tab.COUNT LOOP
3846: ELSE
3847: msc_util.msc_log(' No partition on msc_system_items exist.');
3848: msc_util.msc_log('Partitions will be created by the main program');
3849: END IF; -- if l_count > 0
3850:
3851: ELSE --- IF l_share_partition = 'Y' then

Line 6703: FROM MSC_SYSTEM_ITEMS I,

6699: p_sys_date last_update_date,
6700: l_user_id last_updated_by,
6701: p_sys_date creation_date,
6702: l_user_id created_by
6703: FROM MSC_SYSTEM_ITEMS I,
6704: MSC_TRADING_PARTNERS P,
6705: MSC_DEMANDS D,
6706: MSC_CALENDAR_DATES C
6707: WHERE I.ATP_FLAG = 'Y'

Line 6757: FROM MSC_SYSTEM_ITEMS I,

6753: p_sys_date last_update_date,
6754: l_user_id last_updated_by,
6755: p_sys_date creation_date,
6756: l_user_id created_by
6757: FROM MSC_SYSTEM_ITEMS I,
6758: MSC_TRADING_PARTNERS P,
6759: MSC_SUPPLIES S,
6760: MSC_CALENDAR_DATES C
6761: WHERE I.ATP_FLAG = 'Y'

Line 6842: FROM MSC_SYSTEM_ITEMS I,

6838: p_sys_date last_update_date,
6839: l_user_id last_updated_by,
6840: p_sys_date creation_date,
6841: l_user_id created_by
6842: FROM MSC_SYSTEM_ITEMS I,
6843: MSC_TRADING_PARTNERS P,
6844: MSC_DEMANDS D,
6845: MSC_CALENDAR_DATES C
6846: WHERE I.ATP_FLAG = 'Y'

Line 6894: FROM MSC_SYSTEM_ITEMS I,

6890: p_sys_date last_update_date,
6891: l_user_id last_updated_by,
6892: p_sys_date creation_date,
6893: l_user_id created_by
6894: FROM MSC_SYSTEM_ITEMS I,
6895: MSC_TRADING_PARTNERS P,
6896: MSC_SUPPLIES S,
6897: MSC_CALENDAR_DATES C
6898: WHERE I.ATP_FLAG = 'Y'

Line 7019: FROM MSC_SYSTEM_ITEMS I,

7015: p_sys_date last_update_date,
7016: l_user_id last_updated_by,
7017: p_sys_date creation_date,
7018: l_user_id created_by
7019: FROM MSC_SYSTEM_ITEMS I,
7020: -- MSC_TRADING_PARTNERS P, -- Removed with summary enhancement changes
7021: -- Not required as calendar has been removed
7022: MSC_DEMANDS D
7023: WHERE I.ATP_FLAG = 'Y'

Line 7049: FROM MSC_SYSTEM_ITEMS I,

7045: p_sys_date last_update_date,
7046: l_user_id last_updated_by,
7047: p_sys_date creation_date,
7048: l_user_id created_by
7049: FROM MSC_SYSTEM_ITEMS I,
7050: -- MSC_TRADING_PARTNERS P, -- Removed with summary enhancement changes
7051: -- Not required as calendar has been removed
7052: MSC_SUPPLIES S
7053: WHERE I.ATP_FLAG = 'Y'

Line 7127: FROM MSC_SYSTEM_ITEMS I,

7123: p_sys_date last_update_date,
7124: l_user_id last_updated_by,
7125: p_sys_date creation_date,
7126: l_user_id created_by
7127: FROM MSC_SYSTEM_ITEMS I,
7128: -- MSC_TRADING_PARTNERS P, -- Removed with summary enhancement changes
7129: -- Not required as calendar has been removed
7130: MSC_DEMANDS D
7131: WHERE I.ATP_FLAG = 'Y'

Line 7158: FROM MSC_SYSTEM_ITEMS I,

7154: p_sys_date last_update_date,
7155: l_user_id last_updated_by,
7156: p_sys_date creation_date,
7157: l_user_id created_by
7158: FROM MSC_SYSTEM_ITEMS I,
7159: -- MSC_TRADING_PARTNERS P, -- Removed with summary enhancement changes
7160: -- Not required as calendar has been removed
7161: MSC_SUPPLIES S
7162: WHERE I.ATP_FLAG = 'Y'

Line 7354: FROM MSC_SYSTEM_ITEMS I,

7350: --plan by request date, promise date or schedule date
7351: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies
7352: 0, D.OLD_DEMAND_QUANTITY, -- For summary enhancement
7353: -1 * D.USING_REQUIREMENT_QUANTITY) SD_QTY
7354: FROM MSC_SYSTEM_ITEMS I,
7355: MSC_DEMANDS D
7356: WHERE I.ATP_FLAG = 'Y'
7357: AND I.PLAN_ID = p_plan_id
7358: AND D.PLAN_ID = I.PLAN_ID

Line 7372: FROM MSC_SYSTEM_ITEMS I,

7368: I.organization_id,
7369: I.inventory_item_id,
7370: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
7371: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
7372: FROM MSC_SYSTEM_ITEMS I,
7373: MSC_SUPPLIES S
7374: WHERE I.ATP_FLAG = 'Y'
7375: AND I.PLAN_ID = p_plan_id
7376: AND S.PLAN_ID = I.PLAN_ID

Line 7410: FROM MSC_SYSTEM_ITEMS I,

7406: --plan by request date, promise date or schedule date
7407: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies
7408: 0, D.OLD_DEMAND_QUANTITY, -- For summary enhancement
7409: -1 * D.USING_REQUIREMENT_QUANTITY) SD_QTY
7410: FROM MSC_SYSTEM_ITEMS I,
7411: MSC_DEMANDS D
7412: WHERE I.ATP_FLAG = 'Y'
7413: AND I.PLAN_ID = p_plan_id
7414: AND D.PLAN_ID = I.PLAN_ID

Line 7429: FROM MSC_SYSTEM_ITEMS I,

7425: I.organization_id,
7426: I.inventory_item_id,
7427: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
7428: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
7429: FROM MSC_SYSTEM_ITEMS I,
7430: MSC_SUPPLIES S
7431: WHERE I.ATP_FLAG = 'Y'
7432: AND I.PLAN_ID = p_plan_id
7433: AND S.PLAN_ID = I.PLAN_ID

Line 7808: FROM msc_system_items I,

7804: trunc(S.from_date) from_date,
7805: trunc(S.to_date) to_date,
7806: mis.delivery_calendar_code,
7807: mis.supplier_lead_time_date
7808: FROM msc_system_items I,
7809: msc_supplier_capacities s,
7810: msc_item_suppliers mis -- Bug 3912422 - Move to the inner query
7811: WHERE I.plan_id = p_plan_id
7812: AND I.atp_components_flag in ('Y', 'C')

Line 7883: msc_system_items I

7879: -- msc_trading_partners tp,
7880: -- msc_calendar_dates c,
7881: -- msc_calendar_dates c1,
7882: msc_trading_partner_sites tps,
7883: msc_system_items I
7884: WHERE I.plan_id = p_plan_id
7885: AND I.atp_components_flag in ( 'Y', 'C')
7886: AND (p.order_type IN (5, 2)
7887: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

Line 7968: msc_system_items I

7964: -- msc_trading_partners tp,
7965: -- msc_calendar_dates c,
7966: -- msc_calendar_dates c1,
7967: msc_trading_partner_sites tps,
7968: msc_system_items I
7969: WHERE I.plan_id = p_plan_id
7970: AND I.atp_components_flag in ( 'Y', 'C')
7971: AND (p.order_type IN (5, 2)
7972: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

Line 8176: MSC_SYSTEM_ITEMS I,

8172: DECODE(DR.UOM_CLASS_TYPE,1 , I.WEIGHT_UOM, 2, I.VOLUME_UOM) UOM_CODE
8173: FROM MSC_DEPARTMENT_RESOURCES DR,
8174: MSC_TRADING_PARTNERS P,
8175: MSC_RESOURCE_REQUIREMENTS REQ,
8176: MSC_SYSTEM_ITEMS I,
8177: MSC_SUPPLIES S,
8178: ---- re-ordered tables for performance
8179: MSC_CALENDAR_DATES C
8180: WHERE DR.PLAN_ID = REQ.PLAN_ID

Line 8328: MSC_SYSTEM_ITEMS I,

8324: NVL(DR.BATCHABLE_FLAG,2) BATCHABLE_FLAG,
8325: DECODE(DR.UOM_CLASS_TYPE,1 , I.WEIGHT_UOM, 2, I.VOLUME_UOM) UOM_CODE
8326: FROM MSC_DEPARTMENT_RESOURCES DR,
8327: MSC_RESOURCE_REQUIREMENTS REQ,
8328: MSC_SYSTEM_ITEMS I,
8329: MSC_SUPPLIES S
8330: ---- re-ordered tables for performance
8331: WHERE DR.PLAN_ID = REQ.PLAN_ID
8332: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=REQ.DEPARTMENT_ID

Line 8458: MSC_SYSTEM_ITEMS I, -- summary enhancement change for CTO ODR

8454: l_user_id created_by
8455: FROM MSC_DEPARTMENT_RESOURCES DR,
8456: MSC_TRADING_PARTNERS P,
8457: MSC_RESOURCE_REQUIREMENTS REQ,
8458: MSC_SYSTEM_ITEMS I, -- summary enhancement change for CTO ODR
8459: MSC_CALENDAR_DATES C
8460: ---- re-ordered tables for performance
8461: WHERE DR.PLAN_ID = REQ.PLAN_ID
8462: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=REQ.DEPARTMENT_ID -- summary enhancement - made consistent

Line 8575: MSC_SYSTEM_ITEMS I -- summary enhancement change for CTO ODR

8571: p_sys_date creation_date,
8572: l_user_id created_by
8573: FROM MSC_DEPARTMENT_RESOURCES DR,
8574: MSC_RESOURCE_REQUIREMENTS REQ,
8575: MSC_SYSTEM_ITEMS I -- summary enhancement change for CTO ODR
8576: WHERE DR.PLAN_ID = REQ.PLAN_ID
8577: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=REQ.DEPARTMENT_ID -- summary enhancement: made consistent
8578: AND DR.RESOURCE_ID = REQ.RESOURCE_ID
8579: AND DR.SR_INSTANCE_ID = REQ.SR_INSTANCE_ID

Line 8931: UPDATE msc_system_items mst1

8927: END IF;
8928:
8929: --bug3663487 start
8930: /*
8931: UPDATE msc_system_items mst1
8932: SET (REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG) =(SELECT REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG
8933: FROM msc_system_items mst2
8934: WHERE mst2.sr_instance_id=mst1.sr_instance_id
8935: AND mst2.organization_id=mst1.organization_id

Line 8933: FROM msc_system_items mst2

8929: --bug3663487 start
8930: /*
8931: UPDATE msc_system_items mst1
8932: SET (REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG) =(SELECT REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG
8933: FROM msc_system_items mst2
8934: WHERE mst2.sr_instance_id=mst1.sr_instance_id
8935: AND mst2.organization_id=mst1.organization_id
8936: AND mst2.INVENTORY_ITEM_ID=mst1.INVENTORY_ITEM_ID
8937: AND mst2.plan_id=-1

Line 8943: -- IO Perf:3693983: Moved update of msc_system_items to Load_Plan_SD

8939: WHERE plan_id=p_plan_id;
8940: */
8941: -- ATP_RULE_ID and DEMAND_TIME_FENCE_DAYS is also flushed as we are using it in populate_atf_date
8942: -- to make its performance better.
8943: -- IO Perf:3693983: Moved update of msc_system_items to Load_Plan_SD
8944: /*
8945: FORALL j IN l_organization_id.first.. l_organization_id.last
8946: UPDATE msc_system_items mst1
8947: SET (REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG,ATP_RULE_ID,DEMAND_TIME_FENCE_DAYS) =(SELECT REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG,ATP_RULE_ID,DEMAND_TIME_FENCE_DAYS

Line 8946: UPDATE msc_system_items mst1

8942: -- to make its performance better.
8943: -- IO Perf:3693983: Moved update of msc_system_items to Load_Plan_SD
8944: /*
8945: FORALL j IN l_organization_id.first.. l_organization_id.last
8946: UPDATE msc_system_items mst1
8947: SET (REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG,ATP_RULE_ID,DEMAND_TIME_FENCE_DAYS) =(SELECT REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG,ATP_RULE_ID,DEMAND_TIME_FENCE_DAYS
8948: FROM msc_system_items mst2
8949: WHERE mst2.sr_instance_id=mst1.sr_instance_id
8950: AND mst2.organization_id=mst1.organization_id

Line 8948: FROM msc_system_items mst2

8944: /*
8945: FORALL j IN l_organization_id.first.. l_organization_id.last
8946: UPDATE msc_system_items mst1
8947: SET (REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG,ATP_RULE_ID,DEMAND_TIME_FENCE_DAYS) =(SELECT REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG,ATP_RULE_ID,DEMAND_TIME_FENCE_DAYS
8948: FROM msc_system_items mst2
8949: WHERE mst2.sr_instance_id=mst1.sr_instance_id
8950: AND mst2.organization_id=mst1.organization_id
8951: AND mst2.INVENTORY_ITEM_ID=mst1.INVENTORY_ITEM_ID
8952: AND mst2.plan_id=-1