APPS.GCS_AD_ENGINE SQL Statements

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

Line: 71

      SELECT *
      FROM GCS_AD_TRANSACTIONS
      WHERE ad_transaction_id = xnsId;

Line: 80

      SELECT *
      FROM GCS_AD_TRIAL_BALANCES
      WHERE ad_transaction_id = xnsId
      AND   trial_balance_seq = tbType;

Line: 93

      SELECT r.rule_id, r.rule_name
      FROM GCS_ELIM_RULES_VL r
      WHERE r.transaction_type_code  = ruleAtts(i).xnsTypeCode
      AND   r.from_treatment_id      = ruleAtts(i).oldTreatment
      AND   r.to_treatment_id        = ruleAtts(i).newTreatment
      AND   r.enabled_flag           ='Y';

Line: 107

      SELECT t.hierarchy_name,
             d.dataset_code,
             r.hierarchy_id,
             r.treatment_id,
             r.ownership_percent,
             r.parent_entity_id   parentEntity,
             r.child_entity_id    childEntity,
             -1                   elimsEntity
      FROM GCS_HIERARCHIES_TL t,
           GCS_DATASET_CODES d,
           GCS_CONS_RELATIONSHIPS r
      WHERE t.language     = userenv('LANG')
      AND   t.hierarchy_id = r.hierarchy_id
      AND   d.hierarchy_id = r.hierarchy_id
      AND   r.cons_relationship_id = relId
      AND   r.actual_ownership_flag='Y';

Line: 128

      Select b.trial_balance_seq, sum( nvl(b.debit_amount,0) - nvl(b.credit_amount,0) )
      from   fem_ln_items_attr       lia,
             fem_ext_acct_types_attr ata,
             gcs_ad_trial_balances b
      where  lia.dim_attribute_varchar_member in ('ASSET', 'LIABILITY')
      and    ata.attribute_id          = ataAtt
      and    ata.version_id            = ataVers
      and    ata.ext_account_type_code = lia.dim_attribute_varchar_member
      and    lia.attribute_id          = liaAtt
      and    lia.version_id            = liaVers
      and    lia.line_item_id          = b.line_item_id
      and    b.ad_transaction_id       = xnsId
      group by b.trial_balance_seq;

Line: 306

    Update gcs_ad_transactions
    Set request_id = requestId
    Where ad_transaction_id = xnsId;

Line: 319

      UPDATE gcs_entry_headers
      SET DISABLED_FLAG = 'Y'
      WHERE entry_id = xnsData.assoc_entry_id;

Line: 323

      DELETE FROM gcs_entry_lines
      WHERE entry_id = xnsData.assoc_entry_id;

Line: 389

    ruleData.DELETE;

Line: 390

    ruleAtts.DELETE;

Line: 548

    xnsRules.DELETE;

Line: 573

        SELECT f.dim_attribute_numeric_member, g.currency_code
        FROM GCS_ENTITY_CONS_ATTRS g,
             FEM_ENTITIES_ATTR     f
        WHERE f.attribute_id = attr
        AND   f.version_id   = vers
        AND   f.entity_id    = g.entity_id
        AND   g.hierarchy_id = hierarchyId
        AND   g.entity_id    = parentEntity;

Line: 612

    contextData.DELETE;

Line: 645

	SELECT 	assoc_entry_id
	INTO	l_entry_id
	FROM	gcs_ad_transactions
	WHERE	ad_transaction_id	=	p_transaction_id;

Line: 653

          UPDATE  gcs_entry_lines gel
          SET     line_type_code          =       DECODE(
                                                        (SELECT feata.dim_attribute_varchar_member
                                                         FROM   fem_ext_acct_types_attr         feata,
                                                                fem_ln_items_attr               flia
                                                         WHERE  gel.line_item_id                =       flia.line_item_id
                                                         AND    flia.value_set_id               =       l_line_item_vs_id
                                                         AND    flia.attribute_id               =       l_ext_acct_type_attr
                                                         AND    flia.version_id                 =       l_ext_acct_type_version
                                                         AND    feata.attribute_id              =       l_basic_acct_type_attr
                                                         AND    feata.version_id                =       l_basic_acct_type_version
                                                         AND    feata.ext_account_type_code     =       flia.dim_attribute_varchar_member
                                                        ), 'REVENUE', 'PROFIT_LOSS',
                                                           'EXPENSE', 'PROFIT_LOSS',
                                                           'BALANCE_SHEET'
                                                        )
          WHERE   entry_id                =       l_entry_id
	  AND	  line_type_code	  IS NOT NULL;