Product: | JL - Latin America Localizations |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.JL_BR_AR_SELECT_CONTROLS_V |
SELECT SC.ROWID ROW_ID
, SC.SELECTION_CONTROL_ID SELECTION_CONTROL_ID
, SC.SELECTION_STATUS SELECTION_STATUS
, SC.SELECTION_TYPE SELECTION_TYPE
, SC.NAME NAME
, SC.BORDERO_TYPE BORDERO_TYPE
, SC.SELECTION_DATE SELECTION_DATE
, SC.CANCELLATION_DATE CANCELLATION_DATE
, SC.GENERATION_DATE GENERATION_DATE
, SC.REMITTANCE_DATE REMITTANCE_DATE
, SC.DUE_DATE_BREAK_FLAG DUE_DATE_BREAK_FLAG
, SC.INITIAL_DUE_DATE INITIAL_DUE_DATE
, SC.FINAL_DUE_DATE FINAL_DUE_DATE
, SC.INITIAL_TRX_DATE INITIAL_TRX_DATE
, SC.FINAL_TRX_DATE FINAL_TRX_DATE
, SC.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, SC.INITIAL_TRX_NUMBER INITIAL_TRX_NUMBER
, SC.FINAL_TRX_NUMBER FINAL_TRX_NUMBER
, SC.INITIAL_CUSTOMER_NUMBER INITIAL_CUSTOMER_NUMBER
, SC.FINAL_CUSTOMER_NUMBER FINAL_CUSTOMER_NUMBER
, SC.REQUEST_ID REQUEST_ID
, SC.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, SC.INITIAL_TRX_AMOUNT INITIAL_TRX_AMOUNT
, SC.FINAL_TRX_AMOUNT FINAL_TRX_AMOUNT
, SC.ORG_ID ORG_ID
, SC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SC.ATTRIBUTE1 ATTRIBUTE1
, SC.ATTRIBUTE2 ATTRIBUTE2
, SC.ATTRIBUTE3 ATTRIBUTE3
, SC.ATTRIBUTE4 ATTRIBUTE4
, SC.ATTRIBUTE5 ATTRIBUTE5
, SC.ATTRIBUTE6 ATTRIBUTE6
, SC.ATTRIBUTE7 ATTRIBUTE7
, SC.ATTRIBUTE8 ATTRIBUTE8
, SC.ATTRIBUTE9 ATTRIBUTE9
, SC.ATTRIBUTE10 ATTRIBUTE10
, SC.ATTRIBUTE11 ATTRIBUTE11
, SC.ATTRIBUTE12 ATTRIBUTE12
, SC.ATTRIBUTE13 ATTRIBUTE13
, SC.ATTRIBUTE14 ATTRIBUTE14
, SC.ATTRIBUTE15 ATTRIBUTE15
, SC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SC.LAST_UPDATED_BY LAST_UPDATED_BY
, SC.CREATION_DATE CREATION_DATE
, SC.CREATED_BY CREATED_BY
, SC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RM.NAME RECEIPT_METHOD_NAME
, CTT.DESCRIPTION CUST_TRX_TYPE_ID_DSP
, LV.MEANING BORDERO_TYPE_DSP
, LV2.MEANING SELECTION_STATUS_MEANING
FROM JL_BR_AR_SELECT_CONTROLS SC
, AR_RECEIPT_METHODS RM
, RA_CUST_TRX_TYPES CTT
, FND_LOOKUPS LV
, FND_LOOKUPS LV2
WHERE RM.RECEIPT_METHOD_ID (+) = SC.RECEIPT_METHOD_ID
AND CTT.CUST_TRX_TYPE_ID (+) = SC.CUST_TRX_TYPE_ID
AND LV.LOOKUP_CODE = SC.BORDERO_TYPE
AND SC.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 LV2.LOOKUP_CODE (+) = SC.SELECTION_STATUS
AND SC.SELECTION_STATUS <> 'CANCELED'
AND LV2.LOOKUP_TYPE (+) = 'JLBR_AR_SELECTION_STATUS'
AND LV2.ENABLED_FLAG = 'Y'
AND NVL(LV2.START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND NVL(LV2.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE