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


VIEW: APPS.PA_EXPENDITURE_ITEMS_V

Object Details
Object Name: PA_EXPENDITURE_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_EXPENDITURE_ITEMS_V
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
ROW_ID ROWID (10)
EXPENDITURE_ITEM_ID NUMBER (15) Yes
EXPENDITURE_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
PROJECT_NUMBER VARCHAR2 (25) Yes
PROJECT_NAME VARCHAR2 (30) Yes
TASK_ID NUMBER (15) Yes
TASK_NUMBER VARCHAR2 (278)
TASK_NAME VARCHAR2 (273)
TASK_DESCRIPTION VARCHAR2 (250)
NLR_ORGANIZATION_NAME VARCHAR2 (240)
EXPENDITURE_GROUP VARCHAR2 (240) Yes
EXPENDITURE_STATUS_CODE VARCHAR2 (30) Yes
INCURRED_BY_PERSON_ID NUMBER (15)
UNIT_OF_MEASURE_M VARCHAR2 (80) Yes
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3) Yes
EXPENDITURE_ITEM_DATE DATE
Yes
EXPENDITURE_TYPE VARCHAR2 (30) Yes
EXPENDITURE_COMMENT VARCHAR2 (240)
COST_DISTRIBUTED_FLAG VARCHAR2 (1) Yes
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1) Yes
BILLABLE_FLAG VARCHAR2 (1) Yes
BILL_HOLD_FLAG VARCHAR2 (1) Yes
QUANTITY NUMBER

NON_LABOR_RESOURCE VARCHAR2 (20)
ORGANIZATION_ID NUMBER (15)
OVERRIDE_TO_ORGANIZATION_ID NUMBER (15)
RAW_COST NUMBER

RAW_COST_RATE NUMBER

BURDEN_COST NUMBER

BURDEN_COST_RATE NUMBER

COST_DIST_REJECTION_CODE VARCHAR2 (30)
LABOR_COST_MULTIPLIER_NAME VARCHAR2 (20)
RAW_REVENUE NUMBER (22)
BILL_RATE NUMBER (22)
ACCRUED_REVENUE NUMBER (22)
ACCRUAL_RATE NUMBER (22)
ADJUSTED_REVENUE NUMBER (22)
ADJUSTED_RATE NUMBER (22)
BILL_AMOUNT NUMBER (22)
FORECAST_REVENUE NUMBER (22)
BILL_RATE_MULTIPLIER NUMBER (22)
REV_DIST_REJECTION_CODE VARCHAR2 (30)
EVENT_NUM NUMBER (15)
EVENT_TASK_ID NUMBER (15)
BILL_JOB_ID NUMBER (15)
BILL_JOB_BILLING_TITLE VARCHAR2 (80)
BILL_EMPLOYEE_BILLING_TITLE VARCHAR2 (80)
ADJUSTED_EXPENDITURE_ITEM_ID NUMBER (15)
NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 (1)
TRANSFERRED_FROM_EXP_ITEM_ID NUMBER (15)
CONVERTED_FLAG VARCHAR2 (1)
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
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
COST_IND_COMPILED_SET_ID NUMBER (15)
REV_IND_COMPILED_SET_ID NUMBER (15)
INV_IND_COMPILED_SET_ID NUMBER (15)
COST_BURDEN_DISTRIBUTED_FLAG VARCHAR2 (1)
IND_COST_DIST_REJECTION_CODE VARCHAR2 (30)
ORIG_TRANSACTION_REFERENCE VARCHAR2 (50)
TRANSACTION_SOURCE VARCHAR2 (30)
SOURCE_EXPENDITURE_ITEM_ID NUMBER (15)
JOB_ID NUMBER (15)
USER_TRANSACTION_SOURCE VARCHAR2 (80)
BURDEN_SUM_DEST_RUN_ID NUMBER (15)
Burden Summarization Destination Run Id
RECEIPT_CURRENCY_AMOUNT NUMBER

Receipt currency amount of the transaction
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
Receipt currency code of the transaction
RECEIPT_EXCHANGE_RATE NUMBER

