APPS.MSC_POST_PRO dependencies on MSC_UOM_CONVERSIONS

Line 8154: FROM MSC_UOM_CONVERSIONS MUC,

8150: p_sys_date last_update_date,
8151: l_user_id last_updated_by,
8152: p_sys_date creation_date,
8153: l_user_id created_by
8154: FROM MSC_UOM_CONVERSIONS MUC,
8155: (SELECT -- hint for better performance.
8156: /*+ ORDERED index(REQ MSC_RESOURCE_REQUIREMENTS_N2) */
8157: DR.PLAN_ID plan_id,
8158: NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID) department_id,

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

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

Line 8306: FROM MSC_UOM_CONVERSIONS MUC,

8302: p_sys_date last_update_date,
8303: l_user_id last_updated_by,
8304: p_sys_date creation_date,
8305: l_user_id created_by
8306: FROM MSC_UOM_CONVERSIONS MUC,
8307: (SELECT -- hint for better performance.
8308: /*+ ORDERED index(REQ MSC_RESOURCE_REQUIREMENTS_N2) */
8309: DR.PLAN_ID plan_id,
8310: NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID) department_id,

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

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