FND Design Data [Home] [Help]

View: OE_AGREEMENTS_LOV_V

Product: ONT - Order Management
Description: List of agreements.
Implementation/DBA Data: ViewAPPS.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