DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on AP_SUPPLIER_SITES_ALL

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

1899: ,'N' COMPOUNDING_TAX_FLAG
1900: ,DECODE(taxes.tax_type_code,'OFFSET','Y','N') OFFSET_FLAG --Bug 8303411
1901: --,rates.OFFSET_TAX_RATE_CODE OFFSET_TAX_RATE_CODE
1902: -- Bug12986875
1903: ,DECODE((SELECT offset_tax_flag FROM ap_supplier_sites_all ap_sup
1904: WHERE ap_sup.vendor_site_id = inv.vendor_site_id),'Y',
1905: rates.offset_tax_rate_code, NULL) OFFSET_TAX_RATE_CODE
1906: ,ap_dists.DETAIL_TAX_DIST_ID REC_NREC_TAX_DIST_ID
1907: ,ap_dists.line_type_lookup_code AP_DIST_LOOKUP_CODE