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

VIEW: APPS.IRCBV_DEFAULT_POSTINGS_V

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

View Type

A Business Intelligence System view


Default posting (from IRC_DEFAULT_POSTINGS/TL table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORG_NAME VARCHAR2 (240)
Organization name.
ORG_DESCRIPTION CLOB (4000)
Organization description.
JOB_TITLE VARCHAR2 (240)
Job title.
BRIEF_DESCRIPTION CLOB (4000)
Brief description.
DETAILED_DESCRIPTION CLOB (4000)
Detailed description.
JOB_REQUIREMENTS CLOB (4000)
Job requirements.
ADDITIONAL_DETAILS CLOB (4000)
Additional details.
HOW_TO_APPLY CLOB (4000)
How to apply.
IMAGE_URL CLOB (4000)
Image url.
IMAGE_URL_ALT CLOB (4000)
Image url alt.
_DF:IDP CHAR (32)
Descriptive Flex placeholder
DEFAULT_POSTING_ID NUMBER (15) Yes Primary key for IRC_DEFAULT_POSTINGS.
POSITION_ID NUMBER (15)
Foreign key to PER_ALL_POSITIONS.
JOB_ID NUMBER (15)
Foreign key to PER_JOBS.
ORGANIZATION_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
Query Text

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


SELECT ORG_NAME
,      ORG_DESCRIPTION
,      JOB_TITLE
,      BRIEF_DESCRIPTION
,      DETAILED_DESCRIPTION
,      JOB_REQUIREMENTS
,      ADDITIONAL_DETAILS
,      HOW_TO_APPLY
,      IMAGE_URL
,      IMAGE_URL_ALT
,      _DF:IDP
,      DEFAULT_POSTING_ID
,      POSITION_ID
,      JOB_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.IRCBV_DEFAULT_POSTINGS_V;

Dependencies

[top of page]

APPS.IRCBV_DEFAULT_POSTINGS_V references the following:

SchemaAPPS
SynonymIRC_DEFAULT_POSTINGS
SynonymIRC_DEFAULT_POSTINGS_TL

APPS.IRCBV_DEFAULT_POSTINGS_V is not referenced by any database object