APPS.OKL_BPD_RCPT_MTHDS_UV
[Home] [Help]
| Product: | OKL - Lease and Finance Management |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.OKL_BPD_RCPT_MTHDS_UV
|
SELECT BA.ROWID ROW_ID
, RM.NAME RECEIPT_METHOD_NAME
, RM.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, L.MEANING MEANING
, BA.BANK_ACCT_USE_ID BANK_ACCOUNT_ID
, CE_BANK_AND_ACCOUNT_UTIL.GET_MASKED_BANK_ACCT_NUM(CBA.BANK_ACCOUNT_ID) BANK_ACCOUNT_NUM
, BB.BANK_NAME BANK_NAME
, BB.BANK_BRANCH_NAME BANK_BRANCH_NAME
, BB.BRANCH_PARTY_ID BANK_BRANCH_ID
, CBA.CURRENCY_CODE CURRENCY_CODE
, RC.CREATION_STATUS CREATION_STATUS
, RC.NAME RECEIPT_CLASS_NAME
, RC.REMIT_FLAG REMIT_FLAG
, RC.NOTES_RECEIVABLE NOTES_RECEIVABLE
, BA.ORG_ID ORG_ID
, RMA.ORG_ID ORG_ID_1
, RM.START_DATE RECEIPT_METHOD_START_DATE
, RM.END_DATE RECEIPT_METHOD_END_DATE
, RM.PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, BA.END_DATE INACTIVE_DATE
, CBA.RECEIPT_MULTI_CURRENCY_FLAG MULTI_CURRENCY_FLAG
FROM AR_LOOKUPS L
, CE_BANK_BRANCHES_V BB
, CE_BANK_ACCOUNTS CBA
, CE_BANK_ACCT_USES_ALL BA
, AR_RECEIPT_CLASSES RC
, AR_RECEIPT_METHODS RM
, AR_RECEIPT_METHOD_ACCOUNTS RMA
WHERE RM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID
AND RC.CREATION_STATUS = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'RECEIPT_CREATION_STATUS' AND(SYSDATE BETWEEN RM.START_DATE
AND NVL(RM.END_DATE
, SYSDATE)) AND((RC.CREATION_METHOD_CODE = 'MANUAL') OR (RC.CREATION_METHOD_CODE = 'AUTOMATIC'
AND RC.REMIT_FLAG = 'Y'
AND RC.CONFIRM_FLAG = 'N'))
AND CBA.ACCOUNT_CLASSIFICATION = 'INTERNAL'
AND NVL(BA.END_DATE
, SYSDATE + 1) > SYSDATE
AND SYSDATE BETWEEN RMA.START_DATE
AND NVL(RMA.END_DATE
, SYSDATE)
AND CBA.BANK_BRANCH_ID = BB.BRANCH_PARTY_ID
AND CBA.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID
AND CBA.AR_USE_ALLOWED_FLAG = 'Y'
AND RM.RECEIPT_METHOD_ID = RMA.RECEIPT_METHOD_ID
AND RMA.REMIT_BANK_ACCT_USE_ID = BA.BANK_ACCT_USE_ID
AND RMA.ORG_ID = BA.ORG_ID
AND MO_GLOBAL.CHECK_ACCESS(RMA.ORG_ID) = 'Y'
AND RM.RECEIPT_CLASS_ID NOT IN (SELECT ARC.RECEIPT_CLASS_ID
FROM AR_RECEIPT_CLASSES ARC
WHERE ARC.NOTES_RECEIVABLE='Y' OR ARC.BILL_OF_EXCHANGE_FLAG='Y') ORDER BY RM.NAME
, RM.RECEIPT_METHOD_ID