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 541: jg_zz_vat_box_allocs AL

537: decode(jg.tax_recoverable_flag, 'Y',
538: alr.tax_rec_sign_flag, alr.tax_non_rec_sign_flag) || '1',
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

Line 588: ,tax_box jg_zz_vat_box_allocs.tax_box%type

584: TYPE r_box_amounts IS RECORD
585: (
586: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
587: ,period_name jg_zz_vat_rep_status.tax_calendar_period%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)

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

585: (
586: period_year jg_zz_vat_rep_status.tax_calendar_year%type --NUMBER
587: ,period_name jg_zz_vat_rep_status.tax_calendar_period%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)

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

606: TYPE r_vatbox_amounts IS RECORD
607: (
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

Line 846: , jg_zz_vat_box_allocs AllOCBOX

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

Line 1077: , jg_zz_vat_box_allocs AL

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