VIEW: APPS.GR_OTHER_NAMES_ORGN_V

Source

View Text - Preformatted

SELECT UNIQUE b.ITEM_CODE, b.ORGN_CODE, s.ORGN_NAME FROM GR_OTHER_NAMES_TL b, SY_ORGN_MST s WHERE s.ORGN_CODE = b.ORGN_CODE

View Text - HTML Formatted

SELECT UNIQUE B.ITEM_CODE
, B.ORGN_CODE
, S.ORGN_NAME
FROM GR_OTHER_NAMES_TL B
, SY_ORGN_MST S
WHERE S.ORGN_CODE = B.ORGN_CODE