SELECT jg_info_v1 ven_name
,jg_info_v2 ven_no
,jg_info_v3 inv_type
,jg_info_n1 tax_amt
,jg_info_n2 rec_per
,jg_info_v4 company
,jg_info_v5 acc_no
,jg_info_n3 tax_rate
,jg_info_v6 tax_id
,jg_info_v7 offset_tax_rate_code
,jg_info_v8 tax_type
,jg_info_v9 inv_no
,TO_CHAR(jg_info_d1,'DD-MON-RRRR') acc_date
,jg_info_n4 invoice_id
,TO_CHAR(jg_info_d2,'DD-MON-RRRR') cancelled_date
,jg_info_n5 item_line_cnt
,jg_info_n6 charge_dist_id
,TO_CHAR(jg_info_d3,'DD-MON-RRRR') check_void_date
,jg_info_n7 pay_amt
,jg_info_v10 line_type_lookup_code
,jg_info_v11 line_type_lookup_code_item
,jg_info_v12 line_type_lookup_code_prepay
,jg_info_v13 reversal_flag_item
,jg_info_v14 reversal_flag_pay
,jg_info_v15 reversal_flag_prepay
,jg_info_n8 parent_reversal_id
,jg_info_n9 base_amount
,jg_info_n10 invoice_amount
,TO_CHAR(jg_info_d4,'DD-MON-RRRR') void_date
,TO_CHAR(jg_info_d5,'DD-MON-RRRR') future_pay_due_date
,TO_CHAR(jg_info_d6,'DD-MON-RRRR') check_date
,jg_info_v16 payment_status_flag
,TO_CHAR(jg_info_d7,'DD-MON-RRRR') accounting_date
,jg_info_n11 reversal_inv_pmt_id
,jg_info_v17 c_company
FROM JG_ZZ_VAT_TRX_GT JVGT
WHERE (jg_info_v30 is null or jg_info_v30 <> 'H')
--AND DECODE('''' || :P_COMPANY || '''', NULL, ' 1 ', jg_info_v10 ) = DECODE('''' || :P_COMPANY || '''', --NULL, ' 1 ', '''' || :P_COMPANY || '''')
ORDER BY company
,tax_type
,tax_rate
,acc_no
,rec_per
,tax_amt |
