VIEW: APPS.CE_222_BATCHES_V

Source

View Text - Preformatted

SELECT B.ROWID, /* 1 */ 'N', /* 2 */ BA.BANK_ACCOUNT_ID, /* 3 */ BA.BANK_ACCOUNT_NAME, /* 4 */ B.BATCH_ID, /* 5 */ NVL(B.BANK_DEPOSIT_NUMBER,B.NAME), /* 6 */ L1.LOOKUP_CODE, /* 7 */ L1.MEANING, /* 8 */ B.BATCH_DATE, /* 9 */ B.CURRENCY_CODE, /* 10 */ TO_NUMBER(NULL), /* 11 */ TO_NUMBER(NULL), /* 12 */ TO_NUMBER(NULL), /* 13 */ TO_NUMBER(NULL), /* 14 */ B.GL_DATE, /* 15 */ B.EXCHANGE_RATE_TYPE, /* 16 */ DT.USER_CONVERSION_TYPE, /* 17 */ B.EXCHANGE_DATE, /* 18 */ B.EXCHANGE_RATE, /* 19 */ TO_NUMBER(NULL), /* 20 */ TO_NUMBER(NULL), /* 21 */ B.CREATED_BY, /* 22 */ B.CREATION_DATE, /* 23 */ B.LAST_UPDATED_BY, /* 24 */ B.LAST_UPDATE_DATE, /* 25 */ TO_NUMBER(NULL), /* 26 */ B.BANK_DEPOSIT_NUMBER, /* 27 */ 222, /* 28 */ 0, /* 29 */ BA.BANK_ACCOUNT_NUM, /* 30 */ BankParty.PARTY_NAME, /* 31 */ BranchParty.PARTY_NAME, /* 32 */ BA.CURRENCY_CODE, /* 33 */ B.NAME, /* 34 */ DECODE(B.CURRENCY_CODE, /* 35 */ SOB.CURRENCY_CODE, 'FUNCTIONAL',BA.CURRENCY_CODE, 'BANK', 'FOREIGN'), BAU.BANK_ACCT_USE_ID, B.ORG_ID FROM CE_LOOKUPS L1, GL_DAILY_CONVERSION_TYPES DT, /*CE_BANK_BRANCHES_V BB,*/ HZ_PARTIES BankParty, HZ_PARTIES BranchParty, CE_BANK_ACCOUNTS BA, /*CE_BANK_ACCT_USES_OU_V BAU,*/ CE_BANK_ACCT_USES_ALL BAU, AR_BATCHES_ALL B, GL_SETS_OF_BOOKS SOB, CE_SYSTEM_PARAMETERS SP WHERE L1.LOOKUP_TYPE = 'BATCH_TYPE' AND L1.LOOKUP_CODE = 'RECEIPT' AND DT.CONVERSION_TYPE(+) = B.EXCHANGE_RATE_TYPE AND BA.BANK_BRANCH_ID = BranchParty.PARTY_ID AND BA.BANK_ID = BankParty.PARTY_ID /*AND BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID*/ AND BAU.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID AND BAU.AR_USE_ENABLE_FLAG = 'Y' and MO_GLOBAL.CHECK_ACCESS(BAU.ORG_ID) = 'Y' and sysdate <= nvl(bau.end_date,sysdate) and sysdate >= nvl(ba.start_date,sysdate) and sysdate <= nvl(ba.end_date,sysdate) AND B.REMIT_BANK_ACCT_USE_ID = BAU.BANK_ACCT_USE_ID AND B.ORG_ID = BAU.ORG_ID AND B.TYPE in ('REMITTANCE', 'BR_REMITTANCE') AND B.BATCH_APPLIED_STATUS IN ('COMPLETED_APPROVAL', 'COMPLETED_FORMAT','STARTED_FORMAT') /*AND SP.ORG_ID = BAU.ORG_ID*/ AND BA.ACCOUNT_OWNER_ORG_ID = SP.LEGAL_ENTITY_ID AND SOB.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID

View Text - HTML Formatted

