View: OKX_RCPT_METHOD_ACCOUNTS_V

Product:	OKX - Contracts Integration
Description:	This view contains bank accounts for customers
Implementation/DBA Data:	APPS.OKX_RCPT_METHOD_ACCOUNTS_V

View Text

SELECT 12345 ID1
, '#' ID2
, AP_ACCT.BANK_ACCOUNT_NAME||'-'||SITE.LOCATION NAME
, AP_ACCT.BANK_ACCOUNT_NUM DESCRIPTION
, AP_BANK.BANK_NAME BANK_NAME
, AP_ACCT.BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, AP_ACCT.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, AP_ACCT.BANK_BRANCH_ID BANK_BRANCH_ID
, 123 SET_OF_BOOKS_ID
, AP_ACCT.CURRENCY_CODE CURRENCY_CODE
, 'ACCOUNT_TYPE' ACCOUNT_TYPE
, 1234 CUSTOMER_ID
, 1234 CUSTOMER_SITE_USE_ID
, AP_ACCT_USES.START_DATE START_DATE_ACTIVE
, AP_ACCT_USES.END_DATE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(AP_ACCT_USES.START_DATE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(AP_ACCT_USES.END_DATE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, '1234' ORG_ID
, 'F' MULTI_CURRENCY_FLAG
, AP_ACCT.RECEIPT_MULTI_CURRENCY_FLAG RECEIPT_MULTI_CURRENCY_FLAG
, 'CONTACT_FIRST_NAME' CONTACT_FIRST_NAME
, 'CONTACT_MIDDLE_NAME' CONTACT_MIDDLE_NAME
, 'LAST NAME' CONTACT_LAST_NAME
, 'MR' CONTACT_PREFIX
, 'MANAGER' CONTACT_TITLE
, '94070' CONTACT_AREA_CODE
, '650 591 4246' CONTACT_PHONE
FROM HZ_CUST_SITE_USES_ALL SITE
, CE_BANK_ACCOUNTS AP_ACCT
, CE_BANK_BRANCHES_V AP_BANK
, IBY_EXT_BANK_ACCOUNTS AP_ACCT_USES
WHERE SITE.SITE_USE_ID(+) = AP_ACCT_USES.EXT_BANK_ACCOUNT_ID
AND AP_BANK.BRANCH_PARTY_ID = AP_ACCT.BANK_BRANCH_ID
AND AP_ACCT_USES.EXT_BANK_ACCOUNT_ID = AP_ACCT.BANK_ACCOUNT_ID

Columns