FND Design Data [Home] [Help]

View: OKE_K_BILLING_METHODS_HV

Product: OKE - Project Contracts
Description: Contract billing method assignments history view
Implementation/DBA Data: ViewAPPS.OKE_K_BILLING_METHODS_HV
View Text

SELECT K.ROWID
, K.MAJOR_VERSION
, K.BILLING_METHOD_CODE
, K.K_HEADER_ID
, K.DEFAULT_FLAG
, V.BILLING_METHOD_NAME
, V.DESCRIPTION
, V.INCLUDE_PRICE_FLAG
, V.INCLUDE_COST_FLAG
, V.INCLUDE_FEE_FLAG
, K.CREATED_BY
, K.CREATION_DATE
, K.LAST_UPDATED_BY
, K.LAST_UPDATE_LOGIN
, K.LAST_UPDATE_DATE
FROM OKE_K_BILLING_METHODS_H K
, OKE_BILLING_METHODS_VL V
WHERE K.BILLING_METHOD_CODE = V.BILLING_METHOD_CODE

Columns

Name
ROW_ID
MAJOR_VERSION
BILLING_METHOD_CODE
K_HEADER_ID
DEFAULT_FLAG
BILLING_METHOD_NAME
DESCRIPTION
INCLUDE_PRICE_FLAG
INCLUDE_COST_FLAG
INCLUDE_FEE_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE