JL_BR_AR_BORDEROS_SAB

Details

Schema: FUSION
Object owner: JL
Object type: VIEW

Columns

Name
ROW_ID BORDERO_ID SELECTION_CONTROL_ID BANK_ACCT_USE_ID BORDERO_STATUS SEQUENTIAL_NUMBER_GENERATION BORDERO_TYPE 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 ORG_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN BORDERO_TYPE_DSP BORDERO_STATUS_DSP OBJECT_VERSION_NUMBER

Name

ROW_ID

BORDERO_ID

SELECTION_CONTROL_ID

BANK_ACCT_USE_ID

BORDERO_STATUS

SEQUENTIAL_NUMBER_GENERATION

BORDERO_TYPE

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

ORG_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

BORDERO_TYPE_DSP

BORDERO_STATUS_DSP

OBJECT_VERSION_NUMBER

Query

SQL_Statement
SELECT B.ROWID ROW_ID , B.BORDERO_ID BORDERO_ID , B.SELECTION_CONTROL_ID SELECTION_CONTROL_ID , B.BANK_ACCT_USE_ID BANK_ACCT_USE_ID , B.BORDERO_STATUS BORDERO_STATUS , B.SEQUENTIAL_NUMBER_GENERATION SEQUENTIAL_NUMBER_GENERATION , B.BORDERO_TYPE BORDERO_TYPE , 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.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 , LV.MEANING BORDERO_TYPE_DSP , LV2.MEANING BORDERO_STATUS_DSP ,B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM JL_BR_AR_BORDEROS B , FND_LOOKUPS LV, FND_LOOKUPS LV1, FND_LOOKUPS LV2 WHERE LV.LOOKUP_CODE = B.BORDERO_TYPE AND B.BORDERO_TYPE IN ('COLLECTION','FACTORING') AND LV.LOOKUP_TYPE = 'JLBR_AR_BORDERO_TYPE' AND LV.ENABLED_FLAG = 'Y' AND NVL(LV.START_DATE_ACTIVE,SYSDATE) <= SYSDATE AND NVL(LV.END_DATE_ACTIVE,SYSDATE) >= SYSDATE AND 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.BORDERO_STATUS AND B.BORDERO_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.BORDERO_ID BORDERO_ID , B.SELECTION_CONTROL_ID SELECTION_CONTROL_ID , B.BANK_ACCT_USE_ID BANK_ACCT_USE_ID , B.BORDERO_STATUS BORDERO_STATUS , B.SEQUENTIAL_NUMBER_GENERATION SEQUENTIAL_NUMBER_GENERATION , B.BORDERO_TYPE BORDERO_TYPE , 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.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 , LV.MEANING BORDERO_TYPE_DSP , LV2.MEANING BORDERO_STATUS_DSP

,B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER

FROM JL_BR_AR_BORDEROS B

, FND_LOOKUPS LV, FND_LOOKUPS LV1, FND_LOOKUPS LV2 WHERE LV.LOOKUP_CODE = B.BORDERO_TYPE AND B.BORDERO_TYPE IN ('COLLECTION','FACTORING') AND LV.LOOKUP_TYPE = 'JLBR_AR_BORDERO_TYPE' AND LV.ENABLED_FLAG = 'Y' AND NVL(LV.START_DATE_ACTIVE,SYSDATE) <= SYSDATE AND NVL(LV.END_DATE_ACTIVE,SYSDATE) >= SYSDATE AND 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.BORDERO_STATUS AND B.BORDERO_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