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 6788: MSC_SUPPLIES S,

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

Line 6925: MSC_SUPPLIES S,

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

Line 7081: MSC_SUPPLIES S

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'
7083: AND I.PLAN_ID = p_plan_id
7084: AND S.PLAN_ID = I.PLAN_ID
7085: AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID

Line 7190: MSC_SUPPLIES S

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'
7192: AND I.PLAN_ID = p_plan_id
7193: AND S.PLAN_ID = I.PLAN_ID
7194: AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID

Line 7402: MSC_SUPPLIES S

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

Line 7459: MSC_SUPPLIES S

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

Line 7907: FROM msc_supplies p,

7903: p_sys_date last_update_date,
7904: l_user_id last_updated_by,
7905: p_sys_date creation_date,
7906: l_user_id created_by
7907: FROM msc_supplies p,
7908: -- msc_trading_partners tp,
7909: -- msc_calendar_dates c,
7910: -- msc_calendar_dates c1,
7911: msc_trading_partner_sites tps,

Line 7992: FROM msc_supplies p,

7988: P.supplier_id,
7989: P.supplier_site_id,
7990: DECODE(tps.shipping_control,'BUYER',p.new_ship_date,p.new_dock_date),
7991: sum(NVL(p.implement_quantity,0) - p.new_order_quantity) sd_qty
7992: FROM msc_supplies p,
7993: -- msc_trading_partners tp,
7994: -- msc_calendar_dates c,
7995: -- msc_calendar_dates c1,
7996: msc_trading_partner_sites tps,

Line 8206: MSC_SUPPLIES S,

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

Line 8358: MSC_SUPPLIES S

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