APPS.MSC_AATP_PVT dependencies on MSC_UOM_CONVERSIONS

Line 6220: MSC_UOM_CONVERSIONS MUC

6216: MSC_SUPPLIES S,
6217: MSC_RESOURCE_REQUIREMENTS REQ,
6218: -- 2859130 MSC_CALENDAR_DATES C,
6219: MSC_SYSTEM_ITEMS I,
6220: MSC_UOM_CONVERSIONS MUC
6221: WHERE DR.PLAN_ID = p_plan_id
6222: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6223: AND DR.RESOURCE_ID = p_resource_id
6224: AND DR.SR_INSTANCE_ID = p_instance_id

Line 6393: MSC_UOM_CONVERSIONS MUC

6389: MSC_SUPPLIES S,
6390: MSC_RESOURCE_REQUIREMENTS REQ,
6391: MSC_CALENDAR_DATES C,
6392: MSC_SYSTEM_ITEMS I,
6393: MSC_UOM_CONVERSIONS MUC
6394: WHERE DR.PLAN_ID = p_plan_id
6395: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6396: AND DR.RESOURCE_ID = p_resource_id
6397: AND DR.SR_INSTANCE_ID = p_instance_id

Line 7093: MSC_UOM_CONVERSIONS MUC

7089: MSC_SUPPLIES S,
7090: MSC_RESOURCE_REQUIREMENTS REQ,
7091: -- 2859130 MSC_CALENDAR_DATES C,
7092: MSC_SYSTEM_ITEMS I,
7093: MSC_UOM_CONVERSIONS MUC
7094: WHERE DR.PLAN_ID = p_plan_id
7095: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7096: AND DR.RESOURCE_ID = p_resource_id
7097: AND DR.SR_INSTANCE_ID = p_instance_id

Line 7384: MSC_UOM_CONVERSIONS MUC

7380: MSC_SUPPLIES S,
7381: MSC_RESOURCE_REQUIREMENTS REQ,
7382: MSC_CALENDAR_DATES C,
7383: MSC_SYSTEM_ITEMS I,
7384: MSC_UOM_CONVERSIONS MUC
7385: WHERE DR.PLAN_ID = p_plan_id
7386: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7387: AND DR.RESOURCE_ID = p_resource_id
7388: AND DR.SR_INSTANCE_ID = p_instance_id

Line 10936: FROM msc_uom_conversions

10932: IF (l_batchable_flag = 1) THEN
10933: BEGIN
10934: SELECT conversion_rate
10935: INTO l_res_conversion_rate
10936: FROM msc_uom_conversions
10937: WHERE inventory_item_id = 0
10938: AND sr_instance_id = p_instance_id
10939: AND UOM_CODE = l_res_uom;
10940: EXCEPTION