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_DEPARTMENT_RESOURCES

Line 8202: FROM MSC_DEPARTMENT_RESOURCES DR,

8198: (DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, I.UNIT_VOLUME) *
8199: NVL(S.NEW_ORDER_QUANTITY, S.FIRM_QUANTITY)), 1) SD_QTY,
8200: NVL(DR.BATCHABLE_FLAG,2) BATCHABLE_FLAG,
8201: DECODE(DR.UOM_CLASS_TYPE,1 , I.WEIGHT_UOM, 2, I.VOLUME_UOM) UOM_CODE
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,

Line 8263: MSC_DEPARTMENT_RESOURCES DR,

8259: l_user_id last_updated_by,
8260: p_sys_date creation_date,
8261: l_user_id created_by
8262: FROM MSC_NET_RESOURCE_AVAIL MNRA,
8263: MSC_DEPARTMENT_RESOURCES DR,
8264: MSC_UOM_CONVERSIONS MUC -- noted in summary enhancement : inconsistent with MSCRATPB
8265: WHERE MNRA.PLAN_ID = p_plan_id
8266: AND NVL(MNRA.PARENT_ID, -2) <> -1
8267: AND DR.PLAN_ID = MNRA.PLAN_ID

Line 8355: FROM MSC_DEPARTMENT_RESOURCES DR,

8351: (DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, I.UNIT_VOLUME) *
8352: NVL(S.NEW_ORDER_QUANTITY, S.FIRM_QUANTITY)), 1) SD_QTY,
8353: NVL(DR.BATCHABLE_FLAG,2) BATCHABLE_FLAG,
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

Line 8406: MSC_DEPARTMENT_RESOURCES DR,

8402: l_user_id last_updated_by,
8403: p_sys_date creation_date,
8404: l_user_id created_by
8405: FROM MSC_NET_RESOURCE_AVAIL MNRA,
8406: MSC_DEPARTMENT_RESOURCES DR,
8407: MSC_UOM_CONVERSIONS MUC -- noted in summary enhancement : inconsistent with MSCRATPB
8408: WHERE MNRA.PLAN_ID = p_plan_id
8409: AND NVL(MNRA.PARENT_ID, -2) <> -1
8410: AND DR.PLAN_ID = MNRA.PLAN_ID

Line 8484: FROM MSC_DEPARTMENT_RESOURCES DR,

8480: p_sys_date last_update_date,
8481: l_user_id last_updated_by,
8482: p_sys_date creation_date,
8483: l_user_id created_by
8484: FROM MSC_DEPARTMENT_RESOURCES DR,
8485: MSC_TRADING_PARTNERS P,
8486: MSC_RESOURCE_REQUIREMENTS REQ,
8487: MSC_SYSTEM_ITEMS I, -- summary enhancement change for CTO ODR
8488: MSC_CALENDAR_DATES C

Line 8602: FROM MSC_DEPARTMENT_RESOURCES DR,

8598: p_sys_date last_update_date,
8599: l_user_id last_updated_by,
8600: p_sys_date creation_date,
8601: l_user_id created_by
8602: FROM MSC_DEPARTMENT_RESOURCES DR,
8603: MSC_RESOURCE_REQUIREMENTS REQ,
8604: MSC_SYSTEM_ITEMS I -- summary enhancement change for CTO ODR
8605: WHERE DR.PLAN_ID = REQ.PLAN_ID
8606: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=REQ.DEPARTMENT_ID -- summary enhancement: made consistent

Line 8688: FROM MSC_DEPARTMENT_RESOURCES DR,

8684: TRUNC(NVL(REQ.END_DATE, REQ.START_DATE)) SD_DATE,
8685: -- TRUNC(REQ.START_DATE) SD_DATE,
8686: -- End Bug 3348095
8687: SUM((-1) * REQ.RESOURCE_HOURS) SD_QTY -- ATP always populates resource_hours
8688: FROM MSC_DEPARTMENT_RESOURCES DR,
8689: MSC_RESOURCE_REQUIREMENTS REQ
8690: WHERE DR.PLAN_ID = p_plan_id
8691: AND REQ.PLAN_ID = DR.PLAN_ID
8692: AND REQ.SR_INSTANCE_ID = DR.sr_instance_id