APPS.JG_ZZ_JOURNAL_AR_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 286: FROM jg_zz_vat_trx_details JZVTD

282: */
283:
284: SELECT count ( distinct JZVTD.trx_id )
285: INTO l_sequence_start
286: FROM jg_zz_vat_trx_details JZVTD
287: ,jg_zz_vat_rep_status JZVRS
288:
289: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
290: FROM jg_zz_vat_rep_status JZRS

Line 305: (select trx_date from jg_zz_vat_trx_details A

301: WHERE period_start_date < l_period_start_date
302: AND vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
303: AND source='AR')
304: AND trunc(l_period_start_date,'YYYY') <= all
305: (select trx_date from jg_zz_vat_trx_details A
306: where A.trx_id = JZVTD.trx_id );
307:
308: fnd_file.put_line(fnd_file.log,'l_sequence_start :'||l_sequence_start);
309:

Line 542: FROM jg_zz_vat_trx_details JZVTD

538: , 'Y', jzvar.tax_rec_sign_flag /* can be '+' or '-' */
539: ,jzvar.tax_non_rec_sign_flag
540: )||'1'
541: ) TAX_AMT_FUN_CURR
542: FROM jg_zz_vat_trx_details JZVTD
543: ,jg_zz_vat_rep_status JZVRS
544: ,jg_zz_vat_box_allocs JZVBA
545: ,ra_cust_trx_types RCTT
546: ,jg_zz_vat_alloc_rules jzvar

Line 684: FROM jg_zz_vat_trx_details JZVTD

680: ,JZVTD.posted_flag POSTED_FLAG
681: ,JZVTD.trx_currency_code TRX_CURRENCY_CODE
682: ,JZVTD.TRX_DUE_DATE TRX_DUE_DATE
683: ,JZVTD.ACCOUNTING_DATE ACCOUNTING_DATE
684: FROM jg_zz_vat_trx_details JZVTD
685: ,jg_zz_vat_registers_vl JZVRV
686: ,jg_zz_vat_rep_status JZVRS
687: ,jg_zz_vat_doc_sequences JZVDS
688: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id

Line 861: FROM jg_zz_vat_trx_details JZVTD

857: ,JZVTD.trx_line_id TRX_LINE_ID
858: ,SUBSTR(JZVTD.billing_tp_name,1,90) PARTY_NAME
859: ,SUBSTR(JZVTD.billing_tp_name,1,22) VAT_REGISTER_NAME
860: ,JZVTD.posted_flag POSTED_FLAG
861: FROM jg_zz_vat_trx_details JZVTD
862: ,jg_zz_vat_registers_vl JZVRV
863: ,jg_zz_vat_rep_status JZVRS
864: ,ar_lookups LK
865: ,jg_zz_vat_doc_sequences JZVDS

Line 1032: FROM jg_zz_vat_trx_details JZVTD

1028: ,JZVTD.tax_rate_vat_trx_type_desc TAX_DESCRIPTION
1029: ,JZVTD.REPORTING_CODE REPORTING_CODE
1030: ,TAX_RATE_REGISTER_TYPE_CODE REGISTER_TYPE
1031: ,JZVTD.trx_line_id TRX_LINE_ID
1032: FROM jg_zz_vat_trx_details JZVTD
1033: ,jg_zz_vat_rep_status JZVRS
1034: -- ,fnd_lookup_values LK
1035: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
1036: FROM jg_zz_vat_rep_status JZRS