DBA Data[Home] [Help]

APPS.EDW_ORGANIZATION_M_SIZING dependencies on MTL_PARAMETERS

Line 21: ,mtl_parameters mp

17: hr_all_organization_units org
18: ,per_business_groups bgr
19: ,hr_organization_information oi1
20: ,hr_all_organization_units ou
21: ,mtl_parameters mp
22: ,hr_organization_information oi2
23: ,hri_primary_hrchys tree
24: WHERE org.business_group_id = bgr.business_group_id
25: AND org.organization_id = oi1.organization_id (+)

Line 169: FROM mtl_parameters

165: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
166:
167: CURSOR pcm_cur IS
168: SELECT avg(nvl(vsize(primary_cost_method),0))
169: FROM mtl_parameters
170: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
171:
172: CURSOR cst_cur IS
173: SELECT avg(nvl(vsize(id_flex_structure_name),0))