DBA Data[Home] [Help]

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 3881: ,DECODE((SELECT offset_tax_flag FROM ap_supplier_sites_all ap_sup

3877: ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
3878: ,DECODE(taxes.tax_type_code,'OFFSET','Y','N') OFFSET_FLAG
3879: --,rates.OFFSET_TAX_RATE_CODE OFFSET_TAX_RATE_CODE
3880: -- Bug12986875
3881: ,DECODE((SELECT offset_tax_flag FROM ap_supplier_sites_all ap_sup
3882: WHERE ap_sup.vendor_site_id = inv.vendor_site_id),'Y',
3883: rates.offset_tax_rate_code, NULL) OFFSET_TAX_RATE_CODE
3884: ,NVL(rates.def_rec_settlement_option_code,
3885: taxes.def_rec_settlement_option_code) DEF_REC_SETTLEMENT_OPTION_CODE