eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 543: , jg_zz_vat_trx_details JG

539: alr.tax_rec_sign_flag || '1')) TAX_AMOUNT
540: FROM
541: jg_zz_vat_box_allocs AL
542: , jg_zz_vat_alloc_rules alr
543: , jg_zz_vat_trx_details JG
544: , fnd_lookup_values TLOOKUP
545: , fnd_lookup_values TBLLOOKUP
546: , jg_zz_vat_rep_status JZVRS
547: WHERE

Line 592: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)

588: ,tax_box jg_zz_vat_box_allocs.tax_box%type
589: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
590: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
591: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
592: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
593: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
594: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
595: ,gl_date jg_zz_vat_trx_details.trx_date%type
596: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)

Line 593: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)

589: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
590: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
591: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
592: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
593: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
594: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
595: ,gl_date jg_zz_vat_trx_details.trx_date%type
596: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
597: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)

Line 594: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER

590: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
591: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
592: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
593: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
594: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
595: ,gl_date jg_zz_vat_trx_details.trx_date%type
596: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
597: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
598: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)

Line 595: ,gl_date jg_zz_vat_trx_details.trx_date%type

591: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
592: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
593: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
594: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
595: ,gl_date jg_zz_vat_trx_details.trx_date%type
596: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
597: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
598: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
599: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER

Line 596: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)

592: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
593: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
594: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
595: ,gl_date jg_zz_vat_trx_details.trx_date%type
596: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
597: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
598: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
599: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
600: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)

Line 597: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)

593: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
594: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
595: ,gl_date jg_zz_vat_trx_details.trx_date%type
596: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
597: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
598: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
599: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
600: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
601: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)

Line 598: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)

594: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
595: ,gl_date jg_zz_vat_trx_details.trx_date%type
596: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
597: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
598: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
599: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
600: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
601: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
602: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER

Line 599: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER

595: ,gl_date jg_zz_vat_trx_details.trx_date%type
596: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
597: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
598: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
599: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
600: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
601: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
602: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
603: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER

Line 600: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)

596: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
597: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
598: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
599: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
600: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
601: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
602: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
603: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
604: );

Line 601: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)

597: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
598: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
599: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
600: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
601: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
602: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
603: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
604: );
605:

Line 602: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER

598: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
599: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
600: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
601: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
602: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
603: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
604: );
605:
606: TYPE r_vatbox_amounts IS RECORD

Line 603: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER

599: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
600: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
601: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
602: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
603: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
604: );
605:
606: TYPE r_vatbox_amounts IS RECORD
607: (

Line 612: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)

608: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
609: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
610: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
611: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
612: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
613: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
614: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
615: ,gl_date jg_zz_vat_trx_details.accounting_date%type
616: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)

Line 613: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)

609: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
610: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
611: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
612: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
613: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
614: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
615: ,gl_date jg_zz_vat_trx_details.accounting_date%type
616: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
617: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)

Line 614: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER

610: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
611: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
612: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
613: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
614: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
615: ,gl_date jg_zz_vat_trx_details.accounting_date%type
616: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
617: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
618: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)

Line 615: ,gl_date jg_zz_vat_trx_details.accounting_date%type

611: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
612: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
613: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
614: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
615: ,gl_date jg_zz_vat_trx_details.accounting_date%type
616: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
617: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
618: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
619: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER

Line 616: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)

612: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
613: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
614: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
615: ,gl_date jg_zz_vat_trx_details.accounting_date%type
616: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
617: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
618: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
619: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
620: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)

Line 617: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)

613: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
614: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
615: ,gl_date jg_zz_vat_trx_details.accounting_date%type
616: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
617: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
618: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
619: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
620: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
621: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)

Line 618: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)

614: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
615: ,gl_date jg_zz_vat_trx_details.accounting_date%type
616: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
617: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
618: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
619: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
620: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
621: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
622: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER

Line 619: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER

615: ,gl_date jg_zz_vat_trx_details.accounting_date%type
616: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
617: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
618: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
619: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
620: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
621: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
622: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
623: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER

Line 620: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)

616: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
617: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
618: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
619: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
620: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
621: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
622: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
623: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
624: );

Line 621: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)

617: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
618: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
619: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
620: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
621: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
622: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
623: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
624: );
625:

Line 622: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER

618: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
619: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
620: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
621: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
622: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
623: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
624: );
625:
626:

Line 623: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER

619: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
620: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
621: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
622: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
623: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
624: );
625:
626:
627: TYPE t_box_amounts IS TABLE OF r_box_amounts

Line 844: FROM jg_zz_vat_trx_details JG

840: , JG.tax_recovery_rate TAX_RECV_RATE
841: , ALLOCBOX.tax_recoverable_flag TAX_RECOVERABLE_FLAG
842: , JG.extract_source_ledger EXTRACT_SOURCE_LEDGER
843: , AllOCBOX.allocation_rule_id ALLOCATION_RULE_ID
844: FROM jg_zz_vat_trx_details JG
845: , jg_zz_vat_rep_status JZVRS
846: , jg_zz_vat_box_allocs AllOCBOX
847: , jg_zz_vat_alloc_rules ALLOCRUL
848: WHERE JZVRS.reporting_status_id = JG.reporting_status_id

Line 1075: FROM jg_zz_vat_trx_details JG

1071: , DECODE(JG.application_id, 200,'I', 222,'O',
1072: 101,JG.prl_no) TAX_CLASS
1073: ,JG.extract_source_ledger EXTRACT_SOURCE_LEDGER
1074: ,JG.reporting_code REPORTING_CODE
1075: FROM jg_zz_vat_trx_details JG
1076: , jg_zz_vat_rep_status JZVRS
1077: , jg_zz_vat_box_allocs AL
1078: WHERE decode(JG.extract_source_ledger,'AP',NVL(JG.tax_recoverable_flag,'N'),'Y') ='Y' -- Bug 5561879
1079: AND JZVRS.reporting_status_id = JG.reporting_status_id

Line 1220: jg_zz_vat_trx_details JG

1216: , trx_number TRX_NUMBER
1217: , DECODE(credit_balance_amt,NULL,0,credit_balance_amt) CREDIT_BALANCE_AMT
1218: , assessable_value ASSESSABLE_VALUE
1219: FROM
1220: jg_zz_vat_trx_details JG
1221: , jg_zz_vat_rep_status JZVRS
1222: WHERE JZVRS.reporting_status_id = JG.reporting_status_id
1223: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1224: AND JZVRS.tax_calendar_period = p_period ;

Line 1374: FROM jg_zz_vat_trx_details

1370: BEGIN
1371: IF p_func_curr = 'ITL' THEN
1372: SELECT SUM(tax_amt_funcl_curr)
1373: INTO invoice_values
1374: FROM jg_zz_vat_trx_details
1375: WHERE trx_id = p_cust_trx_id
1376: AND application_id = 200
1377: AND event_class_code = 'PURCHASE_TRANSACTION'
1378: AND entity_code = 'AP_INVOICES';

Line 1382: FROM jg_zz_vat_trx_details

1378: AND entity_code = 'AP_INVOICES';
1379: ELSE
1380: SELECT SUM(tax_amt)
1381: INTO invoice_values
1382: FROM jg_zz_vat_trx_details
1383: WHERE trx_id = p_cust_trx_id
1384: AND application_id = 200
1385: AND event_class_code = 'PURCHASE_TRANSACTION'
1386: AND entity_code = 'AP_INVOICES';