2 Replies Latest reply: Apr 18, 2013 3:17 AM by Selvakumar S RSS

    plz  : its  urjent .i have  sql querry how to convert that sql query into qlik view script

      i have  sql querry how to convert that sql querry into qlik view script  major doubt in inline view

       

       

      the   sl querry  :

      SELECT pppm.assignment_id assignment_id/*Join Identifier to 01_Person_Assignment*/

           , popm.org_payment_method_name NAME

           , ppt.payment_type_name TYPE

           , pppm.priority priority

           , (SELECT pbt.currency_code

                FROM pay_defined_balances pdb

                   , pay_balance_types pbt

               WHERE pdb.defined_balance_id = popm.defined_balance_id

                 AND pdb.balance_type_id = pbt.balance_type_id) balance_currency

           , pppm.amount balance_amount

           , pppm.percentage percentage

           , popm.currency_code payment_currency

           , bank_kff.segment_name bank_details_segment_name

           , DECODE (bank_kff.segment_column

                   , 'SEGMENT1', pea.segment1

                   , 'SEGMENT2', pea.segment2

                   , 'SEGMENT3', pea.segment3

                   , 'SEGMENT4', pea.segment4

                   , 'SEGMENT5', pea.segment5

                   , 'SEGMENT6', pea.segment6

                   , 'SEGMENT7', pea.segment7

                   , 'SEGMENT8', pea.segment8

                   , 'SEGMENT9', pea.segment9

                   , 'SEGMENT10', pea.segment10

                   , 'SEGMENT11', pea.segment11

                   , 'SEGMENT12', pea.segment12

                   , 'SEGMENT13', pea.segment13

                   , 'SEGMENT14', pea.segment14

                   , 'SEGMENT15', pea.segment15

                   , 'SEGMENT16', pea.segment16

                   , 'SEGMENT17', pea.segment17

                   , 'SEGMENT18', pea.segment18

                   , 'SEGMENT19', pea.segment19

                   , 'SEGMENT20', pea.segment20

                   , 'SEGMENT21', pea.segment21

                   , 'SEGMENT22', pea.segment22

                   , 'SEGMENT23', pea.segment23

                   , 'SEGMENT24', pea.segment24

                   , 'SEGMENT25', pea.segment25

                   , 'SEGMENT26', pea.segment26

                   , 'SEGMENT27', pea.segment27

                   , 'SEGMENT28', pea.segment28

                   , 'SEGMENT29', pea.segment29

                   , 'SEGMENT30', pea.segment30

                    ) bank_details_segment_value

           , pppm.effective_start_date effective_start_date

           , pppm.effective_end_date effective_end_date

           ,pppm.last_update_date lastupddt

        FROM pay_personal_payment_methods_f pppm

           , pay_org_payment_methods_f popm

           , pay_payment_types ppt

           , pay_external_accounts pea

           , (SELECT str.id_flex_code, str.id_flex_num

                   , seg.segment_name segment_name

                   , seg.application_column_name segment_column

                FROM fnd_id_flex_structures str

                   , fnd_id_flex_segments seg

                   , fnd_application appln

               WHERE str.id_flex_code = 'BANK'

                 AND str.enabled_flag = 'Y'

                 AND str.application_id = appln.application_id

                 AND appln.application_short_name = 'PAY'

                 AND str.application_id = seg.application_id

                 AND str.id_flex_code = seg.id_flex_code

                 AND str.id_flex_num = seg.id_flex_num

                 AND seg.enabled_flag = 'Y'

                 AND seg.display_flag = 'Y') bank_kff

           --, per_all_assignments_f paaf

      WHERE pppm.org_payment_method_id = popm.org_payment_method_id

         AND pppm.effective_start_date BETWEEN popm.effective_start_date

                                           AND popm.effective_end_date

         AND popm.payment_type_id = ppt.payment_type_id

         AND pppm.external_account_id = pea.external_account_id

         AND pea.id_flex_num = bank_kff.id_flex_num