DBA Data[Home] [Help]

VIEW: APPS.INL_CHARGE_LINE_TYPES_VL

Source

View Text - Preformatted

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
View Text - HTML Formatted

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