Receipt exchange rate for the transaction
DENOM_CURRENCY_CODE VARCHAR2 (15)
Denomination currency code of the transaction
DENOM_RAW_COST NUMBER

Raw cost in denomination currency
DENOM_BURDENED_COST NUMBER

Burdened cost in Denomination currency
ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER

Rounding limit for imported transactions
ACCT_CURRENCY_CODE VARCHAR2 (15)
Account currency code of the transaction
ACCT_RATE_DATE DATE

Accounting rate date for the transaction
ACCT_RATE_TYPE VARCHAR2 (30)
Accounting rate type for the transaction
ACCT_EXCHANGE_RATE NUMBER

Accounting exchange rate for the transaction
ACCT_RAW_COST NUMBER

Raw cost in accounting currency
ACCT_BURDENED_COST NUMBER

Burdened cost in Accounting currency
PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project currency code of the transaction
PROJECT_RATE_DATE DATE

Project rate date for the transaction
PROJECT_RATE_TYPE VARCHAR2 (30)
Project rate type for the transaction
PROJECT_EXCHANGE_RATE NUMBER

Project exchange rate for the transaction
COST_RATE_FLAG VARCHAR2 (1) Yes Cost Rate Flag
INCURRED_BY_ORGANIZATION_ID NUMBER (15)
ALLOW_REVERSAL_FLAG VARCHAR2 (1)
Expenditure Group is allowed to be reversed or not
RECVR_ORG_ID NUMBER (15)
COST_JOB_ID NUMBER (15)
Costing Job Id
PROV_PROJ_BILL_JOB_ID NUMBER (15)
Provider Project Job Id
TP_JOB_ID NUMBER (15)
Borrow Lent Job Id
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_BILL_AMOUNT NUMBER

PROJECT_BILL_AMOUNT NUMBER

PROJFUNC_RAW_REVENUE NUMBER

PROJECT_RAW_REVENUE NUMBER

PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
PROJFUNC_COST_RATE_DATE DATE

PROJFUNC_COST_EXCHANGE_RATE NUMBER

PROJECT_RAW_COST NUMBER

PROJECT_BURDENED_COST NUMBER

ASSIGNMENT_ID NUMBER (15)
WORK_TYPE_ID NUMBER (15)
TP_AMT_TYPE_CODE VARCHAR2 (30)
WORK_TYPE_NAME VARCHAR2 (4000)
ASSIGNMENT_NAME VARCHAR2 (4000)
PRVDR_ACCRUAL_DATE DATE

The accrual date for the provider side of the expenditure item
RECVR_ACCRUAL_DATE DATE

The accrual date for the receiver side of the expenditure item
CAPITAL_EVENT_ID NUMBER (15)
Identifier of the Capital Event
PO_LINE_ID NUMBER

PO_PRICE_TYPE VARCHAR2 (30)
PO_NUMBER VARCHAR2 (20)
PO_LINE_NUMBER NUMBER

PO_PRICE_TYPE_M VARCHAR2 (80)
WIP_RESOURCE_ID NUMBER

INVENTORY_ITEM_ID NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
DOCUMENT_HEADER_ID NUMBER (15)
DOCUMENT_DISTRIBUTION_ID NUMBER (15)
DOCUMENT_LINE_NUMBER NUMBER (15)
DOCUMENT_PAYMENT_ID NUMBER (15)
DOCUMENT_TYPE VARCHAR2 (30)
DOCUMENT_DISTRIBUTION_TYPE VARCHAR2 (30)
VENDOR_ID NUMBER

CBS_ELEMENT_ID NUMBER (15)
Cost code element id corresponding to the cost code
Query Text

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


