VIEW: APPS.AP_BANK_CHARGE_BEAERER_SRS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'