JL_BR_AR_SELECT_CONTROLS_V

Details

• Schema: FUSION

• Object owner: JL

• Object type: VIEW

Columns

Name

ROW_ID SELECTION_CONTROL_ID SELECTION_STATUS SELECTION_TYPE NAME BORDERO_TYPE SELECTION_DATE CANCELLATION_DATE GENERATION_DATE REMITTANCE_DATE DUE_DATE_BREAK_FLAG INITIAL_DUE_DATE FINAL_DUE_DATE INITIAL_TRX_DATE FINAL_TRX_DATE CUST_TRX_TYPE_SEQ_ID INITIAL_TRX_NUMBER FINAL_TRX_NUMBER INITIAL_CUSTOMER_NUMBER FINAL_CUSTOMER_NUMBER REQUEST_ID RECEIPT_METHOD_ID INITIAL_TRX_AMOUNT FINAL_TRX_AMOUNT ORG_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN RECEIPT_METHOD_NAME CUST_TRX_TYPE_ID_DSP BORDERO_TYPE_DSP SELECTION_STATUS_MEANING OBJECT_VERSION_NUMBER PARTY_ID BILLING_ORG_ID

Query

SQL_Statement

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_SEQ_ID CUST_TRX_TYPE_SEQ_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 ,SC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SC.PARTY_ID PARTY_ID, SC.BILLING_ORG_ID BILLING_ORG_ID FROM JL_BR_AR_SELECT_CONTROLS SC, AR_RECEIPT_METHODS RM , RA_CUST_TRX_TYPES_ALL CTT , FND_LOOKUPS LV, FND_LOOKUPS LV2 WHERE RM.RECEIPT_METHOD_ID (+) = SC.RECEIPT_METHOD_ID AND CTT.CUST_TRX_TYPE_SEQ_ID (+) = SC.CUST_TRX_TYPE_SEQ_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