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

VIEW: PA.PA_ALLOC_RUN_BASIS_DET_EFC#

Object Details
Object Name: PA_ALLOC_RUN_BASIS_DET_EFC#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER
Yes
RULE_ID NUMBER
Yes
LINE_NUM NUMBER
Yes
PROJECT_ID NUMBER
Yes
TASK_ID NUMBER
Yes
CREATION_DATE DATE
Yes
RESOURCE_LIST_MEMBER_ID NUMBER

AMOUNT NUMBER

BASIS_PERCENT NUMBER

LINE_PERCENT NUMBER

SET_OF_BOOKS_ID NUMBER

Query Text

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


SELECT RUN_ID
,      RULE_ID
,      LINE_NUM
,      PROJECT_ID
,      TASK_ID
,      CREATION_DATE
,      RESOURCE_LIST_MEMBER_ID
,      AMOUNT
,      BASIS_PERCENT
,      LINE_PERCENT
,      SET_OF_BOOKS_ID
FROM PA.PA_ALLOC_RUN_BASIS_DET_EFC#;

Dependencies

[top of page]

PA.PA_ALLOC_RUN_BASIS_DET_EFC# references the following:

SchemaPA
TablePA_ALLOC_RUN_BASIS_DET_EFC
PA.PA_ALLOC_RUN_BASIS_DET_EFC# is referenced by following:

SchemaAPPS
SynonymPA_ALLOC_RUN_BASIS_DET_EFC