View: PO_JOB_ASSOCIATIONS

Product:	PO - Purchasing
Description:	Single-language view for Job-Category Associations. Shows the descriptions in the current session language.
Implementation/DBA Data:	APPS.PO_JOB_ASSOCIATIONS

View Text

SELECT B.JOB_ID
, B.CATEGORY_ID
, B.INACTIVE_DATE
, TL.JOB_DESCRIPTION
, TL.JOB_LONG_DESCRIPTION
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
FROM PO_JOB_ASSOCIATIONS_B B
, PO_JOB_ASSOCIATIONS_TL TL
WHERE B.JOB_ID = TL.JOB_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns