DBA Data[Home] [Help]

APPS.JG_ZZ_JOURNAL_AR_PKG dependencies on JG_ZZ_VAT_DOC_SEQUENCES

Line 687: ,jg_zz_vat_doc_sequences JZVDS

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
689: AND JZVRV.vat_reporting_entity_id = JZVRS.mapping_vat_rep_entity_id
690: AND JZVDS.doc_sequence_id = JZVTD.doc_seq_id
691: AND JZVDS.vat_register_id = JZVRV.vat_register_id

Line 865: ,jg_zz_vat_doc_sequences JZVDS

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
866: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
867: AND JZVRS.tax_calendar_period = P_PERIOD
868: AND JZVRV.vat_register_id = P_VAT_REGISTER_ID
869: AND JZVRS.source = 'AR'