VIEW: APPS.JL_BR_AR_SELECT_CONTROLS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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