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_SUPPLIES

Line 437: MSC_SUPPLIES S,

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,
440: MSC_CALENDAR_DATES C2,
441: MSC_TRADING_PARTNERS TP

Line 1493: FROM msc_supplies

1489:
1490: UNION ALL
1491:
1492: SELECT refresh_number
1493: FROM msc_supplies
1494: WHERE plan_id = p_plan_id
1495:
1496: UNION ALL
1497:

Line 3006: MSC_SUPPLIES S,

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
3010:

Line 3012: MSC_SUPPLIES S,

3008: MSC_SUB_INVENTORIES MSI,
3009: MSC_CALENDAR_DATES C
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,

Line 3113: MSC_SUPPLIES S,

3109: NVL(S.OLD_qty_completed,0), NVL(S.OLD_Daily_rate,0)),
3110: NVL( NVL(S.OLD_FIRM_QUANTITY,S.OLD_NEW_ORDER_QUANTITY),0) ) SD_QTY
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*/

Line 3122: MSC_SUPPLIES S,

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
3126:

Line 4576: msc_supplies s

4572: d.request_ship_date)request_date --bug3263368
4573: FROM msc_full_pegging peg2,
4574: msc_full_pegging peg1,
4575: msc_demands d,
4576: msc_supplies s
4577: WHERE peg1.plan_id = :p_plan_id
4578: AND peg2.plan_id = peg1.plan_id
4579: AND peg2.pegging_id = peg1.end_pegging_id
4580: AND peg2.demand_id IN (-1, -2)

Line 4804: FROM msc_supplies s,

4800: s.order_number,
4801: s.schedule_designator_id ,
4802: nvl(s.firm_quantity,s.new_order_quantity) supply_quantity -- rajjain 02/06/2003 Bug 2782882
4803: --peg2.supply_quantity -- ssurendr 25-NOV-2002: added for alloc w/b
4804: FROM msc_supplies s,
4805: msc_full_pegging peg2,
4806: msc_full_pegging peg1,
4807: msc_demands d
4808: -- time_phased_atp msc_trading_partners tp

Line 4942: msc_supplies s

4938: s.schedule_designator_id,
4939: nvl(s.firm_quantity,s.new_order_quantity) supply_quantity
4940: FROM msc_full_pegging peg2,
4941: msc_full_pegging peg1,
4942: msc_supplies s
4943: WHERE peg1.plan_id = :p_plan_id
4944: AND peg2.plan_id = peg1.plan_id
4945: AND peg2.pegging_id = peg1.end_pegging_id
4946: AND peg2.demand_id IN (-1, -2)

Line 5019: msc_supplies s

5015: -- min is used to select distinct values as supply_quantity would be
5016: -- repeating for the same transaction_id
5017: FROM msc_full_pegging peg2,
5018: msc_full_pegging peg1,
5019: msc_supplies s
5020: -- time_phased_atp msc_trading_partners tp
5021: -- 2859130 msc_calendar_dates cal
5022: WHERE peg1.plan_id = :p_plan_id
5023: AND peg2.plan_id = peg1.plan_id

Line 5432: msc_supplies s

5428: d.request_ship_date) request_date -- Bug 3370201
5429: FROM msc_full_pegging peg2,
5430: msc_full_pegging peg1,
5431: msc_demands d,
5432: msc_supplies s
5433: WHERE peg1.plan_id = :p_plan_id
5434: AND peg2.plan_id = peg1.plan_id
5435: AND peg2.pegging_id = peg1.end_pegging_id
5436: AND peg2.demand_id IN (-1, -2)

Line 5801: FROM msc_supplies s,

5797: s.order_number,
5798: s.schedule_designator_id,
5799: nvl(s.firm_quantity,s.new_order_quantity) supply_quantity -- rajjain 02/06/2003 Bug 2782882
5800: --peg2.supply_quantity -- ssurendr 25-NOV-2002: added for alloc w/b
5801: FROM msc_supplies s,
5802: msc_full_pegging peg2,
5803: msc_full_pegging peg1,
5804: msc_demands d
5805: -- time_phased_atp msc_trading_partners tp

Line 5937: msc_supplies s

5933: s.schedule_designator_id,
5934: nvl(s.firm_quantity,s.new_order_quantity) supply_quantity
5935: FROM msc_full_pegging peg2,
5936: msc_full_pegging peg1,
5937: msc_supplies s
5938: WHERE peg1.plan_id = :p_plan_id
5939: AND peg2.plan_id = peg1.plan_id
5940: AND peg2.pegging_id = peg1.end_pegging_id
5941: AND peg2.demand_id IN (-1, -2)

Line 6016: msc_supplies s

6012: -- min is used to select distinct values as supply_quantity would be
6013: -- repeating for the same transaction_id
6014: FROM msc_full_pegging peg2,
6015: msc_full_pegging peg1,
6016: msc_supplies s
6017: -- msc_trading_partners tp
6018: -- msc_calendar_dates cal
6019: WHERE peg1.plan_id = :p_plan_id
6020: AND peg2.plan_id = peg1.plan_id

Line 6759: MSC_SUPPLIES S,

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'
6762: AND I.PLAN_ID = p_plan_id
6763: AND S.PLAN_ID = I.PLAN_ID

Line 6896: MSC_SUPPLIES S,

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'
6899: AND I.PLAN_ID = p_plan_id
6900: AND S.PLAN_ID = I.PLAN_ID

Line 7052: MSC_SUPPLIES S

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'
7054: AND I.PLAN_ID = p_plan_id
7055: AND S.PLAN_ID = I.PLAN_ID
7056: AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID

Line 7161: MSC_SUPPLIES S

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'
7163: AND I.PLAN_ID = p_plan_id
7164: AND S.PLAN_ID = I.PLAN_ID
7165: AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID

Line 7373: MSC_SUPPLIES S

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
7377: AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID

Line 7430: MSC_SUPPLIES S

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
7434: AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID

Line 7878: FROM msc_supplies p,

7874: p_sys_date last_update_date,
7875: l_user_id last_updated_by,
7876: p_sys_date creation_date,
7877: l_user_id created_by
7878: FROM msc_supplies p,
7879: -- msc_trading_partners tp,
7880: -- msc_calendar_dates c,
7881: -- msc_calendar_dates c1,
7882: msc_trading_partner_sites tps,

Line 7963: FROM msc_supplies p,

7959: P.supplier_id,
7960: P.supplier_site_id,
7961: DECODE(tps.shipping_control,'BUYER',p.new_ship_date,p.new_dock_date),
7962: sum(NVL(p.implement_quantity,0) - p.new_order_quantity) sd_qty
7963: FROM msc_supplies p,
7964: -- msc_trading_partners tp,
7965: -- msc_calendar_dates c,
7966: -- msc_calendar_dates c1,
7967: msc_trading_partner_sites tps,

Line 8177: MSC_SUPPLIES S,

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
8181: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=REQ.DEPARTMENT_ID

Line 8329: MSC_SUPPLIES S

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
8333: AND DR.RESOURCE_ID = REQ.RESOURCE_ID