eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: SO_AGREEMENTS_ACTIVE_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AGR.NAME AGREEMENT
, AGR.AGREEMENT_ID
, AGR.AGREEMENT_TYPE_CODE
, RAC.CUSTOMER_NAME CUSTOMER
, PL.NAME PRICE_LIST
, RAT.NAME PAYMENT_TERMS
, AGR.CUSTOMER_ID
FROM SO_PRICE_LISTS PL
, RA_CUSTOMERS RAC
, RA_TERMS RAT
, SO_AGREEMENTS AGR
WHERE SYSDATE BETWEEN NVL(AGR.START_DATE_ACTIVE
, SYSDATE)
AND NVL(AGR.END_DATE_ACTIVE+1
, SYSDATE)
AND AGR.CUSTOMER_ID = RAC.CUSTOMER_ID(+)
AND AGR.PRICE_LIST_ID = PL.PRICE_LIST_ID(+)
AND AGR.TERM_ID = RAT.TERM_ID(+)

Columns

Name
AGREEMENT
AGREEMENT_ID
AGREEMENT_TYPE_CODE
CUSTOMER
PRICE_LIST
PAYMENT_TERMS
CUSTOMER_ID