[Home] [Help]
VIEW: APPS.PO_LOOKUP_CODES_PAY_GROUP_AP_V
Source
View Text - Preformatted
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'
View Text - HTML Formatted
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'