View: JL_BR_AR_RCT_MTHD_1_V

Product:	JL - Latin America Localizations
Description:	- Retrofitted
Implementation/DBA Data:	APPS.JL_BR_AR_RCT_MTHD_1_V

View Text

SELECT E.NAME NAME
, E.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, E.START_DATE RECEIPT_START_DATE
, E.END_DATE RECEIPT_END_DATE
, D.CREATION_METHOD_CODE CREATION_METHOD_CODE
, HROU.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ACC.CURRENCY_CODE CURRENCY_CODE
, ACC.RECEIPT_MULTI_CURRENCY_FLAG MULTI_CURRENCY_FLAG
, A.CUSTOMER_ID CUSTOMER_ID
, A.SITE_USE_ID SITE_USE_ID
, NVL(ACC.END_DATE
, TO_DATE('01/01/2200'
, 'DD/MM/YYYY')) INACTIVE_DATE
, A.START_DATE CUST_RCPT_START_DATE
, A.END_DATE CUST_RCPT_END_DATE
, B.START_DATE RCPT_MTHD_START_DATE
, B.END_DATE RCPT_MTHD_END_DATE
FROM AR_RECEIPT_METHODS E
, RA_CUST_RECEIPT_METHODS A
, AR_RECEIPT_METHOD_ACCOUNTS B
, CE_BANK_ACCT_USES_ALL ACCUSE
, CE_BANK_ACCOUNTS ACC
, AR_RECEIPT_CLASSES D
, HR_OPERATING_UNITS HROU
WHERE E.RECEIPT_METHOD_ID = A.RECEIPT_METHOD_ID
AND E.RECEIPT_CLASS_ID = D.RECEIPT_CLASS_ID
AND A.RECEIPT_METHOD_ID = B.RECEIPT_METHOD_ID
AND B.REMIT_BANK_ACCT_USE_ID = ACCUSE.BANK_ACCT_USE_ID
AND ACC.BANK_ACCOUNT_ID = ACCUSE.BANK_ACCOUNT_ID
AND HROU.ORGANIZATION_ID = ACCUSE.ORG_ID

Columns