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_DEPARTMENT_RESOURCES

Line 6215: FROM MSC_DEPARTMENT_RESOURCES DR,

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

Line 6388: FROM MSC_DEPARTMENT_RESOURCES DR,

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

Line 6609: FROM MSC_DEPARTMENT_RESOURCES DR,

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

Line 6773: FROM MSC_DEPARTMENT_RESOURCES DR,

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

Line 7088: FROM MSC_DEPARTMENT_RESOURCES DR,

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

Line 7379: FROM MSC_DEPARTMENT_RESOURCES DR,

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

Line 7715: FROM MSC_DEPARTMENT_RESOURCES DR,

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

Line 7994: FROM MSC_DEPARTMENT_RESOURCES DR,

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

Line 10867: FROM msc_department_resources mdr,

10863:
10864: BEGIN
10865: SELECT min(mdr.plan_id) as plan_id
10866: INTO l_plan_id
10867: FROM msc_department_resources mdr,
10868: msc_trading_partners tp,
10869: msc_apps_instances ins,
10870: msc_plans plans,
10871: msc_designators desig

Line 10918: FROM msc_department_resources

10914: --resource bacting: find out if resource is batchable or not and the max capacity
10915: BEGIN
10916: SELECT batchable_flag, max_capacity, unit_of_measure, uom_class_type
10917: INTO l_batchable_flag, l_max_capacity, l_res_uom, l_res_uom_type
10918: FROM msc_department_resources
10919: WHERE department_id = p_department_id
10920: AND resource_id = p_resource_id
10921: AND organization_id = p_organization_id
10922: AND plan_id = l_plan_id