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_JOURNAL_AR_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 313: FROM jg_zz_vat_trx_details JZVTD

309: */
310:
311: SELECT count ( distinct JZVTD.trx_id )
312: INTO l_sequence_start
313: FROM jg_zz_vat_trx_details JZVTD
314: ,jg_zz_vat_rep_status JZVRS
315:
316: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
317: FROM jg_zz_vat_rep_status JZRS

Line 332: (select trx_date from jg_zz_vat_trx_details A

328: WHERE period_start_date < l_period_start_date
329: AND vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
330: AND source='AR')
331: AND trunc(l_period_start_date,'YYYY') <= all
332: (select trx_date from jg_zz_vat_trx_details A
333: where A.trx_id = JZVTD.trx_id );
334:
335: fnd_file.put_line(fnd_file.log,'l_sequence_start :'||l_sequence_start);
336:

Line 522: FROM jg_zz_vat_trx_details JZVTD

518: ,NVL(JZVTD.tax_amt_funcl_curr,0) * to_number(jzvar.tax_rec_sign_flag ||'1') TAX_AMOUNT --bug10103169
519: ,NVL(JZVTD.taxable_amt_funcl_curr,0) * to_number(jzvar.taxable_rec_sign_flag ||'1') TAXABLE_AMOUNT --bug10103169
520: ,NVL(JZVTD.taxable_amt_funcl_curr,0) * to_number(jzvar.taxable_rec_sign_flag ||'1') TAXABLE_AMT_FUN_CURR --bug10103169
521: ,NVL(JZVTD.tax_amt_funcl_curr,0) * to_number(jzvar.tax_rec_sign_flag ||'1') TAX_AMT_FUN_CURR --bug10103169
522: FROM jg_zz_vat_trx_details JZVTD
523: ,jg_zz_vat_rep_status JZVRS
524: ,jg_zz_vat_box_allocs JZVBA
525: ,ra_cust_trx_types RCTT
526: ,jg_zz_vat_alloc_rules jzvar

Line 665: FROM jg_zz_vat_trx_details JZVTD

661: ,JZVTD.posted_flag POSTED_FLAG
662: ,JZVTD.trx_currency_code TRX_CURRENCY_CODE
663: ,JZVTD.TRX_DUE_DATE TRX_DUE_DATE
664: ,JZVTD.ACCOUNTING_DATE ACCOUNTING_DATE
665: FROM jg_zz_vat_trx_details JZVTD
666: ,jg_zz_vat_registers_vl JZVRV
667: ,jg_zz_vat_rep_status JZVRS
668: ,jg_zz_vat_doc_sequences JZVDS
669: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id

Line 843: FROM jg_zz_vat_trx_details JZVTD

839: ,SUBSTR(JZVTD.billing_tp_name,1,90) PARTY_NAME
840: ,SUBSTR(JZVTD.billing_tp_name,1,22) VAT_REGISTER_NAME
841: ,JZVTD.posted_flag POSTED_FLAG
842: ,JZVTD.ACCOUNTING_DATE ACCOUNTING_DATE -- bug9872998
843: FROM jg_zz_vat_trx_details JZVTD
844: ,jg_zz_vat_registers_vl JZVRV
845: ,jg_zz_vat_rep_status JZVRS
846: ,ar_lookups LK
847: ,jg_zz_vat_doc_sequences JZVDS

Line 1017: FROM jg_zz_vat_trx_details JZVTD

1013: ,JZVTD.tax_rate_vat_trx_type_desc TAX_DESCRIPTION
1014: ,JZVTD.REPORTING_CODE REPORTING_CODE
1015: ,TAX_RATE_REGISTER_TYPE_CODE REGISTER_TYPE
1016: ,JZVTD.trx_line_id TRX_LINE_ID
1017: FROM jg_zz_vat_trx_details JZVTD
1018: ,jg_zz_vat_rep_status JZVRS
1019: -- ,fnd_lookup_values LK
1020: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
1021: FROM jg_zz_vat_rep_status JZRS