[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 |