[Home] [Help] [Dependency Information]
Object Name: | HR_PAY_INTERFACE_ACCOUNTING_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) | ||
ACT_SEGMENT1 | VARCHAR2 | (25) | ||
ACT_SEGMENT2 | VARCHAR2 | (25) | ||
ACT_SEGMENT3 | VARCHAR2 | (25) | ||
ACT_SEGMENT4 | VARCHAR2 | (25) | ||
ACT_SEGMENT5 | VARCHAR2 | (25) | ||
ACT_SEGMENT6 | VARCHAR2 | (25) | ||
ACT_SEGMENT7 | VARCHAR2 | (25) | ||
ACT_SEGMENT8 | VARCHAR2 | (25) | ||
ACT_SEGMENT9 | VARCHAR2 | (25) | ||
ACT_SEGMENT10 | VARCHAR2 | (25) | ||
ACT_SEGMENT11 | VARCHAR2 | (25) | ||
ACT_SEGMENT12 | VARCHAR2 | (25) | ||
ACT_SEGMENT13 | VARCHAR2 | (25) | ||
ACT_SEGMENT14 | VARCHAR2 | (25) | ||
ACT_SEGMENT15 | VARCHAR2 | (25) | ||
ACT_SEGMENT16 | VARCHAR2 | (25) | ||
ACT_SEGMENT17 | VARCHAR2 | (25) | ||
ACT_SEGMENT18 | VARCHAR2 | (25) | ||
ACT_SEGMENT19 | VARCHAR2 | (25) | ||
ACT_SEGMENT20 | VARCHAR2 | (25) | ||
ACT_SEGMENT21 | VARCHAR2 | (25) | ||
ACT_SEGMENT22 | VARCHAR2 | (25) | ||
ACT_SEGMENT23 | VARCHAR2 | (25) | ||
ACT_SEGMENT24 | VARCHAR2 | (25) | ||
ACT_SEGMENT25 | VARCHAR2 | (25) | ||
ACT_SEGMENT26 | VARCHAR2 | (25) | ||
ACT_SEGMENT27 | VARCHAR2 | (25) | ||
ACT_SEGMENT28 | VARCHAR2 | (25) | ||
ACT_SEGMENT29 | VARCHAR2 | (25) | ||
ACT_SEGMENT30 | VARCHAR2 | (25) | ||
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 | |
GL_CODE_COMBINATION_ID | NUMBER | (15) | Yes | |
GREATEST_LAST_UPDATE_DATE | DATE | |||
PER_LAST_UPDATE_DATE | DATE | |||
ASG_LAST_UPDATE_DATE | DATE | |||
GL_LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_NUMBER
, PRIMARY_ASSIGNMENT_FLAG
, ASSIGNMENT_NUMBER
, ACT_SEGMENT1
, ACT_SEGMENT2
, ACT_SEGMENT3
, ACT_SEGMENT4
, ACT_SEGMENT5
, ACT_SEGMENT6
, ACT_SEGMENT7
, ACT_SEGMENT8
, ACT_SEGMENT9
, ACT_SEGMENT10
, ACT_SEGMENT11
, ACT_SEGMENT12
, ACT_SEGMENT13
, ACT_SEGMENT14
, ACT_SEGMENT15
, ACT_SEGMENT16
, ACT_SEGMENT17
, ACT_SEGMENT18
, ACT_SEGMENT19
, ACT_SEGMENT20
, ACT_SEGMENT21
, ACT_SEGMENT22
, ACT_SEGMENT23
, ACT_SEGMENT24
, ACT_SEGMENT25
, ACT_SEGMENT26
, ACT_SEGMENT27
, ACT_SEGMENT28
, ACT_SEGMENT29
, ACT_SEGMENT30
, BUSINESS_GROUP_NAME
, ORGANIZATION_NAME
, PERSON_ID
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, ORGANIZATION_ID
, GL_CODE_COMBINATION_ID
, GREATEST_LAST_UPDATE_DATE
, PER_LAST_UPDATE_DATE
, ASG_LAST_UPDATE_DATE
, GL_LAST_UPDATE_DATE
FROM APPS.HR_PAY_INTERFACE_ACCOUNTING_V;
|
|
|