[Home] [Help]
View: QP_CHARGE_LOOKUP
Product: | QP - Advanced Pricing |
Description: | Charge Types available for the setup of Freight and Special charges. |
Implementation/DBA Data: |
APPS.QP_CHARGE_LOOKUP
|
View Text
SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM QP_LOOKUPS LKP
WHERE LOOKUP_TYPE = 'FREIGHT_CHARGES_TYPE' UNION SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM WSH_LOOKUPS
WHERE LOOKUP_TYPE = 'FREIGHT_COST_TYPE'
Columns
Name |
LOOKUP_TYPE |
LOOKUP_CODE |
MEANING |
DESCRIPTION |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |