VIEW: APPS.PO_JOB_ASSOCIATIONS

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')