DBA Data[Home] [Help]

APPS.GMF_ORGANIZATIONS_PKG dependencies on GMD_PARAMETERS_DTL

Line 174: gmd_parameters_dtl d

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
177: AND h.parameter_id = d.parameter_id
178: AND d.parameter_name = 'FM_YIELD_TYPE'

Line 186: gmd_parameters_dtl d

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
189: AND h.parameter_id = d.parameter_id
190: AND d.parameter_name = 'FM_YIELD_TYPE'