APPS.EDW_ORGANIZATION_M_SIZING SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

  SELECT COUNT(*) total
  FROM
   hr_all_organization_units            org
  ,per_business_groups                  bgr
  ,hr_organization_information          oi1
  ,hr_all_organization_units            ou
  ,mtl_parameters                       mp
  ,hr_organization_information          oi2
  ,hri_primary_hrchys                   tree
  WHERE org.business_group_id           = bgr.business_group_id
  AND   org.organization_id             = oi1.organization_id (+)
  AND   oi1.org_information_context (+) = 'Accounting Information'
  AND   to_number(oi1.org_information3) = ou.organization_id (+)
  AND   org.organization_id             = mp.organization_id (+)
  AND   org.organization_id             = oi2.organization_id (+)
  AND   oi2.org_information_context (+) = 'CLASS'
  AND   oi2.org_information1 (+)        = 'OPERATING_UNIT'
  AND   oi2.org_information2 (+)        = 'Y'
  AND   tree.organization_id (+)        = org.organization_id
  AND greatest( NVL(org.last_update_date, to_date('01-01-2000','DD-MM-YYYY')),
                NVL(ou.last_update_date,  to_date('01-01-2000','DD-MM-YYYY')),
                NVL(tree.org_last_updated,to_date('01-01-2000','DD-MM-YYYY')),
                NVL(oi1.last_update_date, to_date('01-01-2000','DD-MM-YYYY')),
                NVL(mp.last_update_date,  to_date('01-01-2000','DD-MM-YYYY')),
                NVL(oi2.last_update_date, to_date('01-01-2000','DD-MM-YYYY')))
    BETWEEN p_from_date AND p_to_date;

Line: 82

  x_last_update_date       NUMBER := x_date;

Line: 152

/* Selects the length of the instance code */
  CURSOR inst_cur IS
  SELECT avg(nvl(vsize(instance_code),0))
  FROM edw_local_instance;

Line: 158

  SELECT
   avg(nvl(vsize(name),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('INTL_EXTL',internal_external_flag)),0))
  ,avg(nvl(vsize(type),0))
  ,avg(nvl(vsize(hr_general.decode_lookup('ORG_TYPE',type)),0))
  ,avg(nvl(vsize(organization_id),0))
  FROM hr_all_organization_units
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 168

  SELECT avg(nvl(vsize(primary_cost_method),0))
  FROM mtl_parameters
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 173

  SELECT avg(nvl(vsize(id_flex_structure_name),0))
  FROM fnd_id_flex_structures_vl
  WHERE application_id = 801
  AND id_flex_code = 'COST'
  AND last_update_date BETWEEN p_from_date AND p_to_date;

Line: 180

  SELECT avg(nvl(vsize(territory_short_name),0))
  FROM fnd_territories_vl
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 185

  SELECT avg(nvl(vsize(name),0))
  FROM gl_sets_of_books
  WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line: 227

                        + NVL (ceil(x_last_update_date + 1), 0)
                        + NVL (ceil(x_bg_name + 1), 0)
                        + NVL (ceil(x_org_type + 1), 0)
                        + NVL (ceil(x_org_code + 1), 0)
                        + NVL (ceil(x_primary_cst_mthd + 1), 0)
                        + NVL (ceil(x_business_group_id + 1), 0)
                        + NVL (ceil(x_cost_allocation + 1), 0)
                        + NVL (ceil(x_legislation + 1), 0);

Line: 249

                       + NVL (ceil(x_last_update_date + 1), 0)
                       + NVL (ceil(x_legal_entity_dp + 1), 0)
                       + NVL (ceil(x_legal_entity_pk + 1), 0)
                       + NVL (ceil(x_level_name + 1), 0)
                       + NVL (ceil(x_lg_name + 1), 0)
                       + NVL (ceil(x_org_type + 1), 0)
                       + NVL (ceil(x_org_code + 1), 0)
                       + NVL (ceil(x_primary_cst_mthd + 1), 0)
                       + NVL (ceil(x_set_of_books + 1), 0)
                       + NVL (ceil(x_business_group_id + 1), 0);

Line: 274

                      + NVL (ceil(x_last_update_date + 1), 0)
                      + NVL (ceil(x_legal_entity_fk + 1), 0)
                      + NVL (ceil(x_level_name + 1), 0)
                      + NVL (ceil(x_ou_name + 1), 0)
                      + NVL (ceil(x_operating_unit_dp + 1), 0)
                      + NVL (ceil(x_operating_unit_pk + 1), 0)
                      + NVL (ceil(x_org_type + 1), 0)
                      + NVL (ceil(x_org_code + 1), 0)
                      + NVL (ceil(x_primary_cst_mthd + 1), 0)
                      + NVL (ceil(x_business_group_id + 1), 0);

Line: 299

                         + NVL (ceil(x_last_update_date + 1), 0)
                         + NVL (ceil(x_level_name + 1), 0)
                         + NVL (ceil(x_org_name + 1), 0)
                         + NVL (ceil(x_operating_unit_fk + 1), 0)
                         + NVL (ceil(x_organization_dp + 1), 0)
                         + NVL (ceil(x_organization_pk + 1), 0)
                         + NVL (ceil(x_org_type + 1), 0)
                         + NVL (ceil(x_org_code + 1), 0)
                         + NVL (ceil(x_primary_cst_mthd + 1), 0)
                         + NVL (ceil(x_business_group_id + 1), 0)
                         + NVL (ceil(x_org_tree1_lvl1_fk + 1), 0);

Line: 319

                       + NVL (ceil(x_last_update_date + 1), 0)
                       + NVL (ceil(x_l8_name + 1), 0)
                       + NVL (ceil(x_business_group_id + 1), 0)
                       + NVL (ceil(x_org_tree1_lvl8_pk + 1), 0)
                       + NVL (ceil(x_l8_name + 1), 0);

Line: 334

                       + NVL (ceil(x_last_update_date + 1), 0)
                       + NVL (ceil(x_l7_name + 1), 0)
                       + NVL (ceil(x_business_group_id + 1), 0)
                       + NVL (ceil(x_org_tree1_lvl7_pk + 1), 0)
                       + NVL (ceil(x_org_tree1_lvl8_fk + 1), 0)
                       + NVL (ceil(x_l8_name + 1), 0);