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_BOX_ALLOCS

Line 724: jg_zz_vat_box_allocs AL

720: ,Jg.Tax_Recoverable_Flag
721: ,Jg.Tax_Recovery_Rate
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

Line 782: ,tax_box jg_zz_vat_box_allocs.tax_box%type

778: TYPE r_box_amounts IS RECORD
779: (
780: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
781: ,period_name jg_zz_vat_rep_status.tax_calendar_period%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)

Line 783: ,taxable_box jg_zz_vat_box_allocs.taxable_box%type --VARCHAR2(10)

779: (
780: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
781: ,period_name jg_zz_vat_rep_status.tax_calendar_period%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)

Line 799: ,allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%type -- NUMBER

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
803: ,Tax_Recovery_Rate Jg_Zz_Vat_Trx_Details.Tax_Recovery_Rate%Type

Line 811: ,vat_report_box jg_zz_vat_box_allocs.tax_box%type --VARCHAR2(10)

807: TYPE r_vatbox_amounts IS RECORD
808: (
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

Line 1113: , jg_zz_vat_box_allocs AllOCBOX

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
1116: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
1117: AND JZVRS.tax_calendar_year = p_period

Line 1344: , jg_zz_vat_box_allocs AL

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
1347: AND AL.vat_transaction_id = JG.vat_transaction_id
1348: AND AL.period_type = 'PERIODIC'