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 726: , jg_zz_vat_trx_details JG

722: ,zx.Record_Type_Code
723: FROM
724: jg_zz_vat_box_allocs AL
725: , jg_zz_vat_alloc_rules alr
726: , jg_zz_vat_trx_details JG
727: , fnd_lookup_values TLOOKUP
728: , fnd_lookup_values TBLLOOKUP
729: , Jg_Zz_Vat_Rep_Status Jzvrs
730: , ZX_lines zx

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

782: ,tax_box jg_zz_vat_box_allocs.tax_box%type
783: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
784: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
785: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
786: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
787: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
788: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
789: ,gl_date jg_zz_vat_trx_details.trx_date%type
790: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)

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

783: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)
784: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
785: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
786: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
787: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
788: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
789: ,gl_date jg_zz_vat_trx_details.trx_date%type
790: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
791: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)

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

784: ,taxablebox_description fnd_lookup_values.description%type --VARCHAR2(250)
785: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
786: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
787: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
788: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
789: ,gl_date jg_zz_vat_trx_details.trx_date%type
790: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
791: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
792: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)

Line 789: ,gl_date jg_zz_vat_trx_details.trx_date%type

785: ,taxbox_description fnd_lookup_values.description%type --VARCHAR2(250)
786: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
787: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
788: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
789: ,gl_date jg_zz_vat_trx_details.trx_date%type
790: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
791: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
792: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
793: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER

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

786: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
787: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
788: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
789: ,gl_date jg_zz_vat_trx_details.trx_date%type
790: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
791: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
792: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
793: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
794: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)

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

787: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
788: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
789: ,gl_date jg_zz_vat_trx_details.trx_date%type
790: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
791: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
792: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
793: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
794: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
795: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)

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

788: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
789: ,gl_date jg_zz_vat_trx_details.trx_date%type
790: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
791: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
792: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
793: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
794: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
795: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
796: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER

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

789: ,gl_date jg_zz_vat_trx_details.trx_date%type
790: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
791: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
792: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
793: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
794: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
795: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
796: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
797: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER

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

790: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
791: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
792: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
793: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
794: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
795: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
796: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
797: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
798: ,tax_line_id jg_zz_vat_trx_details.tax_line_id%type --NUMBER

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

791: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
792: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
793: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
794: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
795: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
796: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
797: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
798: ,tax_line_id jg_zz_vat_trx_details.tax_line_id%type --NUMBER
799: ,allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%type -- NUMBER

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

792: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
793: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
794: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
795: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
796: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
797: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
798: ,tax_line_id jg_zz_vat_trx_details.tax_line_id%type --NUMBER
799: ,allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%type -- NUMBER
800: ,cancel_flag jg_zz_vat_trx_details.cancel_flag%type

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

793: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
794: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
795: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
796: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
797: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
798: ,tax_line_id jg_zz_vat_trx_details.tax_line_id%type --NUMBER
799: ,allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%type -- NUMBER
800: ,cancel_flag jg_zz_vat_trx_details.cancel_flag%type
801: ,source_id jg_zz_vat_trx_details.taxable_item_source_id%type --Added for bug 11813288

Line 798: ,tax_line_id jg_zz_vat_trx_details.tax_line_id%type --NUMBER

794: ,vat_code jg_zz_vat_trx_details.tax_rate_Code%type --VARCHAR2(100)
795: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
796: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
797: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
798: ,tax_line_id jg_zz_vat_trx_details.tax_line_id%type --NUMBER
799: ,allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%type -- NUMBER
800: ,cancel_flag jg_zz_vat_trx_details.cancel_flag%type
801: ,source_id jg_zz_vat_trx_details.taxable_item_source_id%type --Added for bug 11813288
802: ,Tax_Recoverable_Flag Jg_Zz_Vat_Trx_Details.Tax_Recoverable_Flag%Type

Line 800: ,cancel_flag jg_zz_vat_trx_details.cancel_flag%type

796: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
797: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
798: ,tax_line_id jg_zz_vat_trx_details.tax_line_id%type --NUMBER
799: ,allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%type -- NUMBER
800: ,cancel_flag jg_zz_vat_trx_details.cancel_flag%type
801: ,source_id jg_zz_vat_trx_details.taxable_item_source_id%type --Added for bug 11813288
802: ,Tax_Recoverable_Flag Jg_Zz_Vat_Trx_Details.Tax_Recoverable_Flag%Type
803: ,Tax_Recovery_Rate Jg_Zz_Vat_Trx_Details.Tax_Recovery_Rate%Type
804: ,Record_Type_Code ZX_LINES.Record_Type_Code%type

