VIEW: APPS.ISC_FREIGHT_CARRIER_V

Source

View Text - Preformatted

SELECT wc.carrier_id ID, hp.party_name VALUE from WSH_CARRIERS wc, HZ_PARTIES hp WHERE wc.carrier_id = hp.party_id union select -1 id, message_text value from fnd_new_messages m, fnd_application a where 'EDW_UNASSIGNED' = m.message_name and m.language_code = userenv('LANG') and 'BIS' = a.application_short_name and m.application_id = a.application_id

View Text - HTML Formatted

SELECT WC.CARRIER_ID ID
, HP.PARTY_NAME VALUE
FROM WSH_CARRIERS WC
, HZ_PARTIES HP
WHERE WC.CARRIER_ID = HP.PARTY_ID UNION SELECT -1 ID
, MESSAGE_TEXT VALUE
FROM FND_NEW_MESSAGES M
, FND_APPLICATION A
WHERE 'EDW_UNASSIGNED' = M.MESSAGE_NAME
AND M.LANGUAGE_CODE = USERENV('LANG')
AND 'BIS' = A.APPLICATION_SHORT_NAME
AND M.APPLICATION_ID = A.APPLICATION_ID