DBA Data[Home] [Help]

APPS.JG_ZZ_JOURNAL_AP_PKG dependencies on JG_ZZ_VAT_BOX_ALLOCS

Line 521: , jg_zz_vat_box_allocs JZVBA

517: ,DECODE(JZVTD.OFFSET_FLAG,'N',DECODE(NVL(JZVTD.taxable_amt_funcl_curr,0),0
518: ,JZVTD.taxable_amt,JZVTD.taxable_amt_funcl_curr),0) TAXABLE_AMT_FOR_LAG
519: FROM jg_zz_vat_trx_details JZVTD
520: , jg_zz_vat_rep_status JZVRS
521: , jg_zz_vat_box_allocs JZVBA
522: , jg_zz_vat_alloc_rules jzvar
523: WHERE JZVBA.PERIOD_TYPE = 'PERIODIC'
524: AND JZVRS.source = 'AP'
525: /* AND JZVTD.trx_line_class IN ('STANDARD','CREDIT','DEBIT','EXPENSE REPORT','PREPAYMENT' ) Bug#5235824 */

Line 1524: ,jg_zz_vat_box_allocs JZVBA

1520: ,JZVTD.actg_event_type_code AE_EVENT_TYPE_CODE
1521: ,JZVTD.trx_line_type TAXABLE_LINE_TYPE_CODE
1522: FROM jg_zz_vat_trx_details JZVTD
1523: ,jg_zz_vat_rep_status JZVRS
1524: ,jg_zz_vat_box_allocs JZVBA
1525: WHERE JZVRS.tax_calendar_period = P_PERIOD
1526: AND JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1527: AND JZVRS.source = 'AP'
1528: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id