JL_BR_AR_COLL_BATCHES_SAB

Details

Schema: FUSION
Object owner: JL
Object type: VIEW

Columns

Name
ROW_ID COLL_BATCH_ID SELECTION_CONTROL_ID BANK_ACCT_USE_ID COLL_BATCH_STATUS SEQUENTIAL_NUMBER_GENERATION TOTAL_COUNT TOTAL_AMOUNT SELECTION_DATE REMITTANCE_DATE REFUSED_DATE CANCELLATION_DATE COLLECTION_DATE WRITE_OFF_DATE DATE_IN_RECEIPT RECEIVED_DATE OUTPUT_PROGRAM_ID SELECT_ACCOUNT_ID OUTPUT_FORMAT OUTPUT_FORMAT_DSP FORMAT_DATE ORG_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN COLL_BATCH_STATUS_DSP OBJECT_VERSION_NUMBER

Name

ROW_ID

COLL_BATCH_ID

SELECTION_CONTROL_ID

BANK_ACCT_USE_ID

COLL_BATCH_STATUS

SEQUENTIAL_NUMBER_GENERATION

TOTAL_COUNT

TOTAL_AMOUNT

SELECTION_DATE

REMITTANCE_DATE

REFUSED_DATE

CANCELLATION_DATE

COLLECTION_DATE

WRITE_OFF_DATE

DATE_IN_RECEIPT

RECEIVED_DATE

OUTPUT_PROGRAM_ID

SELECT_ACCOUNT_ID

OUTPUT_FORMAT

OUTPUT_FORMAT_DSP

FORMAT_DATE

ORG_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

COLL_BATCH_STATUS_DSP

OBJECT_VERSION_NUMBER

Query

SQL_Statement
SELECT B.ROWID ROW_ID , B.COLL_BATCH_ID COLL_BATCH_ID , B.SELECTION_CONTROL_ID SELECTION_CONTROL_ID , B.BANK_ACCT_USE_ID BANK_ACCT_USE_ID , B.COLL_BATCH_STATUS COLL_BATCH_STATUS , B.SEQUENTIAL_NUMBER_GENERATION SEQUENTIAL_NUMBER_GENERATION , B.TOTAL_COUNT TOTAL_COUNT , B.TOTAL_AMOUNT TOTAL_AMOUNT , B.SELECTION_DATE SELECTION_DATE , B.REMITTANCE_DATE REMITTANCE_DATE , B.REFUSED_DATE REFUSED_DATE , B.CANCELLATION_DATE CANCELLATION_DATE , B.COLLECTION_DATE COLLECTION_DATE , B.WRITE_OFF_DATE WRITE_OFF_DATE , B.DATE_IN_RECEIPT DATE_IN_RECEIPT , B.RECEIVED_DATE RECEIVED_DATE , B.OUTPUT_PROGRAM_ID OUTPUT_PROGRAM_ID , B.SELECT_ACCOUNT_ID SELECT_ACCOUNT_ID , B.OUTPUT_FORMAT OUTPUT_FORMAT , LV1.MEANING OUTPUT_FORMAT_DSP , B.FORMAT_DATE FORMAT_DATE, B.ORG_ID ORG_ID , B.LAST_UPDATE_DATE LAST_UPDATE_DATE , B.LAST_UPDATED_BY LAST_UPDATED_BY , B.CREATION_DATE CREATION_DATE , B.CREATED_BY CREATED_BY , B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , LV2.MEANING COLL_BATCH_STATUS_DSP ,B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM JL_BR_AR_COLL_BATCHES B , FND_LOOKUPS LV1, FND_LOOKUPS LV2 WHERE LV1.LOOKUP_CODE (+) = B.OUTPUT_FORMAT AND LV1.LOOKUP_TYPE = 'JLBR_AR_REMITTANCE_MEDIA' AND LV1.ENABLED_FLAG = 'Y' AND NVL(LV1.START_DATE_ACTIVE,SYSDATE) <= SYSDATE AND NVL(LV1.END_DATE_ACTIVE,SYSDATE) >= SYSDATE AND LV2.LOOKUP_CODE (+) = B.COLL_BATCH_STATUS AND B.COLL_BATCH_STATUS <> 'CANCELED' AND LV2.LOOKUP_TYPE (+) = 'JLBR_AR_BORDERO_STATUS' AND LV2.ENABLED_FLAG = 'Y' AND NVL(LV2.START_DATE_ACTIVE,SYSDATE) <= SYSDATE AND NVL(LV2.END_DATE_ACTIVE,SYSDATE) >= SYSDATE

SQL_Statement

SELECT B.ROWID ROW_ID , B.COLL_BATCH_ID COLL_BATCH_ID , B.SELECTION_CONTROL_ID SELECTION_CONTROL_ID , B.BANK_ACCT_USE_ID BANK_ACCT_USE_ID , B.COLL_BATCH_STATUS COLL_BATCH_STATUS , B.SEQUENTIAL_NUMBER_GENERATION SEQUENTIAL_NUMBER_GENERATION , B.TOTAL_COUNT TOTAL_COUNT , B.TOTAL_AMOUNT TOTAL_AMOUNT , B.SELECTION_DATE SELECTION_DATE , B.REMITTANCE_DATE REMITTANCE_DATE , B.REFUSED_DATE REFUSED_DATE , B.CANCELLATION_DATE CANCELLATION_DATE , B.COLLECTION_DATE COLLECTION_DATE , B.WRITE_OFF_DATE WRITE_OFF_DATE , B.DATE_IN_RECEIPT DATE_IN_RECEIPT , B.RECEIVED_DATE RECEIVED_DATE , B.OUTPUT_PROGRAM_ID OUTPUT_PROGRAM_ID

, B.SELECT_ACCOUNT_ID SELECT_ACCOUNT_ID , B.OUTPUT_FORMAT OUTPUT_FORMAT , LV1.MEANING OUTPUT_FORMAT_DSP , B.FORMAT_DATE FORMAT_DATE, B.ORG_ID ORG_ID , B.LAST_UPDATE_DATE LAST_UPDATE_DATE , B.LAST_UPDATED_BY LAST_UPDATED_BY , B.CREATION_DATE CREATION_DATE , B.CREATED_BY CREATED_BY , B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,

LV2.MEANING COLL_BATCH_STATUS_DSP

,B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER

FROM JL_BR_AR_COLL_BATCHES B

, FND_LOOKUPS LV1, FND_LOOKUPS LV2

WHERE LV1.LOOKUP_CODE (+) = B.OUTPUT_FORMAT AND LV1.LOOKUP_TYPE = 'JLBR_AR_REMITTANCE_MEDIA' AND LV1.ENABLED_FLAG = 'Y' AND NVL(LV1.START_DATE_ACTIVE,SYSDATE) <= SYSDATE AND NVL(LV1.END_DATE_ACTIVE,SYSDATE) >= SYSDATE

AND LV2.LOOKUP_CODE (+) = B.COLL_BATCH_STATUS

AND B.COLL_BATCH_STATUS <> 'CANCELED'

AND LV2.LOOKUP_TYPE (+) = 'JLBR_AR_BORDERO_STATUS'

AND LV2.ENABLED_FLAG = 'Y' AND NVL(LV2.START_DATE_ACTIVE,SYSDATE) <= SYSDATE AND NVL(LV2.END_DATE_ACTIVE,SYSDATE) >= SYSDATE