APPS.CST_PERITEMCOSTCHANGERPT_PVT SQL Statements

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

Line: 125

   'SELECT  mc.concatenated_segments  CATEGORY,
            msi.concatenated_segments ITEM,
            cppb.inventory_item_id INVENTORY_ITEM_ID,
            cppb.txn_category,
            ml.meaning STEP,
            round (nvl(cppb.txn_category_qty,0), :p_qty_precision) CATEGORY_QUANTITY,
            round (nvl(cppb.period_quantity, 0), :p_qty_precision) CUMULATIVE_QUANTITY,
            round (sum (nvl(cppb.periodic_cost,0)), 2) PERIODIC_COST,
            round (sum (nvl(cppb.txn_category_value,0)), 2) AMOUNT,
            round (sum (nvl(cppb.period_balance,0)), 2) CAV,
            round (sum (nvl(cppb.variance_amount,0)), 2) VARIANCE_AMOUNT
   FROM     cst_pac_period_balances cppb
            , mfg_lookups ml
            , mtl_item_categories mic
            , mtl_categories_kfv mc
            , mtl_system_items_kfv msi
   WHERE    CPPB.cost_group_id = :p_cost_group_id
   AND	    CPPB.pac_period_id = :p_pac_period_id
   AND	    CPPB.inventory_item_id = MSI.inventory_item_id
   AND      ml.lookup_type = ''CST_PAC_TXN_CATEGORY''
   /* The MFG LOOKUP exhibits inconsistent behavior with fractional number
      as lookup code. To ensure that the txn category is between 2 and 3 but
      also use the mfg lookup for meaning mfg lookup has been seeded with 11
      for txn_category 2.5 */
   AND      ml.lookup_code = decode(cppb.txn_category,2.5,11,cppb.txn_category)
   AND      mic.inventory_item_id = cppb.inventory_item_id
   AND      mic.organization_id = :p_item_master_org_id
   AND      mic.category_set_id = :p_category_set_id
   AND      mc.category_id = mic.category_id
   AND      msi.organization_id = mic.organization_id
   AND      msi.inventory_item_id = cppb.inventory_item_id
   AND      msi.concatenated_segments between
                nvl(:p_item_from, msi.concatenated_segments)
            AND nvl(:p_item_to, msi.concatenated_segments)
   AND      mc.concatenated_segments between
                nvl(:p_category_from, mc.concatenated_segments)
            AND nvl(:p_category_to, mc.concatenated_segments)
   GROUP BY mc.concatenated_segments,
            msi.concatenated_segments,
            cppb.inventory_item_id,
            CPPB.txn_category,
            ml.meaning,
            cppb.txn_category_qty,
            cppb.period_quantity
   ORDER BY mc.concatenated_segments, msi.concatenated_segments, cppb.txn_category'
   USING  p_qty_precision, p_qty_precision, p_cost_group_id, p_pac_period_id,
          p_item_master_org_id, p_category_set_id, p_item_from, p_item_to,
          p_category_from, p_category_to;

Line: 340

   SELECT  name
   INTO    l_legal_entity
   FROM    xle_entity_profiles
   WHERE   legal_entity_id = i_legal_entity_id;

Line: 347

   SELECT  cost_type
   INTO    l_cost_type
   FROM    cst_cost_types
   WHERE   cost_type_id = i_cost_type_id;

Line: 354

   SELECT  cost_group
   INTO    l_cost_group
   FROM    cst_cost_groups
   WHERE   cost_group_id = i_cost_group_id
   AND     cost_group_type = 2;

Line: 362

   SELECT  period_name
   INTO    l_pac_period
   FROM    cst_pac_periods
   WHERE   pac_period_id = i_pac_period_id
   AND     legal_entity = i_legal_entity_id
   AND     cost_type_id = i_cost_type_id;

Line: 371

   SELECT  category_set_name
   INTO    l_category_set
   FROM    mtl_category_sets
   WHERE   category_set_id = i_category_set_id;

Line: 378

   SELECT  organization_code
   INTO    l_item_master_org
   FROM    mtl_parameters
   WHERE   organization_id = i_item_master_org_id;

Line: 385

   SELECT  currency_code
   INTO    l_currency_code
   FROM    gl_ledger_le_v
   WHERE   legal_entity_id = i_legal_entity_id
   AND     ledger_category_code = 'PRIMARY';

Line: 393

      'SELECT :l_legal_entity LEGAL_ENTITY,
              :l_cost_type COST_TYPE,
              :l_pac_period PAC_PERIOD,
              :l_cost_group COST_GROUP,
              :l_category_set CATEGORY_SET,
              :l_item_master_org ITEM_MASTER_ORG,
              :i_category_from CATEGORY_FROM,
              :i_category_to CATEGORY_TO,
              :i_item_from ITEM_FROM,
              :i_item_to ITEM_TO,
              :l_currency_code CURRENCY_CODE
       FROM   dual'
   USING  l_legal_entity, l_cost_type, l_pac_period, l_cost_group,
          l_category_set, l_item_master_org, i_category_from, i_category_to,
          i_item_from, i_item_to, l_currency_code;