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


VIEW: APPS.PAY_JP_SOE_COST_ASSACTS_V

Object Details
Object Name: PAY_JP_SOE_COST_ASSACTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_JP_SOE_COST_ASSACTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER (10)
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
ACTION_STATUS VARCHAR2 (1) Yes
D_ACTION_STATUS VARCHAR2 (80) Yes
MARKED_FOR_RETRY_FLAG VARCHAR2 (1)
ACTION_SEQUENCE NUMBER (15)
PAYROLL_ACTION_ID NUMBER (9) Yes
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
START_DATE DATE

EFFECTIVE_DATE DATE
Yes
DATE_EARNED DATE

ACTION_TYPE VARCHAR2 (30) Yes
D_ACTION_TYPE VARCHAR2 (80) Yes
PAYROLL_ID NUMBER (9)
PAYROLL_NAME VARCHAR2 (80)
CONSOLIDATION_SET_ID NUMBER (9)
CONSOLIDATION_SET_NAME VARCHAR2 (60)
LEGISLATIVE_PARAMETERS VARCHAR2 (2000)
MESSAGES_EXIST_FLAG VARCHAR2 (1)
T_LOCK_STATUS VARCHAR2 (4000)
T_ACTION_STATUS VARCHAR2 (4000)
Query Text

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


SELECT ASSIGNMENT_ID
,      ASSIGNMENT_ACTION_ID
,      OBJECT_VERSION_NUMBER
,      ACTION_STATUS
,      D_ACTION_STATUS
,      MARKED_FOR_RETRY_FLAG
,      ACTION_SEQUENCE
,      PAYROLL_ACTION_ID
,      REQUEST_ID
,      START_DATE
,      EFFECTIVE_DATE
,      DATE_EARNED
,      ACTION_TYPE
,      D_ACTION_TYPE
,      PAYROLL_ID
,      PAYROLL_NAME
,      CONSOLIDATION_SET_ID
,      CONSOLIDATION_SET_NAME
,      LEGISLATIVE_PARAMETERS
,      MESSAGES_EXIST_FLAG
,      T_LOCK_STATUS
,      T_ACTION_STATUS
FROM APPS.PAY_JP_SOE_COST_ASSACTS_V;

Dependencies

[top of page]

APPS.PAY_JP_SOE_COST_ASSACTS_V references the following:

SchemaAPPS
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPAY_JP_SOE_ASSACTS_V
PL/SQL PackagePAY_JP_SOE_PKG - show dependent code
SchemaPUBLIC
SynonymDUAL

APPS.PAY_JP_SOE_COST_ASSACTS_V is not referenced by any database object