VIEW: APPS.JL_BR_AR_RCT_MTHD_2_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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