DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IRCFV_JOB_POSTING_CONTENTS

Object Details
Object Name: IRCFV_JOB_POSTING_CONTENTS
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Shows the detail of vacancy postings.


[View Source]

Columns
Name Datatype Length Mandatory Comments
JOB_POSTING_NAME VARCHAR2 (240) Yes
ORGANIZATION_NAME VARCHAR2 (240)
ORGANIZATION_DESCRIPTION VARCHAR2 (4000)
JOB_TITLE VARCHAR2 (240)
BRIEF_JOB_DESCRIPTION VARCHAR2 (4000)
DETAILED_JOB_DESCRIPTION VARCHAR2 (4000)
JOB_REQUIREMENTS VARCHAR2 (4000)
ADDITIONAL_DETAILS VARCHAR2 (4000)
HOW_TO_APPLY VARCHAR2 (4000)
BENEFIT_INFO VARCHAR2 (4000)
IMAGE_URL VARCHAR2 (4000)
IMAGE_URL_ALT VARCHAR2 (4000)
DISPLAY_MANAGER_INFO VARCHAR2 (4000)
DISPLAY_RECRUITER_INFO VARCHAR2 (4000)
_DF:JPC CHAR (32)
_DF:JPC_DDF CHAR (35)
DISPLAY_MANAGER_INFO_CODE VARCHAR2 (30) Yes
DISPLAY_RECRUITER_INFO_CODE VARCHAR2 (30) Yes
POSTING_CONTENT_ID NUMBER (15) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT JOB_POSTING_NAME
,      ORGANIZATION_NAME
,      ORGANIZATION_DESCRIPTION
,      JOB_TITLE
,      BRIEF_JOB_DESCRIPTION
,      DETAILED_JOB_DESCRIPTION
,      JOB_REQUIREMENTS
,      ADDITIONAL_DETAILS
,      HOW_TO_APPLY
,      BENEFIT_INFO
,      IMAGE_URL
,      IMAGE_URL_ALT
,      DISPLAY_MANAGER_INFO
,      DISPLAY_RECRUITER_INFO
,      _DF:JPC
,      _DF:JPC_DDF
,      DISPLAY_MANAGER_INFO_CODE
,      DISPLAY_RECRUITER_INFO_CODE
,      POSTING_CONTENT_ID
FROM APPS.IRCFV_JOB_POSTING_CONTENTS;

Dependencies

[top of page]

APPS.IRCFV_JOB_POSTING_CONTENTS references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymIRC_POSTING_CONTENTS
SynonymIRC_POSTING_CONTENTS_TL
SchemaPUBLIC
SynonymDBMS_LOB

APPS.IRCFV_JOB_POSTING_CONTENTS is not referenced by any database object