VIEW: APPS.XNB_CUST_RECEIPT_METHODS_V

Source

View Text - Preformatted

SELECT A.CUSTOMER_ID CUSTOMER_ID, A.CUST_RECEIPT_METHOD_ID CUST_RECEIPT_METHOD_ID, A.RECEIPT_METHOD_ID RECEIPT_METHOD_ID, B.NAME RECEIPT_METHOD_NAME, A.PRIMARY_FLAG PRIMARY_FLAG, A.START_DATE START_DATE, A.END_DATE END_DATE FROM RA_CUST_RECEIPT_METHODS A, AR_RECEIPT_METHODS B WHERE A.RECEIPT_METHOD_ID = B.RECEIPT_METHOD_ID AND (A.END_DATE IS NULL OR A.END_DATE > SYSDATE)

View Text - HTML Formatted

SELECT A.CUSTOMER_ID CUSTOMER_ID
, A.CUST_RECEIPT_METHOD_ID CUST_RECEIPT_METHOD_ID
, A.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, B.NAME RECEIPT_METHOD_NAME
, A.PRIMARY_FLAG PRIMARY_FLAG
, A.START_DATE START_DATE
, A.END_DATE END_DATE
FROM RA_CUST_RECEIPT_METHODS A
, AR_RECEIPT_METHODS B
WHERE A.RECEIPT_METHOD_ID = B.RECEIPT_METHOD_ID
AND (A.END_DATE IS NULL OR A.END_DATE > SYSDATE)