View: JL_BR_AR_BORDEROS_SAB_V

Product:	JL - Latin America Localizations
Description:	- Retrofitted
Implementation/DBA Data:	APPS.JL_BR_AR_BORDEROS_SAB_V

View Text

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')

Columns