Line 801: ,source_id jg_zz_vat_trx_details.taxable_item_source_id%type --Added for bug 11813288

797: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
798: ,tax_line_id jg_zz_vat_trx_details.tax_line_id%type --NUMBER
799: ,allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%type -- NUMBER
800: ,cancel_flag jg_zz_vat_trx_details.cancel_flag%type
801: ,source_id jg_zz_vat_trx_details.taxable_item_source_id%type --Added for bug 11813288
802: ,Tax_Recoverable_Flag Jg_Zz_Vat_Trx_Details.Tax_Recoverable_Flag%Type
803: ,Tax_Recovery_Rate Jg_Zz_Vat_Trx_Details.Tax_Recovery_Rate%Type
804: ,Record_Type_Code ZX_LINES.Record_Type_Code%type
805: );

Line 802: ,Tax_Recoverable_Flag Jg_Zz_Vat_Trx_Details.Tax_Recoverable_Flag%Type

798: ,tax_line_id jg_zz_vat_trx_details.tax_line_id%type --NUMBER
799: ,allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%type -- NUMBER
800: ,cancel_flag jg_zz_vat_trx_details.cancel_flag%type
801: ,source_id jg_zz_vat_trx_details.taxable_item_source_id%type --Added for bug 11813288
802: ,Tax_Recoverable_Flag Jg_Zz_Vat_Trx_Details.Tax_Recoverable_Flag%Type
803: ,Tax_Recovery_Rate Jg_Zz_Vat_Trx_Details.Tax_Recovery_Rate%Type
804: ,Record_Type_Code ZX_LINES.Record_Type_Code%type
805: );
806:

Line 803: ,Tax_Recovery_Rate Jg_Zz_Vat_Trx_Details.Tax_Recovery_Rate%Type

799: ,allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%type -- NUMBER
800: ,cancel_flag jg_zz_vat_trx_details.cancel_flag%type
801: ,source_id jg_zz_vat_trx_details.taxable_item_source_id%type --Added for bug 11813288
802: ,Tax_Recoverable_Flag Jg_Zz_Vat_Trx_Details.Tax_Recoverable_Flag%Type
803: ,Tax_Recovery_Rate Jg_Zz_Vat_Trx_Details.Tax_Recovery_Rate%Type
804: ,Record_Type_Code ZX_LINES.Record_Type_Code%type
805: );
806:
807: TYPE r_vatbox_amounts IS RECORD

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

809: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
810: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
811: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
812: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
813: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
814: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
815: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
816: ,gl_date jg_zz_vat_trx_details.accounting_date%type
817: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)

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

810: ,period_name jg_zz_vat_rep_status.tax_calendar_period%type --VARCHAR2(10)
811: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
812: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
813: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
814: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
815: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
816: ,gl_date jg_zz_vat_trx_details.accounting_date%type
817: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
818: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)

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

811: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)
812: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
813: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
814: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
815: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
816: ,gl_date jg_zz_vat_trx_details.accounting_date%type
817: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
818: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
819: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)

Line 816: ,gl_date jg_zz_vat_trx_details.accounting_date%type

812: ,vat_box_description fnd_lookup_values.description%type --VARCHAR2(250)
813: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
814: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
815: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
816: ,gl_date jg_zz_vat_trx_details.accounting_date%type
817: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
818: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
819: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
820: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER

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

813: ,source jg_zz_vat_trx_details.extract_source_ledger%type -- VARCHAR2(10)
814: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
815: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
816: ,gl_date jg_zz_vat_trx_details.accounting_date%type
817: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
818: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
819: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
820: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
821: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)

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

814: ,document_seq_name jg_zz_vat_trx_details.doc_seq_name%type -- VARCHAR2(60)
815: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
816: ,gl_date jg_zz_vat_trx_details.accounting_date%type
817: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
818: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
819: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
820: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
821: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
822: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)

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

815: ,document_seq_value jg_zz_vat_trx_details.doc_seq_value%type --NUMBER
816: ,gl_date jg_zz_vat_trx_details.accounting_date%type
817: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
818: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
819: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
820: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
821: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
822: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
823: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER

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

816: ,gl_date jg_zz_vat_trx_details.accounting_date%type
817: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
818: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
819: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
820: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
821: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
822: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
823: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
824: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER

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

817: ,trading_partner_number jg_zz_vat_trx_details.billing_tp_number%type -- VARCHAR2(240)
818: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
819: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
820: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
821: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
822: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
823: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
824: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
825: );

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

818: ,trading_partner_name jg_zz_vat_trx_details.billing_tp_name%type --VARCHAR2(240)
819: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
820: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
821: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
822: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
823: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
824: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
825: );
826:

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

819: ,invoice jg_zz_vat_trx_details.trx_number%type --VARCHAR2(60)
820: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
821: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
822: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
823: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
824: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
825: );
826:
827:

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

820: ,line_number jg_zz_vat_trx_details.trx_line_number%type --NUMBER
821: ,vat_code jg_zz_vat_trx_details.tax%type --VARCHAR2(100)
822: ,vat_transaction_type jg_zz_vat_trx_details.tax_rate_vat_trx_type_code%type --VARCHAR2(100)
823: ,taxable_amount jg_zz_vat_trx_details.taxable_amt%type --NUMBER
824: ,tax_amount jg_zz_vat_trx_details.tax_amt%type --NUMBER
825: );
826:
827:
828: TYPE t_box_amounts IS TABLE OF r_box_amounts

Line 1111: FROM jg_zz_vat_trx_details JG

1107: , JG.tax_recovery_rate TAX_RECV_RATE
1108: , ALLOCBOX.tax_recoverable_flag TAX_RECOVERABLE_FLAG
1109: , JG.extract_source_ledger EXTRACT_SOURCE_LEDGER
1110: , AllOCBOX.allocation_rule_id ALLOCATION_RULE_ID
1111: FROM jg_zz_vat_trx_details JG
1112: , jg_zz_vat_rep_status JZVRS
1113: , jg_zz_vat_box_allocs AllOCBOX
1114: , jg_zz_vat_alloc_rules ALLOCRUL
1115: WHERE JZVRS.reporting_status_id = JG.reporting_status_id

Line 1342: FROM jg_zz_vat_trx_details JG

1338: , DECODE(JG.application_id, 200,'I', 222,'O',
1339: 101,JG.prl_no) TAX_CLASS
1340: ,JG.extract_source_ledger EXTRACT_SOURCE_LEDGER
1341: ,JG.reporting_code REPORTING_CODE
1342: FROM jg_zz_vat_trx_details JG
1343: , jg_zz_vat_rep_status JZVRS
1344: , jg_zz_vat_box_allocs AL
1345: WHERE decode(JG.extract_source_ledger,'AP',NVL(JG.tax_recoverable_flag,'N'),'Y') ='Y' -- Bug 5561879
1346: AND JZVRS.reporting_status_id = JG.reporting_status_id

Line 1491: jg_zz_vat_trx_details JG

1487: , offset_flag OFFSET_FLAG
1488: , applied_to_trx_id APPLIED_TO_TRX_ID -- bug 12691340
1489: , JZVRS.mapping_vat_rep_entity_id MAPPING_VAT_REP_ENTITY_ID
1490: FROM
1491: jg_zz_vat_trx_details JG
1492: , jg_zz_vat_rep_status JZVRS
1493: WHERE JZVRS.reporting_status_id = JG.reporting_status_id
1494: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1495: AND JZVRS.tax_calendar_period = p_period ;

Line 1687: JG_ZZ_VAT_TRX_DETAILS JZVTD

1683: ,NVL(LPAD(SUBSTR(NVL(JZVTD.BILLING_TP_SITE_TAX_REG_NUM, JZVTD.BILLING_TP_TAX_REG_NUM),1,9),9,'0'),'000000000') TAX_REG_NUM_STANDARD
1684: ,SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_STANDARD
1685: ,SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_STANDARD
1686: FROM
1687: JG_ZZ_VAT_TRX_DETAILS JZVTD
1688: ,JG_ZZ_VAT_REP_STATUS JZVRS
1689: ,AP_INVOICES_ALL AP
1690: WHERE
1691: JZVRS.VAT_REPORTING_ENTITY_ID in

Line 1736: FROM JG_ZZ_VAT_TRX_DETAILS JZVTD,

1732: 19,TO_DATE(APINVL.GLOBAL_ATTRIBUTE13,'RRRR/MM/DD HH24:MI:SS'),
1733: TO_DATE(APINVL.GLOBAL_ATTRIBUTE13, 'DD-MM-RRRR')),'RRRRMMDD') IMP_DOC_DATE_IMPORT,
1734: SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_IMPORT,
1735: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_IMPORT
1736: FROM JG_ZZ_VAT_TRX_DETAILS JZVTD,
1737: JG_ZZ_VAT_REP_STATUS JZVRS,
1738: AP_INVOICES_ALL APINV,
1739: AP_INVOICE_LINES_ALL APINVL,
1740: ZX_LINES ZXL

Line 1788: FROM JG_ZZ_VAT_TRX_DETAILS JZVTD,

1784: NVL(APINV.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP,
1785: JZVTD.TRX_ID TRX_ID,
1786: SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT,
1787: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1788: FROM JG_ZZ_VAT_TRX_DETAILS JZVTD,
1789: JG_ZZ_VAT_REP_STATUS JZVRS,
1790: AP_INVOICES_ALL APINV
1791: WHERE JZVRS.SOURCE = 'AP'
1792: AND JZVRS.VAT_REPORTING_ENTITY_ID in

Line 1837: JG_ZZ_VAT_TRX_DETAILS JZVTD,

1833: DECODE(JZVTD.REPORTING_CODE, 'VAT-Y',NVL(ARL.GLOBAL_ATTRIBUTE1,'999999999'),JZVTD.BILLING_TP_TAXPAYER_ID) TAXPAYER_ID,
1834: DECODE(JZVTD.REPORTING_CODE, 'VAT-Y', 0, SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT))) VAT_AMOUNT,
1835: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1836: FROM
1837: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1838: JG_ZZ_VAT_REP_STATUS JZVRS,
1839: RA_CUSTOMER_TRX_ALL AR,
1840: RA_CUSTOMER_TRX_LINES_ALL ARL
1841: WHERE

Line 1883: JG_ZZ_VAT_TRX_DETAILS JZVTD,

1879: JZVTD.BILLING_TP_TAXPAYER_ID TAXPAYER_ID,
1880: DECODE(JZVTD.REPORTING_CODE, 'VAT-S', SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)) , 0) VAT_AMOUNT,
1881: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1882: FROM
1883: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1884: JG_ZZ_VAT_REP_STATUS JZVRS,
1885: RA_CUSTOMER_TRX_ALL AR
1886: WHERE
1887: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID

Line 1926: JG_ZZ_VAT_TRX_DETAILS JZVTD,

1922: DECODE(JZVTD.REPORTING_CODE, 'VAT-L', SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)),
1923: 'VAT-S', SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)), 0) VAT_AMOUNT,
1924: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1925: FROM
1926: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1927: JG_ZZ_VAT_REP_STATUS JZVRS,
1928: RA_CUSTOMER_TRX_ALL AR
1929: WHERE
1930: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID

Line 1974: JG_ZZ_VAT_TRX_DETAILS JZVTD,

1970: JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS,
1971: SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)) VAT_AMOUNT,
1972: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1973: FROM
1974: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1975: JG_ZZ_VAT_REP_STATUS JZVRS,
1976: RA_CUSTOMER_TRX_ALL AR
1977: WHERE
1978: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID

Line 2602: FROM jg_zz_vat_trx_details

2598: BEGIN
2599: IF p_func_curr = 'ITL' THEN
2600: SELECT SUM(tax_amt_funcl_curr)
2601: INTO invoice_values
2602: FROM jg_zz_vat_trx_details
2603: WHERE trx_id = p_cust_trx_id
2604: AND application_id = 200
2605: AND event_class_code = 'PURCHASE_TRANSACTION'
2606: AND entity_code = 'AP_INVOICES';

Line 2610: FROM jg_zz_vat_trx_details

2606: AND entity_code = 'AP_INVOICES';
2607: ELSE
2608: SELECT SUM(tax_amt)
2609: INTO invoice_values
2610: FROM jg_zz_vat_trx_details
2611: WHERE trx_id = p_cust_trx_id
2612: AND application_id = 200
2613: AND event_class_code = 'PURCHASE_TRANSACTION'
2614: AND entity_code = 'AP_INVOICES';