[Home] [Help] [Dependency Information]
Object Name: | PAY_PDT_BATCH_LINES_V3 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_PDT_BATCH_LINES_V3 |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Yes | |
LINE_ID | NUMBER | (15) | ||
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
ADJUSTMENT_TYPE_CODE | VARCHAR2 | (0) | ||
AMT_AMOUNT | VARCHAR2 | (80) | ||
AMT_PERCENTAGE | VARCHAR2 | (80) | ||
AMT_NET_AMOUNT | VARCHAR2 | (80) | ||
AMT_PAY_VALUE | VARCHAR2 | (80) | ||
AMT_REPLACE_AMT | VARCHAR2 | (80) | ||
AMT_ADDL_AMT | VARCHAR2 | (80) | ||
APPLY_THIS_PERIOD | VARCHAR2 | (0) | ||
COST_CENTER_CODE | VARCHAR2 | (0) | ||
ELEMENT_NAME | VARCHAR2 | (80) | Yes | |
FROM_DATE | DATE | |||
HOURLY_RATE | VARCHAR2 | (80) | ||
HOURS_WORKED | VARCHAR2 | (80) | ||
INC_ASC_BALANCE | VARCHAR2 | (80) | ||
LABOR_DIST_CODE | VARCHAR2 | (0) | ||
LINE_STATUS | VARCHAR2 | (30) | ||
LOCALITY_WORKED | VARCHAR2 | (0) | ||
NEW_SALARY | NUMBER | |||
PAY_EFFECTIVE_DATE | DATE | |||
PCNT_INCREASE | NUMBER | |||
RATE_CODE | VARCHAR2 | (80) | ||
RATE_MULTIPLE | VARCHAR2 | (80) | ||
RATING_CODE | VARCHAR2 | (0) | ||
SEPARATE_CHECK_FLAG | VARCHAR2 | (80) | ||
SHIFT_TYPE | VARCHAR2 | (80) | ||
STATE_WORKED | VARCHAR2 | (80) | ||
TAX_SEPARATELY_FLAG | VARCHAR2 | (80) | ||
TO_DATE | DATE | |||
VOL_DED_PROC_OVD | VARCHAR2 | (80) | ||
COST_ALLOCATION_KEYFLEX_ID | NUMBER | (9) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (240) | ||
SEGMENT1 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT2 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT3 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT4 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT5 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT6 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT7 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT8 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT9 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT10 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT11 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT12 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT13 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT14 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT15 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT16 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT17 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT18 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT19 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT20 | VARCHAR2 | (60) | Key flexfield segment | |
SEGMENT21 | VARCHAR2 | (60) | ||
SEGMENT22 | VARCHAR2 | (60) | ||
SEGMENT23 | VARCHAR2 | (60) | ||
SEGMENT24 | VARCHAR2 | (60) | ||
SEGMENT25 | VARCHAR2 | (60) | ||
SEGMENT26 | VARCHAR2 | (60) | ||
SEGMENT27 | VARCHAR2 | (60) | ||
SEGMENT28 | VARCHAR2 | (60) | ||
SEGMENT29 | VARCHAR2 | (60) | ||
SEGMENT30 | VARCHAR2 | (60) |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, LINE_ID
, ASSIGNMENT_NUMBER
, ADJUSTMENT_TYPE_CODE
, AMT_AMOUNT
, AMT_PERCENTAGE
, AMT_NET_AMOUNT
, AMT_PAY_VALUE
, AMT_REPLACE_AMT
, AMT_ADDL_AMT
, APPLY_THIS_PERIOD
, COST_CENTER_CODE
, ELEMENT_NAME
, FROM_DATE
, HOURLY_RATE
, HOURS_WORKED
, INC_ASC_BALANCE
, LABOR_DIST_CODE
, LINE_STATUS
, LOCALITY_WORKED
, NEW_SALARY
, PAY_EFFECTIVE_DATE
, PCNT_INCREASE
, RATE_CODE
, RATE_MULTIPLE
, RATING_CODE
, SEPARATE_CHECK_FLAG
, SHIFT_TYPE
, STATE_WORKED
, TAX_SEPARATELY_FLAG
, TO_DATE
, VOL_DED_PROC_OVD
, COST_ALLOCATION_KEYFLEX_ID
, CONCATENATED_SEGMENTS
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
FROM APPS.PAY_PDT_BATCH_LINES_V3;
|
|
|