DBA Data[Home] [Help]

APPS.GMF_ORGANIZATIONS_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 117: FROM mtl_units_of_measure u,

113:
114:
115: UPDATE gmf_process_organizations_gt gpo
116: SET std_uom = (SELECT u.uom_code
117: FROM mtl_units_of_measure u,
118: gmd_parameters_hdr h,
119: gmd_parameters_dtl d
120: WHERE u.base_uom_flag = 'Y'
121: AND gpo.organization_id = h.organization_id

Line 129: FROM mtl_units_of_measure u,

125: WHERE gpo.std_uom IS NULL;
126:
127: UPDATE gmf_process_organizations_gt gpo
128: SET std_uom = (SELECT u.uom_code
129: FROM mtl_units_of_measure u,
130: gmd_parameters_hdr h,
131: gmd_parameters_dtl d
132: WHERE u.base_uom_flag = 'Y'
133: AND h.organization_id IS NULL