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


VIEW: APPS.PAFV_EXPENDITURES

Object Details
Object Name: PAFV_EXPENDITURES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PAFV_EXPENDITURES
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_ID NUMBER (15) Yes
DESCRIPTION VARCHAR2 (250)

CONTROL_TOTAL_AMOUNT NUMBER (22)

EXPENDITURE_ENDING_DATE DATE
Yes
EXPENDITURE_GROUP VARCHAR2 (240) Yes
EXPENDITURE_GROUP_DESCRIPTION VARCHAR2 (250)

INCURRED_BY_PERSON_ID NUMBER (15)

PERSON_FULL_NAME VARCHAR2 (240)

INCURRED_BY_ORGANIZATION_ID NUMBER (15)

ORGANIZATION_NAME VARCHAR2 (240)

ORG_ID NUMBER (15) Yes
ORG_NAME VARCHAR2 (240)
ORIG_EXP_TXN_REFERENCE1 VARCHAR2 (60)
ORIG_USER_EXP_TXN_REFERENCE VARCHAR2 (60)
VENDOR_ID NUMBER

ORIG_EXP_TXN_REFERENCE2 VARCHAR2 (60)
ORIG_EXP_TXN_REFERENCE3 VARCHAR2 (60)
OVERRIDING_APPROVER_PERSON_ID NUMBER


WF_STATUS_CODE VARCHAR2 (30)

USER_BATCH_NAME VARCHAR2 (50)

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
TRANSFER_STATUS_CODE VARCHAR2 (1)

_LA:EXPENDITURE_STATUS CHAR (65)
_LA:EXPENDITURE_CLASS CHAR (68)
_DF CHAR (36)
Query Text

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


SELECT EXPENDITURE_ID
,      DESCRIPTION
,      CONTROL_TOTAL_AMOUNT
,      EXPENDITURE_ENDING_DATE
,      EXPENDITURE_GROUP
,      EXPENDITURE_GROUP_DESCRIPTION
,      INCURRED_BY_PERSON_ID
,      PERSON_FULL_NAME
,      INCURRED_BY_ORGANIZATION_ID
,      ORGANIZATION_NAME
,      ORG_ID
,      ORG_NAME
,      ORIG_EXP_TXN_REFERENCE1
,      ORIG_USER_EXP_TXN_REFERENCE
,      VENDOR_ID
,      ORIG_EXP_TXN_REFERENCE2
,      ORIG_EXP_TXN_REFERENCE3
,      OVERRIDING_APPROVER_PERSON_ID
,      WF_STATUS_CODE
,      USER_BATCH_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      TRANSFER_STATUS_CODE
,      _LA:EXPENDITURE_STATUS
,      _LA:EXPENDITURE_CLASS
,      _DF
FROM APPS.PAFV_EXPENDITURES;

Dependencies

[top of page]

APPS.PAFV_EXPENDITURES references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymPA_EXPENDITURES_ALL
SynonymPA_EXPENDITURE_GROUPS_ALL
SynonymPER_ALL_PEOPLE_F

APPS.PAFV_EXPENDITURES is not referenced by any database object