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


VIEW: APPS.PA_BUDGET_MATRIX_V

Object Details
Object Name: PA_BUDGET_MATRIX_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_BUDGET_MATRIX_V
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
BUDGET_VERSION_ID NUMBER (15)

TASK_ID NUMBER (15)

P1_AMT NUMBER


P2_AMT NUMBER


P3_AMT NUMBER


P4_AMT NUMBER


RESOURCE_ASSIGNMENT_ID NUMBER (15)

RESOURCE_LIST_MEMBER_ID NUMBER (15)

RESOURCE_LIST_ID NUMBER (15)

RESOURCE_ID NUMBER (15)

RESOURCE_NAME VARCHAR2 (80)

UNIT_OF_MEASURE VARCHAR2 (30)

TRACK_AS_LABOR_FLAG VARCHAR2 (1)

AMT_TYPE VARCHAR2 (30)

AMT_TYPE_DESC VARCHAR2 (80)

SEQ_NO NUMBER


DF_LONG_P1_1 VARCHAR2 (1530)

DF_LONG_P1_2 VARCHAR2 (1329)

DF_LONG_P2_1 VARCHAR2 (1530)

DF_LONG_P2_2 VARCHAR2 (1329)

DF_LONG_P3_1 VARCHAR2 (1530)

DF_LONG_P3_2 VARCHAR2 (1329)

DF_LONG_P4_1 VARCHAR2 (1530)

DF_LONG_P4_2 VARCHAR2 (1329)

ATTRIBUTE_CATEGORY VARCHAR2 (0)

ATTRIBUTE1 VARCHAR2 (0)

ATTRIBUTE2 VARCHAR2 (0)

ATTRIBUTE3 VARCHAR2 (0)

ATTRIBUTE4 VARCHAR2 (0)

ATTRIBUTE5 VARCHAR2 (0)

ATTRIBUTE6 VARCHAR2 (0)

ATTRIBUTE7 VARCHAR2 (0)

ATTRIBUTE8 VARCHAR2 (0)

ATTRIBUTE9 VARCHAR2 (0)

ATTRIBUTE10 VARCHAR2 (0)

ATTRIBUTE11 VARCHAR2 (0)

ATTRIBUTE12 VARCHAR2 (0)

ATTRIBUTE13 VARCHAR2 (0)

ATTRIBUTE14 VARCHAR2 (0)

ATTRIBUTE15 VARCHAR2 (0)

CHANGE_REASON_M VARCHAR2 (0)

DESCRIPTION VARCHAR2 (0)

LAST_UPDATE_DATE DATE


LAST_UPDATED_BY NUMBER


CREATION_DATE DATE


CREATED_BY NUMBER


LAST_UPDATE_LOGIN NUMBER


LAST_UPDATE_DATE_P1 DATE


LAST_UPDATED_BY_P1 NUMBER


CREATION_DATE_P1 DATE


CREATED_BY_P1 NUMBER


LAST_UPDATE_LOGIN_P1 NUMBER


LAST_UPDATE_DATE_P2 DATE


LAST_UPDATED_BY_P2 NUMBER


CREATION_DATE_P2 DATE


CREATED_BY_P2 NUMBER


LAST_UPDATE_LOGIN_P2 NUMBER


LAST_UPDATE_DATE_P3 DATE


LAST_UPDATED_BY_P3 NUMBER


CREATION_DATE_P3 DATE


CREATED_BY_P3 NUMBER


LAST_UPDATE_LOGIN_P3 NUMBER


LAST_UPDATE_DATE_P4 DATE


LAST_UPDATED_BY_P4 NUMBER


CREATION_DATE_P4 DATE


CREATED_BY_P4 NUMBER


LAST_UPDATE_LOGIN_P4 NUMBER


PARENT_MEMBER_ID NUMBER

Query Text

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


SELECT BUDGET_VERSION_ID
,      TASK_ID
,      P1_AMT
,      P2_AMT
,      P3_AMT
,      P4_AMT
,      RESOURCE_ASSIGNMENT_ID
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_LIST_ID
,      RESOURCE_ID
,      RESOURCE_NAME
,      UNIT_OF_MEASURE
,      TRACK_AS_LABOR_FLAG
,      AMT_TYPE
,      AMT_TYPE_DESC
,      SEQ_NO
,      DF_LONG_P1_1
,      DF_LONG_P1_2
,      DF_LONG_P2_1
,      DF_LONG_P2_2
,      DF_LONG_P3_1
,      DF_LONG_P3_2
,      DF_LONG_P4_1
,      DF_LONG_P4_2
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CHANGE_REASON_M
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE_P1
,      LAST_UPDATED_BY_P1
,      CREATION_DATE_P1
,      CREATED_BY_P1
,      LAST_UPDATE_LOGIN_P1
,      LAST_UPDATE_DATE_P2
,      LAST_UPDATED_BY_P2
,      CREATION_DATE_P2
,      CREATED_BY_P2
,      LAST_UPDATE_LOGIN_P2
,      LAST_UPDATE_DATE_P3
,      LAST_UPDATED_BY_P3
,      CREATION_DATE_P3
,      CREATED_BY_P3
,      LAST_UPDATE_LOGIN_P3
,      LAST_UPDATE_DATE_P4
,      LAST_UPDATED_BY_P4
,      CREATION_DATE_P4
,      CREATED_BY_P4
,      LAST_UPDATE_LOGIN_P4
,      PARENT_MEMBER_ID
FROM APPS.PA_BUDGET_MATRIX_V;

Dependencies

[top of page]

APPS.PA_BUDGET_MATRIX_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymPA_BUDGET_LINES
PL/SQL PackagePA_BUDGET_MATRIX - show dependent code
SynonymPA_RESOURCE_ASSIGNMENTS
SynonymPA_RESOURCE_LIST_MEMBERS

APPS.PA_BUDGET_MATRIX_V is not referenced by any database object