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 681: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM

677: trunc(nvl(s.firm_date, s.new_schedule_date))),*/
678: NULL, 1,
679: 0)) SD_QTY
680: FROM -- MSC_CALENDAR_DATES C, -- 2859130
681: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
682: WHERE S.PLAN_ID = p_plan_id
683: AND S.SR_INSTANCE_ID = p_instance_id
684: AND S.INVENTORY_ITEM_ID = p_item_id
685: AND S.ORGANIZATION_ID = p_org_id

Line 1086: MSC_SUPPLIES S

1082: S.SHIP_TO_SITE_ID,
1083: S.SR_INSTANCE_ID,
1084: S.ORGANIZATION_ID
1085: FROM MSC_CALENDAR_DATES C,
1086: MSC_SUPPLIES S
1087: WHERE S.PLAN_ID = p_plan_id
1088: AND S.SR_INSTANCE_ID = p_instance_id
1089: AND S.INVENTORY_ITEM_ID = p_item_id
1090: AND S.ORGANIZATION_ID = p_org_id

Line 1621: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM

1617: trunc(nvl(s.firm_date, s.new_schedule_date))),*/
1618: NULL, 1,
1619: 0)) SD_QTY
1620: FROM -- MSC_CALENDAR_DATES C,
1621: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
1622: WHERE S.PLAN_ID = p_plan_id
1623: AND S.SR_INSTANCE_ID = p_instance_id
1624: AND S.INVENTORY_ITEM_ID = p_item_id
1625: AND S.ORGANIZATION_ID = p_org_id

Line 2032: MSC_SUPPLIES S

2028: S.SHIP_TO_SITE_ID,
2029: S.SR_INSTANCE_ID,
2030: S.ORGANIZATION_ID
2031: FROM MSC_CALENDAR_DATES C,
2032: MSC_SUPPLIES S
2033: WHERE S.PLAN_ID = p_plan_id
2034: AND S.SR_INSTANCE_ID = p_instance_id
2035: AND S.INVENTORY_ITEM_ID = p_item_id
2036: AND S.ORGANIZATION_ID = p_org_id

Line 2698: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM

2694: null, --bug3263368 ORIG_CUSTOMER_NAME
2695: null, --bug3263368 ORIG_DEMAND_CLASS
2696: null --bug3263368 ORIG_REQUEST_DATE
2697: FROM -- MSC_CALENDAR_DATES C, -- 2859130
2698: MSC_SUPPLIES S,MSC_ITEM_HIERARCHY_MV MIHM
2699: WHERE S.PLAN_ID = p_plan_id
2700: AND S.SR_INSTANCE_ID = p_instance_id
2701: AND S.INVENTORY_ITEM_ID = p_item_id
2702: AND S.ORGANIZATION_ID = p_org_id

Line 3254: MSC_SUPPLIES S

3250: S.ORGANIZATION_ID,
3251: C.CALENDAR_DATE
3252:
3253: FROM MSC_CALENDAR_DATES C,
3254: MSC_SUPPLIES S
3255: WHERE S.PLAN_ID = p_plan_id
3256: AND S.SR_INSTANCE_ID = p_instance_id
3257: AND S.INVENTORY_ITEM_ID = p_item_id
3258: AND S.ORGANIZATION_ID = p_org_id

Line 6216: MSC_SUPPLIES S,

6212: NULL))),
6213: l_demand_class), 0)) SD_QTY
6214: /*New*/
6215: FROM MSC_DEPARTMENT_RESOURCES DR,
6216: MSC_SUPPLIES S,
6217: MSC_RESOURCE_REQUIREMENTS REQ,
6218: -- 2859130 MSC_CALENDAR_DATES C,
6219: MSC_SYSTEM_ITEMS I,
6220: MSC_UOM_CONVERSIONS MUC

Line 6389: MSC_SUPPLIES S,

6385: NULL))),
6386: l_demand_class), 0)) SD_QTY
6387: /*New*/
6388: FROM MSC_DEPARTMENT_RESOURCES DR,
6389: MSC_SUPPLIES S,
6390: MSC_RESOURCE_REQUIREMENTS REQ,
6391: MSC_CALENDAR_DATES C,
6392: MSC_SYSTEM_ITEMS I,
6393: MSC_UOM_CONVERSIONS MUC

Line 6610: MSC_SUPPLIES S,

6606: NULL))),
6607: l_demand_class), 0)) SD_QTY
6608: /*New*/
6609: FROM MSC_DEPARTMENT_RESOURCES DR,
6610: MSC_SUPPLIES S,
6611: MSC_SYSTEM_ITEMS I, -- CTO ODR
6612: MSC_RESOURCE_REQUIREMENTS REQ
6613: -- 2859130 MSC_CALENDAR_DATES C
6614: WHERE DR.PLAN_ID = p_plan_id

Line 6774: MSC_SUPPLIES S,

6770: NULL))),
6771: l_demand_class), 0)) SD_QTY
6772: /*New*/
6773: FROM MSC_DEPARTMENT_RESOURCES DR,
6774: MSC_SUPPLIES S,
6775: MSC_SYSTEM_ITEMS I, -- CTO ODR
6776: MSC_RESOURCE_REQUIREMENTS REQ,
6777: MSC_CALENDAR_DATES C
6778: WHERE DR.PLAN_ID = p_plan_id

Line 7089: MSC_SUPPLIES S,

7085: ---- resource batching
7086: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
7087: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
7088: FROM MSC_DEPARTMENT_RESOURCES DR,
7089: MSC_SUPPLIES S,
7090: MSC_RESOURCE_REQUIREMENTS REQ,
7091: -- 2859130 MSC_CALENDAR_DATES C,
7092: MSC_SYSTEM_ITEMS I,
7093: MSC_UOM_CONVERSIONS MUC

Line 7380: MSC_SUPPLIES S,

7376: ---- resource batching
7377: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
7378: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
7379: FROM MSC_DEPARTMENT_RESOURCES DR,
7380: MSC_SUPPLIES S,
7381: MSC_RESOURCE_REQUIREMENTS REQ,
7382: MSC_CALENDAR_DATES C,
7383: MSC_SYSTEM_ITEMS I,
7384: MSC_UOM_CONVERSIONS MUC

Line 7716: MSC_SUPPLIES S,

7712: REQ.DAILY_RESOURCE_HOURS)))
7713: -- For ATP created records use resource_hours
7714: -- End Bug 3348095
7715: FROM MSC_DEPARTMENT_RESOURCES DR,
7716: MSC_SUPPLIES S,
7717: MSC_SYSTEM_ITEMS I, -- CTO ODR
7718: MSC_RESOURCE_REQUIREMENTS REQ
7719: -- 2859130 MSC_CALENDAR_DATES C
7720: WHERE DR.PLAN_ID = p_plan_id

Line 7995: MSC_SUPPLIES S,

7991: REQ.DAILY_RESOURCE_HOURS)))
7992: -- For ATP created records use resource_hours
7993: -- End Bug 3348095
7994: FROM MSC_DEPARTMENT_RESOURCES DR,
7995: MSC_SUPPLIES S,
7996: MSC_SYSTEM_ITEMS I, -- CTO ODR
7997: MSC_RESOURCE_REQUIREMENTS REQ,
7998: MSC_CALENDAR_DATES C
7999: WHERE DR.PLAN_ID = p_plan_id

Line 9108: FROM msc_supplies p,msc_item_hierarchy_mv MIHM

9104: ))),*/
9105: NULL, 1,
9106: 0)) quantity
9107: -- Supplier Capacity (SCLT) Changes Begin
9108: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
9109: WHERE (p.order_type IN (5, 2)
9110: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = trunc(MSC_ATP_REQ.G_PROMISE_DATE) --4135752
9111: AND p.order_type = 1 AND p.promised_date IS NULL))
9112: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders

Line 9269: FROM msc_supplies p,msc_item_hierarchy_mv MIHM

9265: ))), */
9266: NULL, 1,
9267: 0)) quantity
9268: -- Supplier Capacity (SCLT) Changes Begin
9269: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
9270: WHERE (p.order_type IN (5, 2)
9271: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9272: AND p.order_type = 1 AND p.promised_date IS NULL))
9273: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders

Line 9552: FROM msc_supplies p,msc_item_hierarchy_mv MIHM

9548: -- Unallocated_Quantity
9549: -- ship_rec_cal rearrange signs to get rid of multiply times -1
9550: (NVL(p.implement_quantity,0) - p.new_order_quantity)
9551: -- Supplier Capacity (SCLT) Changes Begin
9552: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
9553: WHERE (p.order_type IN (5, 2)
9554: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9555: AND p.order_type = 1 AND p.promised_date IS NULL))
9556:

Line 9835: FROM msc_supplies p ,msc_item_hierarchy_mv MIHM

9831: -- Unallocated_Quantity
9832: -- ship_rec_cal rearrange signs to get rid of multiply times -1
9833: (NVL(p.implement_quantity,0) - p.new_order_quantity)
9834: -- Supplier Capacity (SCLT) Changes Begin
9835: FROM msc_supplies p ,msc_item_hierarchy_mv MIHM
9836: WHERE (p.order_type IN (5, 2)
9837: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9838: AND p.order_type = 1 AND p.promised_date IS NULL))
9839: