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.

[Home] [Help]

APPS.MSC_AATP_PVT dependencies on MSC_DEPARTMENT_RESOURCES

Line 5985: FROM MSC_DEPARTMENT_RESOURCES DR,

5981: l_level_id,
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,

Line 6158: FROM MSC_DEPARTMENT_RESOURCES DR,

6154: l_level_id,
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,

Line 6379: FROM MSC_DEPARTMENT_RESOURCES DR,

6375: l_level_id,
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

Line 6543: FROM MSC_DEPARTMENT_RESOURCES DR,

6539: l_level_id,
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

Line 6858: FROM MSC_DEPARTMENT_RESOURCES DR,

6854: -- End Bug 3348095
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,

Line 7149: FROM MSC_DEPARTMENT_RESOURCES DR,

7145: -- End Bug 3348095
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,

Line 7485: FROM MSC_DEPARTMENT_RESOURCES DR,

7481: DECODE(REQ.record_source, 2, REQ.RESOURCE_HOURS,
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

Line 7764: FROM MSC_DEPARTMENT_RESOURCES DR,

7760: DECODE(REQ.record_source, 2, REQ.RESOURCE_HOURS,
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

Line 10636: FROM msc_department_resources mdr,

10632:
10633: BEGIN
10634: SELECT min(mdr.plan_id) as plan_id
10635: INTO l_plan_id
10636: FROM msc_department_resources mdr,
10637: msc_trading_partners tp,
10638: msc_apps_instances ins,
10639: msc_plans plans,
10640: msc_designators desig

Line 10687: FROM msc_department_resources

10683: --resource bacting: find out if resource is batchable or not and the max capacity
10684: BEGIN
10685: SELECT batchable_flag, max_capacity, unit_of_measure, uom_class_type
10686: INTO l_batchable_flag, l_max_capacity, l_res_uom, l_res_uom_type
10687: FROM msc_department_resources
10688: WHERE department_id = p_department_id
10689: AND resource_id = p_resource_id
10690: AND organization_id = p_organization_id
10691: AND plan_id = l_plan_id