[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_EXPENDITURE_ITEMS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_EXPENDITURE_ITEMS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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 |
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;
APPS
FND_GLOBAL
- show dependent code
FND_LOOKUPS
HR_ALL_ORGANIZATION_UNITS_TL
HR_GENERAL
- show dependent code
HR_ORG_UNITS_NO_JOIN
HR_SECURITY
- show dependent code
PA_EXPENDITURES
PA_EXPENDITURE_COMMENTS
PA_EXPENDITURE_ITEMS
PA_EXPENDITURE_TYPES
PA_LOOKUPS
PA_PROJECTS_ALL
PA_RBS_ELEMENTS
PA_TASKS
PA_TRANSACTION_SOURCES
PA_UTILS4
- show dependent code
PO_HEADERS_ALL
PO_LINES_ALL
APPS.PA_EXPENDITURE_ITEMS_V is not referenced by any database object
|
|
|
|