FND Design Data [Home] [Help]

View: INL_CHARGE_LINE_TYPES_VL

Product: INL - Oracle Landed Cost Management
Description: This view shows Charge Line Type information in a given language.
Implementation/DBA Data: ViewAPPS.INL_CHARGE_LINE_TYPES_VL
View Text

SELECT PRICE_ELEMENT_TYPE_ID CHARGE_LINE_TYPE_ID
, PRICE_ELEMENT_CODE CHARGE_LINE_TYPE_CODE
, NAME CHARGE_LINE_TYPE_NAME
, 'Y' DFLT_LANDED_COST_FLAG
, 'MISCELLANEOUS' AP_LINE_TYPE_CODE
, NVL(ALLOCATION_BASIS
, 'VALUE') ALLOCATION_BASIS
, TO_DATE('01/01/1900'
, 'DD-MM-YYYY') ACTIVE_FROM_DATE
, DECODE(ENABLED_FLAG
, 'Y'
, TO_DATE(NULL)
, TO_DATE('01/01/1900'
, 'DD-MM-YYYY')) ACTIVE_TO_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM PON_COST_FACTORS_VL

Columns

Name
CHARGE_LINE_TYPE_ID
CHARGE_LINE_TYPE_CODE
CHARGE_LINE_TYPE_NAME
DFLT_LANDED_COST_FLAG
AP_LINE_TYPE_CODE
ALLOCATION_BASIS
ACTIVE_FROM_DATE
ACTIVE_TO_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE