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
