APPS.MSC_AATP_PVT dependencies on MSC_UOM_CONVERSIONS

Line 5990: MSC_UOM_CONVERSIONS MUC

5986: MSC_SUPPLIES S,
5987: MSC_RESOURCE_REQUIREMENTS REQ,
5988: -- 2859130 MSC_CALENDAR_DATES C,
5989: MSC_SYSTEM_ITEMS I,
5990: MSC_UOM_CONVERSIONS MUC
5991: WHERE DR.PLAN_ID = p_plan_id
5992: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
5993: AND DR.RESOURCE_ID = p_resource_id
5994: AND DR.SR_INSTANCE_ID = p_instance_id

Line 6163: MSC_UOM_CONVERSIONS MUC

6159: MSC_SUPPLIES S,
6160: MSC_RESOURCE_REQUIREMENTS REQ,
6161: MSC_CALENDAR_DATES C,
6162: MSC_SYSTEM_ITEMS I,
6163: MSC_UOM_CONVERSIONS MUC
6164: WHERE DR.PLAN_ID = p_plan_id
6165: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6166: AND DR.RESOURCE_ID = p_resource_id
6167: AND DR.SR_INSTANCE_ID = p_instance_id

Line 6863: MSC_UOM_CONVERSIONS MUC

6859: MSC_SUPPLIES S,
6860: MSC_RESOURCE_REQUIREMENTS REQ,
6861: -- 2859130 MSC_CALENDAR_DATES C,
6862: MSC_SYSTEM_ITEMS I,
6863: MSC_UOM_CONVERSIONS MUC
6864: WHERE DR.PLAN_ID = p_plan_id
6865: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6866: AND DR.RESOURCE_ID = p_resource_id
6867: AND DR.SR_INSTANCE_ID = p_instance_id

Line 7154: MSC_UOM_CONVERSIONS MUC

7150: MSC_SUPPLIES S,
7151: MSC_RESOURCE_REQUIREMENTS REQ,
7152: MSC_CALENDAR_DATES C,
7153: MSC_SYSTEM_ITEMS I,
7154: MSC_UOM_CONVERSIONS MUC
7155: WHERE DR.PLAN_ID = p_plan_id
7156: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7157: AND DR.RESOURCE_ID = p_resource_id
7158: AND DR.SR_INSTANCE_ID = p_instance_id

Line 10705: FROM msc_uom_conversions

10701: IF (l_batchable_flag = 1) THEN
10702: BEGIN
10703: SELECT conversion_rate
10704: INTO l_res_conversion_rate
10705: FROM msc_uom_conversions
10706: WHERE inventory_item_id = 0
10707: AND sr_instance_id = p_instance_id
10708: AND UOM_CODE = l_res_uom;
10709: EXCEPTION