FND Design Data [Home] [Help]

View: PA_DISCOUNT_CODES_LOV_V

Product: PA - Projects
Description: This view displays all the defined discount codes.
Implementation/DBA Data: ViewAPPS.PA_DISCOUNT_CODES_LOV_V
View Text

SELECT MEANING
, LOOKUP_CODE
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'RATE
AND DISCOUNT REASON'
AND TRUNC(NVL(END_DATE_ACTIVE
, SYSDATE)) >= TRUNC(SYSDATE)

Columns

Name
DISCOUNT_MEANING
LABOR_NL_REASON_CODE