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, 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

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
, 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