[Home] [Help]
View: SO_AGREEMENTS_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 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 |