DBA Data[Home] [Help]

VIEW: JL.JL_BR_AR_BORDEROS_ALL#

Source

View Text - Preformatted

select BORDERO_ID BORDERO_ID, SELECTION_CONTROL_ID SELECTION_CONTROL_ID, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, BORDERO_STATUS BORDERO_STATUS, SEQUENTIAL_NUMBER_GENERATION SEQUENTIAL_NUMBER_GENERATION, BORDERO_TYPE BORDERO_TYPE, TOTAL_COUNT TOTAL_COUNT, TOTAL_AMOUNT TOTAL_AMOUNT, SELECTION_DATE SELECTION_DATE, REMITTANCE_DATE REMITTANCE_DATE, REFUSED_DATE REFUSED_DATE, CANCELLATION_DATE CANCELLATION_DATE, COLLECTION_DATE COLLECTION_DATE, WRITE_OFF_DATE WRITE_OFF_DATE, DATE_IN_RECEIPT DATE_IN_RECEIPT, RECEIVED_DATE RECEIVED_DATE, OUTPUT_PROGRAM_ID OUTPUT_PROGRAM_ID, SELECT_ACCOUNT_ID SELECT_ACCOUNT_ID, OUTPUT_FORMAT OUTPUT_FORMAT, ORG_ID ORG_ID, 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, BANK_ACCT_USE_ID BANK_ACCT_USE_ID from "JL"."JL_BR_AR_BORDEROS_ALL"
View Text - HTML Formatted

SELECT BORDERO_ID BORDERO_ID
, SELECTION_CONTROL_ID SELECTION_CONTROL_ID
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, BORDERO_STATUS BORDERO_STATUS
, SEQUENTIAL_NUMBER_GENERATION SEQUENTIAL_NUMBER_GENERATION
, BORDERO_TYPE BORDERO_TYPE
, TOTAL_COUNT TOTAL_COUNT
, TOTAL_AMOUNT TOTAL_AMOUNT
, SELECTION_DATE SELECTION_DATE
, REMITTANCE_DATE REMITTANCE_DATE
, REFUSED_DATE REFUSED_DATE
, CANCELLATION_DATE CANCELLATION_DATE
, COLLECTION_DATE COLLECTION_DATE
, WRITE_OFF_DATE WRITE_OFF_DATE
, DATE_IN_RECEIPT DATE_IN_RECEIPT
, RECEIVED_DATE RECEIVED_DATE
, OUTPUT_PROGRAM_ID OUTPUT_PROGRAM_ID
, SELECT_ACCOUNT_ID SELECT_ACCOUNT_ID
, OUTPUT_FORMAT OUTPUT_FORMAT
, ORG_ID ORG_ID
, 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
, BANK_ACCT_USE_ID BANK_ACCT_USE_ID
FROM "JL"."JL_BR_AR_BORDEROS_ALL"