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 6732: FROM MSC_SYSTEM_ITEMS I,

6728: p_sys_date last_update_date,
6729: l_user_id last_updated_by,
6730: p_sys_date creation_date,
6731: l_user_id created_by
6732: FROM MSC_SYSTEM_ITEMS I,
6733: MSC_TRADING_PARTNERS P,
6734: MSC_DEMANDS D,
6735: MSC_CALENDAR_DATES C
6736: WHERE I.ATP_FLAG = 'Y'

Line 6786: FROM MSC_SYSTEM_ITEMS I,

6782: p_sys_date last_update_date,
6783: l_user_id last_updated_by,
6784: p_sys_date creation_date,
6785: l_user_id created_by
6786: FROM MSC_SYSTEM_ITEMS I,
6787: MSC_TRADING_PARTNERS P,
6788: MSC_SUPPLIES S,
6789: MSC_CALENDAR_DATES C
6790: WHERE I.ATP_FLAG = 'Y'

Line 6871: FROM MSC_SYSTEM_ITEMS I,

6867: p_sys_date last_update_date,
6868: l_user_id last_updated_by,
6869: p_sys_date creation_date,
6870: l_user_id created_by
6871: FROM MSC_SYSTEM_ITEMS I,
6872: MSC_TRADING_PARTNERS P,
6873: MSC_DEMANDS D,
6874: MSC_CALENDAR_DATES C
6875: WHERE I.ATP_FLAG = 'Y'

Line 6923: FROM MSC_SYSTEM_ITEMS I,

6919: p_sys_date last_update_date,
6920: l_user_id last_updated_by,
6921: p_sys_date creation_date,
6922: l_user_id created_by
6923: FROM MSC_SYSTEM_ITEMS I,
6924: MSC_TRADING_PARTNERS P,
6925: MSC_SUPPLIES S,
6926: MSC_CALENDAR_DATES C
6927: WHERE I.ATP_FLAG = 'Y'

Line 7048: FROM MSC_SYSTEM_ITEMS I,

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

Line 7078: FROM MSC_SYSTEM_ITEMS I,

7074: p_sys_date last_update_date,
7075: l_user_id last_updated_by,
7076: p_sys_date creation_date,
7077: l_user_id created_by
7078: FROM MSC_SYSTEM_ITEMS I,
7079: -- MSC_TRADING_PARTNERS P, -- Removed with summary enhancement changes
7080: -- Not required as calendar has been removed
7081: MSC_SUPPLIES S
7082: WHERE I.ATP_FLAG = 'Y'

Line 7156: FROM MSC_SYSTEM_ITEMS I,

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

Line 7187: FROM MSC_SYSTEM_ITEMS I,

7183: p_sys_date last_update_date,
7184: l_user_id last_updated_by,
7185: p_sys_date creation_date,
7186: l_user_id created_by
7187: FROM MSC_SYSTEM_ITEMS I,
7188: -- MSC_TRADING_PARTNERS P, -- Removed with summary enhancement changes
7189: -- Not required as calendar has been removed
7190: MSC_SUPPLIES S
7191: WHERE I.ATP_FLAG = 'Y'

Line 7383: FROM MSC_SYSTEM_ITEMS I,

7379: --plan by request date, promise date or schedule date
7380: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies
7381: 0, D.OLD_DEMAND_QUANTITY, -- For summary enhancement
7382: -1 * D.USING_REQUIREMENT_QUANTITY) SD_QTY
7383: FROM MSC_SYSTEM_ITEMS I,
7384: MSC_DEMANDS D
7385: WHERE I.ATP_FLAG = 'Y'
7386: AND I.PLAN_ID = p_plan_id
7387: AND D.PLAN_ID = I.PLAN_ID

Line 7401: FROM MSC_SYSTEM_ITEMS I,

