VIEW: APPS.JAI_AP_TDS_SECTION_TAX_V

Source

View Text - Preformatted

SELECT b.lookup_type section_type, b.lookup_code section_code, b.meaning section_description, b.start_date_active start_date_section, b.end_date_active end_date_section, c.tax_id, c.tax_name, c.TAX_DESCR tax_description, c.tax_type, c.TAX_RATE, c.start_date start_date_tax, c.end_date end_date_tax, c.org_id FROM ja_lookups b, JAI_CMN_TAXES_ALL c WHERE b.lookup_type = 'JAI_AP_TDS_SECTION_TYPES' AND b.lookup_code = c.section_type

View Text - HTML Formatted

SELECT B.LOOKUP_TYPE SECTION_TYPE
, B.LOOKUP_CODE SECTION_CODE
, B.MEANING SECTION_DESCRIPTION
, B.START_DATE_ACTIVE START_DATE_SECTION
, B.END_DATE_ACTIVE END_DATE_SECTION
, C.TAX_ID
, C.TAX_NAME
, C.TAX_DESCR TAX_DESCRIPTION
, C.TAX_TYPE
, C.TAX_RATE
, C.START_DATE START_DATE_TAX
, C.END_DATE END_DATE_TAX
, C.ORG_ID
FROM JA_LOOKUPS B
, JAI_CMN_TAXES_ALL C
WHERE B.LOOKUP_TYPE = 'JAI_AP_TDS_SECTION_TYPES'
AND B.LOOKUP_CODE = C.SECTION_TYPE