APPS.INV_MGD_MVT_SETUP_MDTR SQL Statements

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

Line: 93

  SELECT
    mstat.zone_code
  , UPPER(mstat.usage_type)
  , UPPER(mstat.stat_type )
  , mstat.start_period_name
  , mstat.end_period_name
  , mstat.period_set_name
  , mstat.period_type
  , mstat.weight_uom_code
  , mstat.conversion_type
  , mstat.attribute_rule_set_code
  , mstat.alt_uom_rule_set_code
  , glp.start_date
  , DECODE(mstat.end_period_name,NULL,NULL,glp1.end_date)
  , mstat.category_set_id
  , gllv.period_set_name
  , gllv.currency_code
  , gllv.currency_code
  , mstat.conversion_option
  , mstat.triangulation_mode
  , mstat.reference_period_rule
  , mstat.pending_invoice_days
  , mstat.prior_invoice_days
  , mstat.returns_processing
  , mstat.kit_method
  , nvl(mstat.include_establishments,'N')
  FROM
    GL_PERIODS glp
  , GL_PERIODS glp1
  , gl_ledger_le_v gllv
  , MTL_STAT_TYPE_USAGES mstat
  WHERE glp.period_set_name   = mstat.period_set_name
  AND   glp1.period_set_name  = mstat.period_set_name
  AND   glp.period_name       = mstat.start_period_name
  AND   glp1.period_name      = NVL(mstat.end_period_name,
                                    mstat.start_period_name)
  AND   gllv.legal_entity_id  = mstat.legal_entity_id
  AND   ledger_category_code  = 'PRIMARY'
  AND   mstat.legal_entity_id = p_legal_entity_id
  AND   mstat.zone_code       = p_movement_transaction.zone_code
  AND   mstat.usage_type      = p_movement_transaction.usage_type
  AND   mstat.stat_type       = p_movement_transaction.stat_type
  AND   trunc(l_transaction_date) BETWEEN trunc(glp.start_date) AND
          TRUNC(DECODE(mstat.end_period_name,NULL,
                        (l_transaction_date+1),glp1.end_date));

Line: 224

  SELECT
    mstat.zone_code
  , UPPER(mstat.usage_type)
  , UPPER(mstat.stat_type )
  , mstat.reference_period_rule
  , mstat.pending_invoice_days
  , mstat.prior_invoice_days
  , mstat.triangulation_mode
  FROM
    MTL_STAT_TYPE_USAGES mstat
  WHERE mstat.legal_entity_id = p_legal_entity_id;

Line: 323

  SELECT
    mstat.start_period_name
  , mstat.end_period_name
  , mstat.period_set_name
  , mstat.period_type
  , mstat.weight_uom_code
  , mstat.conversion_type
  , mstat.attribute_rule_set_code
  , mstat.alt_uom_rule_set_code
  , glp.start_date
  , DECODE(mstat.end_period_name,NULL,NULL,glp1.end_date)
  , mstat.category_set_id
  , gllv.currency_code
  , gllv.currency_code
  , mstat.conversion_option
  , mstat.triangulation_mode
  , mstat.reference_period_rule
  , mstat.pending_invoice_days
  , mstat.prior_invoice_days
  , mstat.returns_processing
  FROM
    GL_PERIODS glp
  , GL_PERIODS glp1
  , gl_ledger_le_v gllv
  , MTL_STAT_TYPE_USAGES mstat
  WHERE glp.period_set_name   = glp1.period_set_name
  AND   glp.period_set_name   = mstat.period_set_name
  AND   glp1.period_set_name  = mstat.period_set_name
  AND   glp.period_type       = mstat.period_type
  AND   glp1.period_type      = mstat.period_type
  AND   glp.period_name       = mstat.start_period_name
  AND   glp1.period_name      = NVL(mstat.end_period_name,
                                    mstat.start_period_name)
  --AND   glb.period_set_name   = glp.period_set_name        fix bug2203762,3723698
  AND   gllv.legal_entity_id  = mstat.legal_entity_id
  AND   gllv.ledger_category_code  = 'PRIMARY'
  AND   mstat.legal_entity_id = p_legal_entity_id
  AND   mstat.zone_code       = p_movement_transaction.zone_code
  AND   mstat.usage_type      = p_movement_transaction.usage_type
  AND   mstat.stat_type       = p_movement_transaction.stat_type;

Line: 427

  l_insert_flag          VARCHAR2(1);

Line: 451

    l_insert_flag   := 'N';

Line: 489

      l_insert_flag := 'Y';

Line: 491

      l_insert_flag := 'N';

Line: 505

      l_insert_flag := 'N';

Line: 510

      l_insert_flag := 'Y';

Line: 512

      l_insert_flag := 'N';

Line: 515

    l_insert_flag := 'N';

Line: 526

RETURN l_insert_flag;

Line: 579

  SELECT  conversion_option
       ,  conversion_type
       ,  category_set_id
       ,  start_period_name
       ,  end_period_name
       ,  weight_uom_code
       ,  period_set_name
       ,  attribute_rule_set_code
       ,  alt_uom_rule_set_code
       ,  returns_processing
    INTO  x_movement_stat_usages_rec.conversion_option
       ,  x_movement_stat_usages_rec.conversion_type
       ,  x_movement_stat_usages_rec.category_set_id
       ,  x_movement_stat_usages_rec.start_period_name
       ,  x_movement_stat_usages_rec.end_period_name
       ,  x_movement_stat_usages_rec.weight_uom_code
       ,  x_movement_stat_usages_rec.period_set_name
       ,  x_movement_stat_usages_rec.attribute_rule_set_code
       ,  x_movement_stat_usages_rec.alt_uom_rule_set_code
       ,  x_movement_stat_usages_rec.returns_processing
    FROM  mtl_stat_type_usages
    WHERE legal_entity_id = p_legal_entity_id
      AND zone_code       = p_economic_zone_code
      AND usage_type      = p_usage_type
      AND stat_type       = p_stat_type;

Line: 605

  SELECT  ledger_id
       ,  currency_code
    INTO  x_movement_stat_usages_rec.gl_set_of_books_id
       ,  x_movement_stat_usages_rec.gl_currency_code
    FROM  gl_ledger_le_v
    WHERE legal_entity_id = p_legal_entity_id
      AND ledger_category_code = 'PRIMARY';