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_POST_PRO dependencies on MSC_DEPARTMENT_RESOURCES

Line 8173: FROM MSC_DEPARTMENT_RESOURCES DR,

8169: (DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, I.UNIT_VOLUME) *
8170: NVL(S.NEW_ORDER_QUANTITY, S.FIRM_QUANTITY)), 1) SD_QTY,
8171: NVL(DR.BATCHABLE_FLAG,2) BATCHABLE_FLAG,
8172: DECODE(DR.UOM_CLASS_TYPE,1 , I.WEIGHT_UOM, 2, I.VOLUME_UOM) UOM_CODE
8173: FROM MSC_DEPARTMENT_RESOURCES DR,
8174: MSC_TRADING_PARTNERS P,
8175: MSC_RESOURCE_REQUIREMENTS REQ,
8176: MSC_SYSTEM_ITEMS I,
8177: MSC_SUPPLIES S,

Line 8234: MSC_DEPARTMENT_RESOURCES DR,

8230: l_user_id last_updated_by,
8231: p_sys_date creation_date,
8232: l_user_id created_by
8233: FROM MSC_NET_RESOURCE_AVAIL MNRA,
8234: MSC_DEPARTMENT_RESOURCES DR,
8235: MSC_UOM_CONVERSIONS MUC -- noted in summary enhancement : inconsistent with MSCRATPB
8236: WHERE MNRA.PLAN_ID = p_plan_id
8237: AND NVL(MNRA.PARENT_ID, -2) <> -1
8238: AND DR.PLAN_ID = MNRA.PLAN_ID

Line 8326: FROM MSC_DEPARTMENT_RESOURCES DR,

8322: (DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, I.UNIT_VOLUME) *
8323: NVL(S.NEW_ORDER_QUANTITY, S.FIRM_QUANTITY)), 1) SD_QTY,
8324: NVL(DR.BATCHABLE_FLAG,2) BATCHABLE_FLAG,
8325: DECODE(DR.UOM_CLASS_TYPE,1 , I.WEIGHT_UOM, 2, I.VOLUME_UOM) UOM_CODE
8326: FROM MSC_DEPARTMENT_RESOURCES DR,
8327: MSC_RESOURCE_REQUIREMENTS REQ,
8328: MSC_SYSTEM_ITEMS I,
8329: MSC_SUPPLIES S
8330: ---- re-ordered tables for performance

Line 8377: MSC_DEPARTMENT_RESOURCES DR,

8373: l_user_id last_updated_by,
8374: p_sys_date creation_date,
8375: l_user_id created_by
8376: FROM MSC_NET_RESOURCE_AVAIL MNRA,
8377: MSC_DEPARTMENT_RESOURCES DR,
8378: MSC_UOM_CONVERSIONS MUC -- noted in summary enhancement : inconsistent with MSCRATPB
8379: WHERE MNRA.PLAN_ID = p_plan_id
8380: AND NVL(MNRA.PARENT_ID, -2) <> -1
8381: AND DR.PLAN_ID = MNRA.PLAN_ID

Line 8455: FROM MSC_DEPARTMENT_RESOURCES DR,

8451: p_sys_date last_update_date,
8452: l_user_id last_updated_by,
8453: p_sys_date creation_date,
8454: l_user_id created_by
8455: FROM MSC_DEPARTMENT_RESOURCES DR,
8456: MSC_TRADING_PARTNERS P,
8457: MSC_RESOURCE_REQUIREMENTS REQ,
8458: MSC_SYSTEM_ITEMS I, -- summary enhancement change for CTO ODR
8459: MSC_CALENDAR_DATES C

Line 8573: FROM MSC_DEPARTMENT_RESOURCES DR,

8569: p_sys_date last_update_date,
8570: l_user_id last_updated_by,
8571: p_sys_date creation_date,
8572: l_user_id created_by
8573: FROM MSC_DEPARTMENT_RESOURCES DR,
8574: MSC_RESOURCE_REQUIREMENTS REQ,
8575: MSC_SYSTEM_ITEMS I -- summary enhancement change for CTO ODR
8576: WHERE DR.PLAN_ID = REQ.PLAN_ID
8577: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=REQ.DEPARTMENT_ID -- summary enhancement: made consistent

Line 8659: FROM MSC_DEPARTMENT_RESOURCES DR,

8655: TRUNC(NVL(REQ.END_DATE, REQ.START_DATE)) SD_DATE,
8656: -- TRUNC(REQ.START_DATE) SD_DATE,
8657: -- End Bug 3348095
8658: SUM((-1) * REQ.RESOURCE_HOURS) SD_QTY -- ATP always populates resource_hours
8659: FROM MSC_DEPARTMENT_RESOURCES DR,
8660: MSC_RESOURCE_REQUIREMENTS REQ
8661: WHERE DR.PLAN_ID = p_plan_id
8662: AND REQ.PLAN_ID = DR.PLAN_ID
8663: AND REQ.SR_INSTANCE_ID = DR.sr_instance_id