View: AP_BANK_CHARGE_BEAERER_SRS_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_BANK_CHARGE_BEAERER_SRS_V

View Text

SELECT DECODE(LOOKUP_CODE
, 'I'
, DISPLAYED_FIELD
, NVL(SUBSTRB(DISPLAYED_FIELD
, 1
, INSTRB(DISPLAYED_FIELD
, '/')-1)
, 'SUPPLIER'))
, DECODE(LOOKUP_CODE
, 'I'
, 'INTERNAL'
, 'S'
, 'SUPPLIER'
, 'N'
, 'SUPPLIER')
FROM AP_LOOKUP_CODES
WHERE NVL(INACTIVE_DATE
, SYSDATE+1) > SYSDATE
AND LOOKUP_TYPE = 'BANK CHARGE BEARER'

Columns