View: JL_BR_AR_RCT_MTHD_2_V

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

View Text

SELECT DISTINCT E.NAME NAME
, E.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, D.CREATION_METHOD_CODE CREATION_METHOD_CODE
FROM AR_RECEIPT_METHODS E
, RA_CUST_RECEIPT_METHODS A
, AR_RECEIPT_METHOD_ACCOUNTS B
, CE_BANK_ACCT_USES_ALL ACCUSE
, AR_RECEIPT_CLASSES D
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

Columns