VIEW: APPS.JL_BR_AR_BORDEROS_SAB_V

Source

View Text - Preformatted

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 , APP.FRIENDLY_NAME OUTPUT_PROGRAM_DSP , 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 FROM JL_BR_AR_BORDEROS B, AP_PAYMENT_PROGRAMS APP, 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 AND APP.PROGRAM_ID = B.OUTPUT_PROGRAM_ID AND APP.PROGRAM_TYPE IN ('BORDERO_FILE','BORDERO_REPORT')

View Text - HTML Formatted

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
, APP.FRIENDLY_NAME OUTPUT_PROGRAM_DSP
, 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
FROM JL_BR_AR_BORDEROS B
, AP_PAYMENT_PROGRAMS APP
, 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
AND APP.PROGRAM_ID = B.OUTPUT_PROGRAM_ID
AND APP.PROGRAM_TYPE IN ('BORDERO_FILE'
, 'BORDERO_REPORT')