VIEW: APPS.QP_CHARGE_LOOKUP

Source

View Text - Preformatted

SELECT LOOKUP_TYPE, LOOKUP_CODE, MEANING, DESCRIPTION, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE from fnd_lookup_values where language = userenv('LANG') and security_group_id = 0 and ((view_application_id = 661 and lookup_type = 'FREIGHT_CHARGES_TYPE') or (view_application_id = 665 and lookup_type = 'FREIGHT_COST_TYPE'))

View Text - HTML Formatted

SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM FND_LOOKUP_VALUES
WHERE LANGUAGE = USERENV('LANG')
AND SECURITY_GROUP_ID = 0
AND ((VIEW_APPLICATION_ID = 661
AND LOOKUP_TYPE = 'FREIGHT_CHARGES_TYPE') OR (VIEW_APPLICATION_ID = 665
AND LOOKUP_TYPE = 'FREIGHT_COST_TYPE'))