DBA Data[Home] [Help]

APPS.JG_ZZ_JOURNAL_AR_PKG dependencies on JG_ZZ_VAT_DOC_SEQUENCES

Line 668: ,jg_zz_vat_doc_sequences JZVDS

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
670: AND JZVRV.vat_reporting_entity_id = JZVRS.mapping_vat_rep_entity_id
671: AND JZVDS.doc_sequence_id = JZVTD.doc_seq_id
672: AND JZVDS.vat_register_id = JZVRV.vat_register_id

Line 847: ,jg_zz_vat_doc_sequences JZVDS

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
848: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
849: AND JZVRS.tax_calendar_period = P_PERIOD
850: AND JZVRV.vat_register_id = P_VAT_REGISTER_ID
851: AND JZVRS.source = 'AR'