[Home] [Help]
[Dependency Information]
[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) | Yes | |
| 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) | Yes | |
| 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;
APPS
PAY_PDT_BATCH_LINES_V2
APPS
PAY_PDT_BATCH_LINES
|
|
|
|