DBA Data[Home] [Help]

APPS.JG_ZZ_JOURNAL_AP_PKG dependencies on JG_ZZ_VAT_BOX_ALLOCS

Line 460: , jg_zz_vat_box_allocs JZVBA

456: ,NVL(JZVBA.taxable_box, '99') VAT_REPORT_BOX
457: ,NVL(JZVBA.tax_box, '99') TAX_BOX
458: FROM jg_zz_vat_trx_details JZVTD
459: , jg_zz_vat_rep_status JZVRS
460: , jg_zz_vat_box_allocs JZVBA
461: , jg_zz_vat_alloc_rules jzvar
462: WHERE JZVBA.PERIOD_TYPE = 'PERIODIC'
463: AND JZVRS.source = 'AP'
464: /* AND JZVTD.trx_line_class IN ('STANDARD','CREDIT','DEBIT','EXPENSE REPORT','PREPAYMENT' ) Bug#5235824 */

Line 1328: ,jg_zz_vat_box_allocs JZVBA

1324: ,JZVTD.actg_event_type_code AE_EVENT_TYPE_CODE
1325: ,JZVTD.trx_line_type TAXABLE_LINE_TYPE_CODE
1326: FROM jg_zz_vat_trx_details JZVTD
1327: ,jg_zz_vat_rep_status JZVRS
1328: ,jg_zz_vat_box_allocs JZVBA
1329: WHERE JZVRS.tax_calendar_period = P_PERIOD
1330: AND JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1331: AND JZVRS.source = 'AP'
1332: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id