ERP Functional Application Specialist

Untuk para Functional dari ERP Financial Application Khususnya Oracle Finance R12 berikut ini saya sedikit share tentang langkah-langkah menarik data dari TOAD atau SQL Pluss untuk menarik informasi bank Account.

Querry untuk Menarik List Bank Account Orafin R12

SELECT cba.bank_account_name            "Bank Account Name",

       cba.bank_account_num             "Bank Account Number",

       cba.multi_currency_allowed_flag  "Multi Currency Flag",

       cba.zero_amount_allowed          "Zero Amount Flag",

--       cba.account_classification       "Account Classification",

       bb.bank_name                     "Bank Name",

       bb.bank_branch_type              "Bank Branch Type",

       bb.bank_branch_name              "Bank Branch Name",

       bb.bank_branch_number            "Bank Branch Number",

       bb.eft_swift_code                "Swift Code",

       -- bb.description                   "Description",

       ou.name                          "Operating Unit",

       GCC.concatenated_segments        "Chart Of Account Bank",

        GCC.SEGMENT1

        , GET_DESC_SEGMENT_COA (GCC.SEGMENT1 , 1) COMPANY_DESC

--        , GET_DESC_SEGMENT_COA_MNC_MSKY (GCC.SEGMENT1 , 1) DESC1

        , GCC.SEGMENT2

        , GET_DESC_SEGMENT_COA (GCC.SEGMENT2 , 2) ACCOUNT_DESC

--        , GET_DESC_SEGMENT_COA_MNC_MSKY (GCC.SEGMENT2 , 2) DESC2

        , GCC.SEGMENT3

        , GET_DESC_SEGMENT_COA (GCC.SEGMENT3 , 3) COST_CENTER_DESC

--        , GET_DESC_SEGMENT_COA_MNC_MSKY (GCC.SEGMENT3 , 3) DESC3

        , GCC.SEGMENT4

        , GET_DESC_SEGMENT_COA (GCC.SEGMENT4 , 4) WILAYAH_DESC

--        , GET_DESC_SEGMENT_COA_MNC_MSKY (GCC.SEGMENT4 , 4) DESC4

  FROM ce_bank_accounts          cba,

       ce_bank_acct_uses_all     bau,

       cefv_bank_branches        bb,

       hr_operating_units        ou,

       gl_code_combinations_kfv  GCC

 WHERE cba.bank_account_id = bau.bank_account_id

   AND cba.bank_branch_id  = bb.bank_branch_id

   AND ou.organization_id  = bau.org_id

   AND cba.asset_code_combination_id = GCC.code_combination_id

--   and  gcf.segment2 = ts.FLEX_VALUE_MEANING

   and ou.ORGANIZATION_ID ='83'