[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: |
APPS.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
, '01-JAN-1900' ACTIVE_FROM_DATE
, DECODE(ENABLED_FLAG
, 'Y'
, NULL
, '01-JAN-1900') ACTIVE_TO_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, 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 |