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_AATP_PVT dependencies on MSC_SUPPLIES

Line 618: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM

614: trunc(nvl(s.firm_date, s.new_schedule_date))),*/
615: NULL, 1,
616: 0)) SD_QTY
617: FROM -- MSC_CALENDAR_DATES C, -- 2859130
618: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
619: WHERE S.PLAN_ID = p_plan_id
620: AND S.SR_INSTANCE_ID = p_instance_id
621: AND S.INVENTORY_ITEM_ID = p_item_id
622: AND S.ORGANIZATION_ID = p_org_id

Line 997: MSC_SUPPLIES S

993: S.SHIP_TO_SITE_ID,
994: S.SR_INSTANCE_ID,
995: S.ORGANIZATION_ID
996: FROM MSC_CALENDAR_DATES C,
997: MSC_SUPPLIES S
998: WHERE S.PLAN_ID = p_plan_id
999: AND S.SR_INSTANCE_ID = p_instance_id
1000: AND S.INVENTORY_ITEM_ID = p_item_id
1001: AND S.ORGANIZATION_ID = p_org_id

Line 1490: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM

1486: trunc(nvl(s.firm_date, s.new_schedule_date))),*/
1487: NULL, 1,
1488: 0)) SD_QTY
1489: FROM -- MSC_CALENDAR_DATES C,
1490: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
1491: WHERE S.PLAN_ID = p_plan_id
1492: AND S.SR_INSTANCE_ID = p_instance_id
1493: AND S.INVENTORY_ITEM_ID = p_item_id
1494: AND S.ORGANIZATION_ID = p_org_id

Line 1876: MSC_SUPPLIES S

1872: S.SHIP_TO_SITE_ID,
1873: S.SR_INSTANCE_ID,
1874: S.ORGANIZATION_ID
1875: FROM MSC_CALENDAR_DATES C,
1876: MSC_SUPPLIES S
1877: WHERE S.PLAN_ID = p_plan_id
1878: AND S.SR_INSTANCE_ID = p_instance_id
1879: AND S.INVENTORY_ITEM_ID = p_item_id
1880: AND S.ORGANIZATION_ID = p_org_id

Line 2500: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM

2496: null, --bug3263368 ORIG_CUSTOMER_NAME
2497: null, --bug3263368 ORIG_DEMAND_CLASS
2498: null --bug3263368 ORIG_REQUEST_DATE
2499: FROM -- MSC_CALENDAR_DATES C, -- 2859130
2500: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
2501: WHERE S.PLAN_ID = p_plan_id
2502: AND S.SR_INSTANCE_ID = p_instance_id
2503: AND S.INVENTORY_ITEM_ID = p_item_id
2504: AND S.ORGANIZATION_ID = p_org_id

Line 3030: MSC_SUPPLIES S

3026: S.ORGANIZATION_ID,
3027: C.CALENDAR_DATE
3028:
3029: FROM MSC_CALENDAR_DATES C,
3030: MSC_SUPPLIES S
3031: WHERE S.PLAN_ID = p_plan_id
3032: AND S.SR_INSTANCE_ID = p_instance_id
3033: AND S.INVENTORY_ITEM_ID = p_item_id
3034: AND S.ORGANIZATION_ID = p_org_id

Line 5986: MSC_SUPPLIES S,

5982: NULL))),
5983: l_demand_class), 0)) SD_QTY
5984: /*New*/
5985: FROM MSC_DEPARTMENT_RESOURCES DR,
5986: MSC_SUPPLIES S,
5987: MSC_RESOURCE_REQUIREMENTS REQ,
5988: -- 2859130 MSC_CALENDAR_DATES C,
5989: MSC_SYSTEM_ITEMS I,
5990: MSC_UOM_CONVERSIONS MUC

Line 6159: MSC_SUPPLIES S,

6155: NULL))),
6156: l_demand_class), 0)) SD_QTY
6157: /*New*/
6158: FROM MSC_DEPARTMENT_RESOURCES DR,
6159: MSC_SUPPLIES S,
6160: MSC_RESOURCE_REQUIREMENTS REQ,
6161: MSC_CALENDAR_DATES C,
6162: MSC_SYSTEM_ITEMS I,
6163: MSC_UOM_CONVERSIONS MUC

Line 6380: MSC_SUPPLIES S,

6376: NULL))),
6377: l_demand_class), 0)) SD_QTY
6378: /*New*/
6379: FROM MSC_DEPARTMENT_RESOURCES DR,
6380: MSC_SUPPLIES S,
6381: MSC_SYSTEM_ITEMS I, -- CTO ODR
6382: MSC_RESOURCE_REQUIREMENTS REQ
6383: -- 2859130 MSC_CALENDAR_DATES C
6384: WHERE DR.PLAN_ID = p_plan_id

Line 6544: MSC_SUPPLIES S,

6540: NULL))),
6541: l_demand_class), 0)) SD_QTY
6542: /*New*/
6543: FROM MSC_DEPARTMENT_RESOURCES DR,
6544: MSC_SUPPLIES S,
6545: MSC_SYSTEM_ITEMS I, -- CTO ODR
6546: MSC_RESOURCE_REQUIREMENTS REQ,
6547: MSC_CALENDAR_DATES C
6548: WHERE DR.PLAN_ID = p_plan_id

Line 6859: MSC_SUPPLIES S,

6855: ---- resource batching
6856: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
6857: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
6858: FROM MSC_DEPARTMENT_RESOURCES DR,
6859: MSC_SUPPLIES S,
6860: MSC_RESOURCE_REQUIREMENTS REQ,
6861: -- 2859130 MSC_CALENDAR_DATES C,
6862: MSC_SYSTEM_ITEMS I,
6863: MSC_UOM_CONVERSIONS MUC

Line 7150: MSC_SUPPLIES S,

7146: ---- resource batching
7147: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
7148: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
7149: FROM MSC_DEPARTMENT_RESOURCES DR,
7150: MSC_SUPPLIES S,
7151: MSC_RESOURCE_REQUIREMENTS REQ,
7152: MSC_CALENDAR_DATES C,
7153: MSC_SYSTEM_ITEMS I,
7154: MSC_UOM_CONVERSIONS MUC

Line 7486: MSC_SUPPLIES S,

7482: REQ.DAILY_RESOURCE_HOURS)))
7483: -- For ATP created records use resource_hours
7484: -- End Bug 3348095
7485: FROM MSC_DEPARTMENT_RESOURCES DR,
7486: MSC_SUPPLIES S,
7487: MSC_SYSTEM_ITEMS I, -- CTO ODR
7488: MSC_RESOURCE_REQUIREMENTS REQ
7489: -- 2859130 MSC_CALENDAR_DATES C
7490: WHERE DR.PLAN_ID = p_plan_id

Line 7765: MSC_SUPPLIES S,

7761: REQ.DAILY_RESOURCE_HOURS)))
7762: -- For ATP created records use resource_hours
7763: -- End Bug 3348095
7764: FROM MSC_DEPARTMENT_RESOURCES DR,
7765: MSC_SUPPLIES S,
7766: MSC_SYSTEM_ITEMS I, -- CTO ODR
7767: MSC_RESOURCE_REQUIREMENTS REQ,
7768: MSC_CALENDAR_DATES C
7769: WHERE DR.PLAN_ID = p_plan_id

Line 8877: FROM msc_supplies p,msc_item_hierarchy_mv MIHM

8873: ))),*/
8874: NULL, 1,
8875: 0)) quantity
8876: -- Supplier Capacity (SCLT) Changes Begin
8877: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
8878: WHERE (p.order_type IN (5, 2)
8879: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = trunc(MSC_ATP_REQ.G_PROMISE_DATE) --4135752
8880: AND p.order_type = 1 AND p.promised_date IS NULL))
8881: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders

Line 9038: FROM msc_supplies p,msc_item_hierarchy_mv MIHM

9034: ))), */
9035: NULL, 1,
9036: 0)) quantity
9037: -- Supplier Capacity (SCLT) Changes Begin
9038: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
9039: WHERE (p.order_type IN (5, 2)
9040: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9041: AND p.order_type = 1 AND p.promised_date IS NULL))
9042: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders

Line 9321: FROM msc_supplies p,msc_item_hierarchy_mv MIHM

9317: -- Unallocated_Quantity
9318: -- ship_rec_cal rearrange signs to get rid of multiply times -1
9319: (NVL(p.implement_quantity,0) - p.new_order_quantity)
9320: -- Supplier Capacity (SCLT) Changes Begin
9321: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
9322: WHERE (p.order_type IN (5, 2)
9323: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9324: AND p.order_type = 1 AND p.promised_date IS NULL))
9325:

Line 9604: FROM msc_supplies p ,msc_item_hierarchy_mv MIHM

9600: -- Unallocated_Quantity
9601: -- ship_rec_cal rearrange signs to get rid of multiply times -1
9602: (NVL(p.implement_quantity,0) - p.new_order_quantity)
9603: -- Supplier Capacity (SCLT) Changes Begin
9604: FROM msc_supplies p ,msc_item_hierarchy_mv MIHM
9605: WHERE (p.order_type IN (5, 2)
9606: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9607: AND p.order_type = 1 AND p.promised_date IS NULL))
9608: