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

TABLE: PA.PA_ALLOC_SOURCE_LINES

Object Details
Object Name: PA_ALLOC_SOURCE_LINES
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_ALLOC_SOURCE_LINES
Subobject Name:
Status: VALID


PA_ALLOC_SOURCE_LINES stores source lines for each allocation rule.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_ALLOC_SOURCE_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
ColumnLINE_NUM
PA_ALLOC_SOURCE_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
ColumnEXCLUDE_FLAG
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes Unique identifier for an allocation rule for the source line
LINE_NUM NUMBER
Yes Line number
EXCLUDE_FLAG VARCHAR2 (1) Yes The flag indicates whether to exclude returned projects Y means exclude
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
PROJECT_ORG_ID NUMBER

Project organization id
TASK_ORG_ID NUMBER

Task organization id
PROJECT_TYPE VARCHAR2 (20)
Project type
CLASS_CATEGORY VARCHAR2 (30)
Class category
CLASS_CODE VARCHAR2 (30)
Class code
SERVICE_TYPE VARCHAR2 (30)
Service type
PROJECT_ID NUMBER

Project id
TASK_ID NUMBER

Task id
Query Text

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


SELECT RULE_ID
,      LINE_NUM
,      EXCLUDE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROJECT_ORG_ID
,      TASK_ORG_ID
,      PROJECT_TYPE
,      CLASS_CATEGORY
,      CLASS_CODE
,      SERVICE_TYPE
,      PROJECT_ID
,      TASK_ID
FROM PA.PA_ALLOC_SOURCE_LINES;

Dependencies

[top of page]

PA.PA_ALLOC_SOURCE_LINES does not reference any database object

PA.PA_ALLOC_SOURCE_LINES is referenced by following:

SchemaPA
ViewPA_ALLOC_SOURCE_LINES#