APPS.GMF_TRANSACTION_ACCOUNTS_PUB SQL Statements

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

Line: 197

      SELECT CASE WHEN g_gmf_accts_tab_PUR(idx).account_type_code = 'INV' THEN
                    material_account
                  WHEN g_gmf_accts_tab_PUR(idx).account_type_code = 'EXP' THEN
                    expense_account
                  WHEN g_gmf_accts_tab_PUR(idx).account_type_code = 'AAP' THEN
                    ap_accrual_account
                  WHEN g_gmf_accts_tab_PUR(idx).account_type_code = 'PPV' THEN
                    purchase_price_var_account
             END CASE
        INTO g_gmf_accts_tab_PUR(idx).target_ccid
        FROM mtl_parameters mp
       WHERE mp.organization_id = g_gmf_accts_tab_PUR(idx).organization_id
      ;

Line: 211

      SELECT CONCATENATED_SEGMENTS
        INTO g_gmf_accts_tab_PUR(idx).concatenated_segments
        FROM gl_code_combinations_kfv
       WHERE CODE_COMBINATION_ID = g_gmf_accts_tab_PUR(idx).target_ccid
      ;

Line: 245

    SELECT legal_entity, set_of_books_id, chart_of_accounts_id
      INTO l_legal_entity_id, l_ledger_id, l_coa_id
      FROM org_organization_definitions
     WHERE organization_id = to_number(g_gmf_accts_tab_PUR(1).operating_unit);

Line: 486

      SELECT CASE WHEN g_gmf_accts_tab_CTO(idx).account_type_code = G_CHARGE_INV_ACCT THEN
                    material_account
                  WHEN g_gmf_accts_tab_CTO(idx).account_type_code = G_CHARGE_EXP_ACCT THEN
                    expense_account
                  WHEN g_gmf_accts_tab_CTO(idx).account_type_code = G_ACCRUAL_ACCT THEN
                    ap_accrual_account
                  WHEN g_gmf_accts_tab_CTO(idx).account_type_code = G_VARIANCE_PPV_ACCT THEN
                    purchase_price_var_account
             END CASE
        INTO g_gmf_accts_tab_CTO(idx).target_ccid
        FROM mtl_parameters mp
       WHERE mp.organization_id = g_gmf_accts_tab_CTO(idx).organization_id
      ;

Line: 500

      SELECT CONCATENATED_SEGMENTS
        INTO g_gmf_accts_tab_CTO(idx).concatenated_segments
        FROM gl_code_combinations_kfv
       WHERE CODE_COMBINATION_ID = g_gmf_accts_tab_CTO(idx).target_ccid
      ;

Line: 523

      SELECT CASE WHEN g_gmf_accts_tab_CTO(idx).account_type_code = 'INV' THEN
                    distribution_account_id
                  WHEN g_gmf_accts_tab_CTO(idx).account_type_code = 'EXP' THEN
                    expense_account
                  WHEN g_gmf_accts_tab_CTO(idx).account_type_code = 'AAP' THEN
                    ap_accrual_account
                  WHEN g_gmf_accts_tab_CTO(idx).account_type_code = 'PPV' THEN
                    purchase_price_var_account
             END CASE
        INTO g_gmf_accts_tab_CTO(idx).target_ccid
        FROM mtl_parameters mp
       WHERE mp.organization_id = g_gmf_accts_tab_CTO(idx).organization_id
      ;

Line: 537

      SELECT CONCATENATED_SEGMENTS
        INTO g_gmf_accts_tab_CTO(idx).concatenated_segments
        FROM gl_code_combinations_kfv
       WHERE CODE_COMBINATION_ID = g_gmf_accts_tab_CTO(idx).target_ccid
      ;

Line: 561

    SELECT legal_entity, set_of_books_id, chart_of_accounts_id
      INTO l_legal_entity_id, l_ledger_id, l_coa_id
      FROM org_organization_definitions
     WHERE organization_id = g_gmf_accts_tab_CTO(1).operating_unit;