[Home] [Help] [Dependency Information]
Object Name: | HR_PAY_INTERFACE_ASG_COSTING_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
PRIMARY_ASSIGNMENT_FLAG | VARCHAR2 | (30) | Yes | |
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
CST_SEGMENT1 | VARCHAR2 | (60) | ||
CST_SEGMENT2 | VARCHAR2 | (60) | ||
CST_SEGMENT3 | VARCHAR2 | (60) | ||
CST_SEGMENT4 | VARCHAR2 | (60) | ||
CST_SEGMENT5 | VARCHAR2 | (60) | ||
CST_SEGMENT6 | VARCHAR2 | (60) | ||
CST_SEGMENT7 | VARCHAR2 | (60) | ||
CST_SEGMENT8 | VARCHAR2 | (60) | ||
CST_SEGMENT9 | VARCHAR2 | (60) | ||
CST_SEGMENT10 | VARCHAR2 | (60) | ||
CST_SEGMENT11 | VARCHAR2 | (60) | ||
CST_SEGMENT12 | VARCHAR2 | (60) | ||
CST_SEGMENT13 | VARCHAR2 | (60) | ||
CST_SEGMENT14 | VARCHAR2 | (60) | ||
CST_SEGMENT15 | VARCHAR2 | (60) | ||
CST_SEGMENT16 | VARCHAR2 | (60) | ||
CST_SEGMENT17 | VARCHAR2 | (60) | ||
CST_SEGMENT18 | VARCHAR2 | (60) | ||
CST_SEGMENT19 | VARCHAR2 | (60) | ||
CST_SEGMENT20 | VARCHAR2 | (60) | ||
CST_SEGMENT21 | VARCHAR2 | (60) | ||
CST_SEGMENT22 | VARCHAR2 | (60) | ||
CST_SEGMENT23 | VARCHAR2 | (60) | ||
CST_SEGMENT24 | VARCHAR2 | (60) | ||
CST_SEGMENT25 | VARCHAR2 | (60) | ||
CST_SEGMENT26 | VARCHAR2 | (60) | ||
CST_SEGMENT27 | VARCHAR2 | (60) | ||
CST_SEGMENT28 | VARCHAR2 | (60) | ||
CST_SEGMENT29 | VARCHAR2 | (60) | ||
CST_SEGMENT30 | VARCHAR2 | (60) | ||
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | (15) | Yes | |
COST_ALLOCATION_ID | NUMBER | (15) | Yes | |
GREATEST_LAST_UPDATE_DATE | DATE | |||
PER_LAST_UPDATE_DATE | DATE | |||
ASG_LAST_UPDATE_DATE | DATE | |||
CST_LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_NUMBER
, PRIMARY_ASSIGNMENT_FLAG
, ASSIGNMENT_NUMBER
, CST_SEGMENT1
, CST_SEGMENT2
, CST_SEGMENT3
, CST_SEGMENT4
, CST_SEGMENT5
, CST_SEGMENT6
, CST_SEGMENT7
, CST_SEGMENT8
, CST_SEGMENT9
, CST_SEGMENT10
, CST_SEGMENT11
, CST_SEGMENT12
, CST_SEGMENT13
, CST_SEGMENT14
, CST_SEGMENT15
, CST_SEGMENT16
, CST_SEGMENT17
, CST_SEGMENT18
, CST_SEGMENT19
, CST_SEGMENT20
, CST_SEGMENT21
, CST_SEGMENT22
, CST_SEGMENT23
, CST_SEGMENT24
, CST_SEGMENT25
, CST_SEGMENT26
, CST_SEGMENT27
, CST_SEGMENT28
, CST_SEGMENT29
, CST_SEGMENT30
, BUSINESS_GROUP_NAME
, ORGANIZATION_NAME
, PERSON_ID
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, ORGANIZATION_ID
, COST_ALLOCATION_ID
, GREATEST_LAST_UPDATE_DATE
, PER_LAST_UPDATE_DATE
, ASG_LAST_UPDATE_DATE
, CST_LAST_UPDATE_DATE
FROM APPS.HR_PAY_INTERFACE_ASG_COSTING_V;
APPS.HR_PAY_INTERFACE_ASG_COSTING_V is not referenced by any database object
|
|
|