7397: I.organization_id,
7398: I.inventory_item_id,
7399: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
7400: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
7401: FROM MSC_SYSTEM_ITEMS I,
7402: MSC_SUPPLIES S
7403: WHERE I.ATP_FLAG = 'Y'
7404: AND I.PLAN_ID = p_plan_id
7405: AND S.PLAN_ID = I.PLAN_ID

Line 7439: FROM MSC_SYSTEM_ITEMS I,

7435: --plan by request date, promise date or schedule date
7436: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies
7437: 0, D.OLD_DEMAND_QUANTITY, -- For summary enhancement
7438: -1 * D.USING_REQUIREMENT_QUANTITY) SD_QTY
7439: FROM MSC_SYSTEM_ITEMS I,
7440: MSC_DEMANDS D
7441: WHERE I.ATP_FLAG = 'Y'
7442: AND I.PLAN_ID = p_plan_id
7443: AND D.PLAN_ID = I.PLAN_ID

Line 7458: FROM MSC_SYSTEM_ITEMS I,

7454: I.organization_id,
7455: I.inventory_item_id,
7456: TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
7457: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
7458: FROM MSC_SYSTEM_ITEMS I,
7459: MSC_SUPPLIES S
7460: WHERE I.ATP_FLAG = 'Y'
7461: AND I.PLAN_ID = p_plan_id
7462: AND S.PLAN_ID = I.PLAN_ID

Line 7837: FROM msc_system_items I,

7833: trunc(S.from_date) from_date,
7834: trunc(S.to_date) to_date,
7835: mis.delivery_calendar_code,
7836: mis.supplier_lead_time_date
7837: FROM msc_system_items I,
7838: msc_supplier_capacities s,
7839: msc_item_suppliers mis -- Bug 3912422 - Move to the inner query
7840: WHERE I.plan_id = p_plan_id
7841: AND I.atp_components_flag in ('Y', 'C')

Line 7912: msc_system_items I

7908: -- msc_trading_partners tp,
7909: -- msc_calendar_dates c,
7910: -- msc_calendar_dates c1,
7911: msc_trading_partner_sites tps,
7912: msc_system_items I
7913: WHERE I.plan_id = p_plan_id
7914: AND I.atp_components_flag in ( 'Y', 'C')
7915: AND (p.order_type IN (5, 2)
7916: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

Line 7997: msc_system_items I

7993: -- msc_trading_partners tp,
7994: -- msc_calendar_dates c,
7995: -- msc_calendar_dates c1,
7996: msc_trading_partner_sites tps,
7997: msc_system_items I
7998: WHERE I.plan_id = p_plan_id
7999: AND I.atp_components_flag in ( 'Y', 'C')
8000: AND (p.order_type IN (5, 2)
8001: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

Line 8205: MSC_SYSTEM_ITEMS I,

8201: DECODE(DR.UOM_CLASS_TYPE,1 , I.WEIGHT_UOM, 2, I.VOLUME_UOM) UOM_CODE
8202: FROM MSC_DEPARTMENT_RESOURCES DR,
8203: MSC_TRADING_PARTNERS P,
8204: MSC_RESOURCE_REQUIREMENTS REQ,
8205: MSC_SYSTEM_ITEMS I,
8206: MSC_SUPPLIES S,
8207: ---- re-ordered tables for performance
8208: MSC_CALENDAR_DATES C
8209: WHERE DR.PLAN_ID = REQ.PLAN_ID

Line 8357: MSC_SYSTEM_ITEMS I,

8353: NVL(DR.BATCHABLE_FLAG,2) BATCHABLE_FLAG,
8354: DECODE(DR.UOM_CLASS_TYPE,1 , I.WEIGHT_UOM, 2, I.VOLUME_UOM) UOM_CODE
8355: FROM MSC_DEPARTMENT_RESOURCES DR,
8356: MSC_RESOURCE_REQUIREMENTS REQ,
8357: MSC_SYSTEM_ITEMS I,
8358: MSC_SUPPLIES S
8359: ---- re-ordered tables for performance
8360: WHERE DR.PLAN_ID = REQ.PLAN_ID
8361: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=REQ.DEPARTMENT_ID

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

8483: l_user_id created_by
8484: FROM MSC_DEPARTMENT_RESOURCES DR,
8485: MSC_TRADING_PARTNERS P,
8486: MSC_RESOURCE_REQUIREMENTS REQ,
8487: MSC_SYSTEM_ITEMS I, -- summary enhancement change for CTO ODR
8488: MSC_CALENDAR_DATES C
8489: ---- re-ordered tables for performance
8490: WHERE DR.PLAN_ID = REQ.PLAN_ID
8491: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=REQ.DEPARTMENT_ID -- summary enhancement - made consistent

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

8600: p_sys_date creation_date,
8601: l_user_id created_by
8602: FROM MSC_DEPARTMENT_RESOURCES DR,
8603: MSC_RESOURCE_REQUIREMENTS REQ,
8604: MSC_SYSTEM_ITEMS I -- summary enhancement change for CTO ODR
8605: WHERE DR.PLAN_ID = REQ.PLAN_ID
8606: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=REQ.DEPARTMENT_ID -- summary enhancement: made consistent
8607: AND DR.RESOURCE_ID = REQ.RESOURCE_ID
8608: AND DR.SR_INSTANCE_ID = REQ.SR_INSTANCE_ID

Line 8969: UPDATE msc_system_items mst1

8965: END IF;
8966:
8967: --bug3663487 start
8968: /*
8969: UPDATE msc_system_items mst1
8970: SET (REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG) =(SELECT REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG
8971: FROM msc_system_items mst2
8972: WHERE mst2.sr_instance_id=mst1.sr_instance_id
8973: AND mst2.organization_id=mst1.organization_id

Line 8971: FROM msc_system_items mst2

8967: --bug3663487 start
8968: /*
8969: UPDATE msc_system_items mst1
8970: SET (REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG) =(SELECT REPLENISH_TO_ORDER_FLAG,PICK_COMPONENTS_FLAG
8971: FROM msc_system_items mst2
8972: WHERE mst2.sr_instance_id=mst1.sr_instance_id
8973: AND mst2.organization_id=mst1.organization_id
8974: AND mst2.INVENTORY_ITEM_ID=mst1.INVENTORY_ITEM_ID
8975: AND mst2.plan_id=-1

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

8977: WHERE plan_id=p_plan_id;
8978: */
8979: -- ATP_RULE_ID and DEMAND_TIME_FENCE_DAYS is also flushed as we are using it in populate_atf_date
8980: -- to make its performance better.
8981: -- IO Perf:3693983: Moved update of msc_system_items to Load_Plan_SD
8982: /*
8983: FORALL j IN l_organization_id.first.. l_organization_id.last
8984: UPDATE msc_system_items mst1
8985: 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 8984: UPDATE msc_system_items mst1

8980: -- to make its performance better.
8981: -- IO Perf:3693983: Moved update of msc_system_items to Load_Plan_SD
8982: /*
8983: FORALL j IN l_organization_id.first.. l_organization_id.last
8984: UPDATE msc_system_items mst1
8985: 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
8986: FROM msc_system_items mst2
8987: WHERE mst2.sr_instance_id=mst1.sr_instance_id
8988: AND mst2.organization_id=mst1.organization_id

Line 8986: FROM msc_system_items mst2

8982: /*
8983: FORALL j IN l_organization_id.first.. l_organization_id.last
8984: UPDATE msc_system_items mst1
8985: 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
8986: FROM msc_system_items mst2
8987: WHERE mst2.sr_instance_id=mst1.sr_instance_id
8988: AND mst2.organization_id=mst1.organization_id
8989: AND mst2.INVENTORY_ITEM_ID=mst1.INVENTORY_ITEM_ID
8990: AND mst2.plan_id=-1