[Home] [Help]
View: PO_LOOKUP_CODES_PAY_GROUP_AP_V
View Text
SELECT PLC.LOOKUP_CODE PAYGROUP
, PLC.DESCRIPTION DESCRIPTION
, DECODE(SIGN(PLC.INACTIVE_DATE - SYSDATE)
, -1
, ''
, '*') ACTIVE
, PLC.DISPLAYED_FIELD
FROM PO_LOOKUP_CODES PLC
WHERE PLC.LOOKUP_TYPE = 'PAY GROUP'
Columns
Name |
PAYGROUP |
DESCRIPTION |
ACTIVE |
DISPLAYED_FIELD |