[Home] [Help]
View: OE_AGREEMENTS_LOV_V
View Text
SELECT OE_VIEW_FUNCTIONS.GET_AGREEMENT_REVISION (A.NAME
, A.REVISION) AGREEMENT_NAME
, A.AGREEMENT_ID AGREEMENT_ID
, A.AGREEMENT_TYPE_CODE AGREEMENT_TYPE
, A.SOLD_TO_ORG_ID
, A.START_DATE_ACTIVE
, A.END_DATE_ACTIVE
, A.TERM_ID
, A.PRICE_LIST_ID
FROM OE_AGREEMENTS_VL A
Columns
| Name |
| AGREEMENT_NAME |
| AGREEMENT_ID |
| AGREEMENT_TYPE |
| SOLD_TO_ORG_ID |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |
| TERM_ID |
| PRICE_LIST_ID |