SELECT B.ROWID
, /* 1 */ 'N'
, /* 2 */ BA.BANK_ACCOUNT_ID
, /* 3 */ BA.BANK_ACCOUNT_NAME
, /* 4 */ B.BATCH_ID
, /* 5 */ NVL(B.BANK_DEPOSIT_NUMBER
, B.NAME)
, /* 6 */ L1.LOOKUP_CODE
, /* 7 */ L1.MEANING
, /* 8 */ B.BATCH_DATE
, /* 9 */ B.CURRENCY_CODE
, /* 10 */ TO_NUMBER(NULL)
, /* 11 */ TO_NUMBER(NULL)
, /* 12 */ TO_NUMBER(NULL)
, /* 13 */ TO_NUMBER(NULL)
, /* 14 */ B.GL_DATE
, /* 15 */ B.EXCHANGE_RATE_TYPE
, /* 16 */ DT.USER_CONVERSION_TYPE
, /* 17 */ B.EXCHANGE_DATE
, /* 18 */ B.EXCHANGE_RATE
, /* 19 */ TO_NUMBER(NULL)
, /* 20 */ TO_NUMBER(NULL)
, /* 21 */ B.CREATED_BY
, /* 22 */ B.CREATION_DATE
, /* 23 */ B.LAST_UPDATED_BY
, /* 24 */ B.LAST_UPDATE_DATE
, /* 25 */ TO_NUMBER(NULL)
, /* 26 */ B.BANK_DEPOSIT_NUMBER
, /* 27 */ 222
, /* 28 */ 0
, /* 29 */ BA.BANK_ACCOUNT_NUM
, /* 30 */ BANKPARTY.PARTY_NAME
, /* 31 */ BRANCHPARTY.PARTY_NAME
, /* 32 */ BA.CURRENCY_CODE
, /* 33 */ B.NAME
, /* 34 */ DECODE(B.CURRENCY_CODE
, /* 35 */ SOB.CURRENCY_CODE
, 'FUNCTIONAL'
, BA.CURRENCY_CODE
, 'BANK'
, 'FOREIGN')
, BAU.BANK_ACCT_USE_ID
, B.ORG_ID
FROM CE_LOOKUPS L1
, GL_DAILY_CONVERSION_TYPES DT
, /*CE_BANK_BRANCHES_V BB
, */ HZ_PARTIES BANKPARTY
, HZ_PARTIES BRANCHPARTY
, CE_BANK_ACCOUNTS BA
, /*CE_BANK_ACCT_USES_OU_V BAU
, */ CE_BANK_ACCT_USES_ALL BAU
, AR_BATCHES_ALL B
, GL_SETS_OF_BOOKS SOB
, CE_SYSTEM_PARAMETERS SP
WHERE L1.LOOKUP_TYPE = 'BATCH_TYPE'
AND L1.LOOKUP_CODE = 'RECEIPT'
AND DT.CONVERSION_TYPE(+) = B.EXCHANGE_RATE_TYPE
AND BA.BANK_BRANCH_ID = BRANCHPARTY.PARTY_ID
AND BA.BANK_ID = BANKPARTY.PARTY_ID /*AND BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID*/
AND BAU.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID
AND BAU.AR_USE_ENABLE_FLAG = 'Y'
AND MO_GLOBAL.CHECK_ACCESS(BAU.ORG_ID) = 'Y'
AND SYSDATE <= NVL(BAU.END_DATE
, SYSDATE)
AND SYSDATE >= NVL(BA.START_DATE
, SYSDATE)
AND SYSDATE <= NVL(BA.END_DATE
, SYSDATE)
AND B.REMIT_BANK_ACCT_USE_ID = BAU.BANK_ACCT_USE_ID
AND B.ORG_ID = BAU.ORG_ID
AND B.TYPE IN ('REMITTANCE'
, 'BR_REMITTANCE')
AND B.BATCH_APPLIED_STATUS IN ('COMPLETED_APPROVAL'
, 'COMPLETED_FORMAT'
, 'STARTED_FORMAT') /*AND SP.ORG_ID = BAU.ORG_ID*/
AND BA.ACCOUNT_OWNER_ORG_ID = SP.LEGAL_ENTITY_ID
AND SOB.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID