[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT
INTO GMF_PROCESS_ORGANIZATIONS_GT
(
organization_id,
organization_code,
base_currency_code,
std_uom,
legal_entity_id,
operating_unit_id
)
SELECT mp.organization_id,
mp.organization_code,
gfp.base_currency_code,
NULL,
p_legal_entity_id,
ood.operating_unit
FROM mtl_parameters mp,
gmf_fiscal_policies gfp,
org_organization_definitions ood
WHERE mp.organization_id = l_inv_orgs(j)
AND mp.process_enabled_flag = 'Y'
AND mp.organization_code >= NVL(l_from_orgn_code,mp.organization_code)
AND mp.organization_code <= NVL(l_to_orgn_code,mp.organization_code)
AND gfp.legal_entity_id = p_legal_entity_id
AND ood.organization_id = l_inv_orgs(j)
;
UPDATE gmf_process_organizations_gt gpo
SET std_uom = (SELECT u.uom_code
FROM mtl_units_of_measure u,
gmd_parameters_hdr h,
gmd_parameters_dtl d
WHERE u.base_uom_flag = 'Y'
AND gpo.organization_id = h.organization_id
AND h.parameter_id = d.parameter_id
AND d.parameter_name = 'FM_YIELD_TYPE'
AND d.parameter_value = u.uom_class)
WHERE gpo.std_uom IS NULL;
UPDATE gmf_process_organizations_gt gpo
SET std_uom = (SELECT u.uom_code
FROM mtl_units_of_measure u,
gmd_parameters_hdr h,
gmd_parameters_dtl d
WHERE u.base_uom_flag = 'Y'
AND h.organization_id IS NULL
AND h.parameter_id = d.parameter_id
AND d.parameter_name = 'FM_YIELD_TYPE'
AND d.parameter_value = u.uom_class)
WHERE gpo.std_uom IS NULL;