APPS.MSC_POST_PRO dependencies on MSC_UOM_CONVERSIONS

Line 8183: FROM MSC_UOM_CONVERSIONS MUC,

8179: p_sys_date last_update_date,
8180: l_user_id last_updated_by,
8181: p_sys_date creation_date,
8182: l_user_id created_by
8183: FROM MSC_UOM_CONVERSIONS MUC,
8184: (SELECT -- hint for better performance.
8185: /*+ ORDERED index(REQ MSC_RESOURCE_REQUIREMENTS_N2) */
8186: DR.PLAN_ID plan_id,
8187: NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID) department_id,

Line 8264: MSC_UOM_CONVERSIONS MUC -- noted in summary enhancement : inconsistent with MSCRATPB

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
8268: AND DR.SR_INSTANCE_ID = MNRA.SR_INSTANCE_ID

Line 8335: FROM MSC_UOM_CONVERSIONS MUC,

8331: p_sys_date last_update_date,
8332: l_user_id last_updated_by,
8333: p_sys_date creation_date,
8334: l_user_id created_by
8335: FROM MSC_UOM_CONVERSIONS MUC,
8336: (SELECT -- hint for better performance.
8337: /*+ ORDERED index(REQ MSC_RESOURCE_REQUIREMENTS_N2) */
8338: DR.PLAN_ID plan_id,
8339: NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID) department_id,

Line 8407: MSC_UOM_CONVERSIONS MUC -- noted in summary enhancement : inconsistent with MSCRATPB

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
8411: AND DR.SR_INSTANCE_ID = MNRA.SR_INSTANCE_ID