[Home] [Help] [Dependency Information]
Object Name: | HR_PAY_INTERFACE_SPECIAL_IF_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
PERSON_NAME | VARCHAR2 | (240) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
INFORMATION_TYPE | VARCHAR2 | (30) | Yes | |
BUSINESS_GROUP_ID | NUMBER | |||
ID_FLEX_NUM | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
AC_SEGMENT1 | VARCHAR2 | (150) | ||
AC_SEGMENT2 | VARCHAR2 | (150) | ||
AC_SEGMENT3 | VARCHAR2 | (150) | ||
AC_SEGMENT4 | VARCHAR2 | (150) | ||
AC_SEGMENT5 | VARCHAR2 | (150) | ||
AC_SEGMENT6 | VARCHAR2 | (150) | ||
AC_SEGMENT7 | VARCHAR2 | (150) | ||
AC_SEGMENT8 | VARCHAR2 | (150) | ||
AC_SEGMENT9 | VARCHAR2 | (150) | ||
AC_SEGMENT10 | VARCHAR2 | (150) | ||
AC_SEGMENT11 | VARCHAR2 | (150) | ||
AC_SEGMENT12 | VARCHAR2 | (150) | ||
AC_SEGMENT13 | VARCHAR2 | (150) | ||
AC_SEGMENT14 | VARCHAR2 | (150) | ||
AC_SEGMENT15 | VARCHAR2 | (150) | ||
AC_SEGMENT16 | VARCHAR2 | (150) | ||
AC_SEGMENT17 | VARCHAR2 | (150) | ||
AC_SEGMENT18 | VARCHAR2 | (150) | ||
AC_SEGMENT19 | VARCHAR2 | (150) | ||
AC_SEGMENT20 | VARCHAR2 | (150) | ||
GREATEST_LAST_UPDATE_DATE | DATE | |||
PER_LAST_UPDATE_DATE | DATE | |||
PA_LAST_UPDATE_DATE | DATE | |||
AC_LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, PERSON_NAME
, START_DATE
, END_DATE
, INFORMATION_TYPE
, BUSINESS_GROUP_ID
, ID_FLEX_NUM
, PERSON_ID
, AC_SEGMENT1
, AC_SEGMENT2
, AC_SEGMENT3
, AC_SEGMENT4
, AC_SEGMENT5
, AC_SEGMENT6
, AC_SEGMENT7
, AC_SEGMENT8
, AC_SEGMENT9
, AC_SEGMENT10
, AC_SEGMENT11
, AC_SEGMENT12
, AC_SEGMENT13
, AC_SEGMENT14
, AC_SEGMENT15
, AC_SEGMENT16
, AC_SEGMENT17
, AC_SEGMENT18
, AC_SEGMENT19
, AC_SEGMENT20
, GREATEST_LAST_UPDATE_DATE
, PER_LAST_UPDATE_DATE
, PA_LAST_UPDATE_DATE
, AC_LAST_UPDATE_DATE
FROM APPS.HR_PAY_INTERFACE_SPECIAL_IF_V;
|
|
|