DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_PDT_BATCH_LINES_V2

Object Details
Object Name: PAY_PDT_BATCH_LINES_V2
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_PDT_BATCH_LINES_V2
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ELEMENT_TYPE_ID NUMBER (9) Yes
ELEMENT_NAME VARCHAR2 (80) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
LEGISLATION_CODE VARCHAR2 (30)
BATCH_LINE_ID NUMBER (15) Yes
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
ASSIGNMENT_ID NUMBER (10)
BATCH_ID NUMBER (15) Yes
BATCH_LINE_STATUS VARCHAR2 (30) Yes
ASSIGNMENT_NUMBER VARCHAR2 (30)
BATCH_SEQUENCE NUMBER (9)
CONCATENATED_SEGMENTS VARCHAR2 (240)
EFFECTIVE_DATE DATE

ENTRY_TYPE VARCHAR2 (1)
REASON VARCHAR2 (80)
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)
VALUE_1 VARCHAR2 (80)
VALUE_2 VARCHAR2 (80)
VALUE_3 VARCHAR2 (80)
VALUE_4 VARCHAR2 (80)
VALUE_5 VARCHAR2 (80)
VALUE_6 VARCHAR2 (80)
VALUE_7 VARCHAR2 (80)
VALUE_8 VARCHAR2 (80)
VALUE_9 VARCHAR2 (80)
VALUE_10 VARCHAR2 (80)
VALUE_11 VARCHAR2 (80)
VALUE_12 VARCHAR2 (80)
VALUE_13 VARCHAR2 (80)
VALUE_14 VARCHAR2 (80)
VALUE_15 VARCHAR2 (80)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
NAME_1 VARCHAR2 (80)
NAME_2 VARCHAR2 (80)
NAME_3 VARCHAR2 (80)
NAME_4 VARCHAR2 (80)
NAME_5 VARCHAR2 (80)
NAME_6 VARCHAR2 (80)
NAME_7 VARCHAR2 (80)
NAME_8 VARCHAR2 (80)
NAME_9 VARCHAR2 (80)
NAME_10 VARCHAR2 (80)
NAME_11 VARCHAR2 (80)
NAME_12 VARCHAR2 (80)
NAME_13 VARCHAR2 (80)
NAME_14 VARCHAR2 (80)
NAME_15 VARCHAR2 (80)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ELEMENT_TYPE_ID
,      ELEMENT_NAME
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      BATCH_LINE_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      ASSIGNMENT_ID
,      BATCH_ID
,      BATCH_LINE_STATUS
,      ASSIGNMENT_NUMBER
,      BATCH_SEQUENCE
,      CONCATENATED_SEGMENTS
,      EFFECTIVE_DATE
,      ENTRY_TYPE
,      REASON
,      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
,      VALUE_1
,      VALUE_2
,      VALUE_3
,      VALUE_4
,      VALUE_5
,      VALUE_6
,      VALUE_7
,      VALUE_8
,      VALUE_9
,      VALUE_10
,      VALUE_11
,      VALUE_12
,      VALUE_13
,      VALUE_14
,      VALUE_15
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      NAME_1
,      NAME_2
,      NAME_3
,      NAME_4
,      NAME_5
,      NAME_6
,      NAME_7
,      NAME_8
,      NAME_9
,      NAME_10
,      NAME_11
,      NAME_12
,      NAME_13
,      NAME_14
,      NAME_15
FROM APPS.PAY_PDT_BATCH_LINES_V2;

Dependencies

[top of page]

APPS.PAY_PDT_BATCH_LINES_V2 references the following:

SchemaAPPS
ViewPAY_PDT_BATCH_LINES_V1
APPS.PAY_PDT_BATCH_LINES_V2 is referenced by following:

SchemaAPPS
ViewPAY_PDT_BATCH_LINES_V3