DBA Data[Home] [Help]

APPS.GMF_ORGANIZATIONS_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 172: FROM mtl_units_of_measure u,

168:
169:
170: UPDATE gmf_process_organizations_gt gpo
171: SET std_uom = (SELECT u.uom_code
172: FROM mtl_units_of_measure u,
173: gmd_parameters_hdr h,
174: gmd_parameters_dtl d
175: WHERE u.base_uom_flag = 'Y'
176: AND gpo.organization_id = h.organization_id

Line 184: FROM mtl_units_of_measure u,

180: WHERE gpo.std_uom IS NULL;
181:
182: UPDATE gmf_process_organizations_gt gpo
183: SET std_uom = (SELECT u.uom_code
184: FROM mtl_units_of_measure u,
185: gmd_parameters_hdr h,
186: gmd_parameters_dtl d
187: WHERE u.base_uom_flag = 'Y'
188: AND h.organization_id IS NULL