VIEW: JA.JAI_CMN_CUS_ADDRESSES#

Source

View Text - Preformatted

select CUSTOMER_ID CUSTOMER_ID, ADDRESS_ID ADDRESS_ID, PAN_NO PAN_NO, TAN_NO TAN_NO, EXCISE_DUTY_REGION EXCISE_DUTY_REGION, EXCISE_DUTY_ZONE EXCISE_DUTY_ZONE, EXCISE_DUTY_REG_NO EXCISE_DUTY_REG_NO, EXCISE_DUTY_RANGE EXCISE_DUTY_RANGE, EXCISE_DUTY_DIVISION EXCISE_DUTY_DIVISION, EXCISE_DUTY_CIRCLE EXCISE_DUTY_CIRCLE, EXCISE_DUTY_COMM EXCISE_DUTY_COMM, TAX_CATEGORY_LIST TAX_CATEGORY_LIST, PRICE_LIST_ID PRICE_LIST_ID, ST_REG_NO ST_REG_NO, CST_REG_NO CST_REG_NO, EC_CODE EC_CODE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EXEMPT EXEMPT, VAT_REG_NO VAT_REG_NO, SERVICE_TAX_REGNO SERVICE_TAX_REGNO, VAT_PRICE_LIST_ID VAT_PRICE_LIST_ID, CUSTOMER_ADDRESS_ID CUSTOMER_ADDRESS_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CONFIRM_PAN CONFIRM_PAN, SERVICE_TYPE_CODE SERVICE_TYPE_CODE, TCS_CUSTOMER_TYPE TCS_CUSTOMER_TYPE, STATE_CODE STATE_CODE, GST_ASSESSABLE_PRICE GST_ASSESSABLE_PRICE, GST_REGISTRATION_NO GST_REGISTRATION_NO, CUSTOMER_TYPE CUSTOMER_TYPE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10 from "JA"."JAI_CMN_CUS_ADDRESSES"

View Text - HTML Formatted

SELECT CUSTOMER_ID CUSTOMER_ID
, ADDRESS_ID ADDRESS_ID
, PAN_NO PAN_NO
, TAN_NO TAN_NO
, EXCISE_DUTY_REGION EXCISE_DUTY_REGION
, EXCISE_DUTY_ZONE EXCISE_DUTY_ZONE
, EXCISE_DUTY_REG_NO EXCISE_DUTY_REG_NO
, EXCISE_DUTY_RANGE EXCISE_DUTY_RANGE
, EXCISE_DUTY_DIVISION EXCISE_DUTY_DIVISION
, EXCISE_DUTY_CIRCLE EXCISE_DUTY_CIRCLE
, EXCISE_DUTY_COMM EXCISE_DUTY_COMM
, TAX_CATEGORY_LIST TAX_CATEGORY_LIST
, PRICE_LIST_ID PRICE_LIST_ID
, ST_REG_NO ST_REG_NO
, CST_REG_NO CST_REG_NO
, EC_CODE EC_CODE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EXEMPT EXEMPT
, VAT_REG_NO VAT_REG_NO
, SERVICE_TAX_REGNO SERVICE_TAX_REGNO
, VAT_PRICE_LIST_ID VAT_PRICE_LIST_ID
, CUSTOMER_ADDRESS_ID CUSTOMER_ADDRESS_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CONFIRM_PAN CONFIRM_PAN
, SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, TCS_CUSTOMER_TYPE TCS_CUSTOMER_TYPE
, STATE_CODE STATE_CODE
, GST_ASSESSABLE_PRICE GST_ASSESSABLE_PRICE
, GST_REGISTRATION_NO GST_REGISTRATION_NO
, CUSTOMER_TYPE CUSTOMER_TYPE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
FROM "JA"."JAI_CMN_CUS_ADDRESSES"