SELECT ROW_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ID
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      TASK_DESCRIPTION
,      NLR_ORGANIZATION_NAME
,      EXPENDITURE_GROUP
,      EXPENDITURE_STATUS_CODE
,      INCURRED_BY_PERSON_ID
,      UNIT_OF_MEASURE_M
,      SYSTEM_LINKAGE_FUNCTION
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_TYPE
,      EXPENDITURE_COMMENT
,      COST_DISTRIBUTED_FLAG
,      REVENUE_DISTRIBUTED_FLAG
,      BILLABLE_FLAG
,      BILL_HOLD_FLAG
,      QUANTITY
,      NON_LABOR_RESOURCE
,      ORGANIZATION_ID
,      OVERRIDE_TO_ORGANIZATION_ID
,      RAW_COST
,      RAW_COST_RATE
,      BURDEN_COST
,      BURDEN_COST_RATE
,      COST_DIST_REJECTION_CODE
,      LABOR_COST_MULTIPLIER_NAME
,      RAW_REVENUE
,      BILL_RATE
,      ACCRUED_REVENUE
,      ACCRUAL_RATE
,      ADJUSTED_REVENUE
,      ADJUSTED_RATE
,      BILL_AMOUNT
,      FORECAST_REVENUE
,      BILL_RATE_MULTIPLIER
,      REV_DIST_REJECTION_CODE
,      EVENT_NUM
,      EVENT_TASK_ID
,      BILL_JOB_ID
,      BILL_JOB_BILLING_TITLE
,      BILL_EMPLOYEE_BILLING_TITLE
,      ADJUSTED_EXPENDITURE_ITEM_ID
,      NET_ZERO_ADJUSTMENT_FLAG
,      TRANSFERRED_FROM_EXP_ITEM_ID
,      CONVERTED_FLAG
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      COST_IND_COMPILED_SET_ID
,      REV_IND_COMPILED_SET_ID
,      INV_IND_COMPILED_SET_ID
,      COST_BURDEN_DISTRIBUTED_FLAG
,      IND_COST_DIST_REJECTION_CODE
,      ORIG_TRANSACTION_REFERENCE
,      TRANSACTION_SOURCE
,      SOURCE_EXPENDITURE_ITEM_ID
,      JOB_ID
,      USER_TRANSACTION_SOURCE
,      BURDEN_SUM_DEST_RUN_ID
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_EXCHANGE_RATE
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_EXCHANGE_ROUNDING_LIMIT
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      COST_RATE_FLAG
,      INCURRED_BY_ORGANIZATION_ID
,      ALLOW_REVERSAL_FLAG
,      RECVR_ORG_ID
,      COST_JOB_ID
,      PROV_PROJ_BILL_JOB_ID
,      TP_JOB_ID
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_BILL_AMOUNT
,      PROJECT_BILL_AMOUNT
,      PROJFUNC_RAW_REVENUE
,      PROJECT_RAW_REVENUE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      ASSIGNMENT_ID
,      WORK_TYPE_ID
,      TP_AMT_TYPE_CODE
,      WORK_TYPE_NAME
,      ASSIGNMENT_NAME
,      PRVDR_ACCRUAL_DATE
,      RECVR_ACCRUAL_DATE
,      CAPITAL_EVENT_ID
,      PO_LINE_ID
,      PO_PRICE_TYPE
,      PO_NUMBER
,      PO_LINE_NUMBER
,      PO_PRICE_TYPE_M
,      WIP_RESOURCE_ID
,      INVENTORY_ITEM_ID
,      UNIT_OF_MEASURE
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_PAYMENT_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      VENDOR_ID
,      CBS_ELEMENT_ID
FROM APPS.PA_EXPENDITURE_ITEMS_V;

Dependencies

[top of page]

APPS.PA_EXPENDITURE_ITEMS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORG_UNITS_NO_JOIN
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPA_EXPENDITURES
SynonymPA_EXPENDITURE_COMMENTS
SynonymPA_EXPENDITURE_ITEMS
SynonymPA_EXPENDITURE_TYPES
ViewPA_LOOKUPS
SynonymPA_PROJECTS_ALL
SynonymPA_RBS_ELEMENTS
SynonymPA_TASKS
SynonymPA_TRANSACTION_SOURCES
PL/SQL PackagePA_UTILS4 - show dependent code
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL

APPS.PA_EXPENDITURE_ITEMS_V is not referenced by any database object