VIEW: JL.JL_BR_AR_SELECT_CONTROLS_ALL#

Source

View Text - Preformatted

select SELECTION_CONTROL_ID SELECTION_CONTROL_ID, SELECTION_STATUS SELECTION_STATUS, SELECTION_TYPE SELECTION_TYPE, NAME NAME, BORDERO_TYPE BORDERO_TYPE, SELECTION_DATE SELECTION_DATE, CANCELLATION_DATE CANCELLATION_DATE, GENERATION_DATE GENERATION_DATE, REMITTANCE_DATE REMITTANCE_DATE, DUE_DATE_BREAK_FLAG DUE_DATE_BREAK_FLAG, INITIAL_DUE_DATE INITIAL_DUE_DATE, FINAL_DUE_DATE FINAL_DUE_DATE, INITIAL_TRX_DATE INITIAL_TRX_DATE, FINAL_TRX_DATE FINAL_TRX_DATE, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, INITIAL_TRX_NUMBER INITIAL_TRX_NUMBER, FINAL_TRX_NUMBER FINAL_TRX_NUMBER, INITIAL_CUSTOMER_NUMBER INITIAL_CUSTOMER_NUMBER, FINAL_CUSTOMER_NUMBER FINAL_CUSTOMER_NUMBER, REQUEST_ID REQUEST_ID, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, INITIAL_TRX_AMOUNT INITIAL_TRX_AMOUNT, FINAL_TRX_AMOUNT FINAL_TRX_AMOUNT, ORG_ID ORG_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "JL"."JL_BR_AR_SELECT_CONTROLS_ALL"

View Text - HTML Formatted

SELECT SELECTION_CONTROL_ID SELECTION_CONTROL_ID
, SELECTION_STATUS SELECTION_STATUS
, SELECTION_TYPE SELECTION_TYPE
, NAME NAME
, BORDERO_TYPE BORDERO_TYPE
, SELECTION_DATE SELECTION_DATE
, CANCELLATION_DATE CANCELLATION_DATE
, GENERATION_DATE GENERATION_DATE
, REMITTANCE_DATE REMITTANCE_DATE
, DUE_DATE_BREAK_FLAG DUE_DATE_BREAK_FLAG
, INITIAL_DUE_DATE INITIAL_DUE_DATE
, FINAL_DUE_DATE FINAL_DUE_DATE
, INITIAL_TRX_DATE INITIAL_TRX_DATE
, FINAL_TRX_DATE FINAL_TRX_DATE
, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, INITIAL_TRX_NUMBER INITIAL_TRX_NUMBER
, FINAL_TRX_NUMBER FINAL_TRX_NUMBER
, INITIAL_CUSTOMER_NUMBER INITIAL_CUSTOMER_NUMBER
, FINAL_CUSTOMER_NUMBER FINAL_CUSTOMER_NUMBER
, REQUEST_ID REQUEST_ID
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, INITIAL_TRX_AMOUNT INITIAL_TRX_AMOUNT
, FINAL_TRX_AMOUNT FINAL_TRX_AMOUNT
, ORG_ID ORG_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "JL"."JL_BR_AR_SELECT_CONTROLS_ALL"