[Home] [Help]
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
Name |
JOB_ID |
CATEGORY_ID |
INACTIVE_DATE |
JOB_DESCRIPTION |
JOB_LONG_DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |