[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_EXPENDITURE_ITEMS_ONLINE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_EXPENDITURE_ITEMS_ONLINE_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) | ||
| SEARCH_CRITERIA | CHAR | (1) | ||
| 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 | |
| PROJECT_TYPE | VARCHAR2 | (20) | Yes | |
| PROJECT_TYPE_CLASS_CODE | VARCHAR2 | (30) | ||
| TASK_ID | NUMBER | (15) | Yes | |
| TASK_NUMBER | VARCHAR2 | (25) | Yes | |
| TASK_NAME | VARCHAR2 | (20) | Yes | |
| EXPENDITURE_ITEM_DATE | DATE | Yes | ||
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | |
| EXPENDITURE_CATEGORY | VARCHAR2 | (30) | ||
| REVENUE_CATEGORY_CODE | VARCHAR2 | (30) | ||
| INCURRED_BY_PERSON_ID | NUMBER | (15) | ||
| EMPLOYEE_NAME | VARCHAR2 | (240) | ||
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| JOB_ID | NUMBER | (15) | ||
| JOB_NAME | VARCHAR2 | (700) | ||
| INCURRED_BY_ORGANIZATION_ID | NUMBER | (15) | ||
| OVERRIDE_TO_ORGANIZATION_ID | NUMBER | (15) | ||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
| EXPENDITURE_ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
| NON_LABOR_RESOURCE | VARCHAR2 | (20) | ||
| NLR_ORGANIZATION_ID | NUMBER | (15) | ||
| NLR_ORGANIZATION_NAME | VARCHAR2 | (4000) | ||
| SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | (3) | Yes | |
| EXPENDITURE_COMMENT | VARCHAR2 | (240) | ||
| TRANSACTION_SOURCE | VARCHAR2 | (30) | ||
| ORIG_TRANSACTION_REFERENCE | VARCHAR2 | (50) | ||
| EXPENDITURE_GROUP | VARCHAR2 | (240) | Yes | |
| EXPENDITURE_STATUS_CODE | VARCHAR2 | (30) | Yes | |
| EXPENDITURE_ENDING_DATE | DATE | Yes | ||
| QUANTITY | NUMBER | |||
| BURDEN_COST | NUMBER | |||
| UNIT_OF_MEASURE | VARCHAR2 | (4000) | ||
| UNIT_OF_MEASURE_M | VARCHAR2 | (4000) | ||
| RAW_COST | NUMBER | |||
| RAW_COST_RATE | NUMBER | |||
| COST_DISTRIBUTED_FLAG | VARCHAR2 | (1) | Yes | |
| COST_DIST_REJECTION_CODE | VARCHAR2 | (30) | ||
| LABOR_COST_MULTIPLIER_NAME | VARCHAR2 | (20) | ||
| BURDENED_COST | NUMBER | |||
| BURDENED_COST_RATE | NUMBER | |||
| RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | ||
| RECEIPT_EXCHANGE_RATE | NUMBER | |||
| RECEIPT_CURRENCY_AMOUNT | NUMBER | |||
| DENOM_CURRENCY_CODE | VARCHAR2 | (15) | ||
| DENOM_RAW_COST | NUMBER | |||
| DENOM_BURDENED_COST | NUMBER | |||
| ACCT_EXCHANGE_ROUNDING_LIMIT | NUMBER | |||
| ACCT_CURRENCY_CODE | VARCHAR2 | (15) | ||
| ACCT_RATE_TYPE | VARCHAR2 | (30) | ||
| ACCT_RATE_DATE | DATE | |||
| ACCT_EXCHANGE_RATE | NUMBER | |||
| ACCT_RAW_COST | NUMBER | |||
| ACCT_BURDENED_COST | NUMBER | |||
| PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
| PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJECT_RATE_DATE | DATE | |||
| PROJECT_EXCHANGE_RATE | NUMBER | |||
| COST_BURDEN_DISTRIBUTED_FLAG | VARCHAR2 | (1) | ||
| IND_COST_DIST_REJECTION_CODE | VARCHAR2 | (30) | ||
| COST_IND_COMPILED_SET_ID | NUMBER | (15) | ||
| CAPITALIZABLE_FLAG | VARCHAR2 | (1) | ||
| ACCRUED_REVENUE | NUMBER | (22) | ||
| ACCRUAL_RATE | NUMBER | (22) | ||
| RAW_REVENUE | NUMBER | (22) | ||
| FORECAST_REVENUE | NUMBER | (22) | ||
| BILL_AMOUNT | NUMBER | (22) | ||
| BILL_RATE | NUMBER | (22) | ||
| BILL_RATE_MULTIPLIER | NUMBER | (22) | ||
| ADJUSTED_REVENUE | NUMBER | (22) | ||
| ADJUSTED_RATE | NUMBER | (22) | ||
| BILLABLE_FLAG | VARCHAR2 | (1) | ||
| GROUPED_CIP_FLAG | VARCHAR2 | (1) | ||
| REVENUE_DISTRIBUTED_FLAG | VARCHAR2 | (1) | ||
| BILL_HOLD_FLAG | VARCHAR2 | (1) | Yes | |
| REV_DIST_REJECTION_CODE | VARCHAR2 | (30) | ||
| BILL_JOB_ID | NUMBER | (15) | ||
| BILL_JOB_BILLING_TITLE | VARCHAR2 | (80) | ||
| BILL_EMPLOYEE_BILLING_TITLE | VARCHAR2 | (80) | ||
| REV_IND_COMPILED_SET_ID | NUMBER | (15) | ||
| INV_IND_COMPILED_SET_ID | NUMBER | (15) | ||
| EVENT_NUM | NUMBER | (15) | ||
| EVENT_TASK_ID | NUMBER | (15) | ||
| EVENT_PROJECT_ID | NUMBER | (15) | ||
| ADJUSTED_EXPENDITURE_ITEM_ID | NUMBER | (15) | ||
| NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
| TRANSFERRED_FROM_EXP_ITEM_ID | NUMBER | (15) | ||
| TRANSFERRED_ITEM_FLAG | VARCHAR2 | (1) | ||
| CONVERTED_FLAG | VARCHAR2 | (1) | ||
| SOURCE_EXPENDITURE_ITEM_ID | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ORG_ID | NUMBER | (15) | ||
| EXPENDITURE_ORG_ID | NUMBER | (15) | ||
| USER_TRANSACTION_SOURCE | VARCHAR2 | (80) | ||
| ALLOW_ADJUSTMENTS_FLAG | VARCHAR2 | (1) | ||
| COSTED_FLAG | VARCHAR2 | (1) | ||
| COST_BURDENED_FLAG | VARCHAR2 | (1) | ||
| GL_ACCOUNTED_FLAG | VARCHAR2 | (1) | ||
| ALLOW_REVERSAL_FLAG | VARCHAR2 | (1) | ||
| ALLOW_BURDEN_FLAG | VARCHAR2 | (1) | ||
| BURDEN_SUM_DEST_RUN_ID | NUMBER | (15) | ||
| PROJECT_STATUS_CODE | VARCHAR2 | (30) | Yes | |
| USER_ACCT_RATE_TYPE | VARCHAR2 | (30) | ||
| USER_PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
| 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) | ||
| TRANSFER_STATUS_CODE | VARCHAR2 | (1) | ||
| USER_BATCH_NAME | VARCHAR2 | (50) | ||
| CC_PRVDR_ORGANIZATION_ID | NUMBER | |||
| CC_RECVR_ORGANIZATION_ID | NUMBER | |||
| CC_PRVDR_ORGANIZATION_NAME | VARCHAR2 | (4000) | ||
| CC_RECVR_ORGANIZATION_NAME | VARCHAR2 | (4000) | ||
| PRVDR_ORG_ID | NUMBER | (15) | ||
| RECVR_ORG_ID | NUMBER | |||
| PRVDR_ORG_NAME | VARCHAR2 | (4000) | ||
| RECVR_ORG_NAME | VARCHAR2 | (4000) | ||
| CC_CROSS_CHARGE_CODE | VARCHAR2 | (1) | Yes | |
| CC_CROSS_CHARGE_TYPE | VARCHAR2 | (2) | ||
| CC_REJECTION_CODE | VARCHAR2 | (30) | ||
| CC_BL_DISTRIBUTED_CODE | VARCHAR2 | (1) | Yes | |
| CC_IC_PROCESSED_CODE | VARCHAR2 | (1) | Yes | |
| DENOM_TP_CURRENCY_CODE | VARCHAR2 | (15) | ||
| DENOM_TRANSFER_PRICE | NUMBER | |||
| ACCT_TP_RATE_TYPE | VARCHAR2 | (30) | ||
| USER_ACCT_TP_RATE_TYPE | VARCHAR2 | (30) | ||
| ACCT_TP_RATE_DATE | DATE | |||
| ACCT_TP_EXCHANGE_RATE | NUMBER | |||
| ACCT_TRANSFER_PRICE | NUMBER | |||
| PROJACCT_TRANSFER_PRICE | NUMBER | |||
| BILL_JOB_NAME | VARCHAR2 | (4000) | ||
| COST_JOB_ID | NUMBER | (15) | ||
| COST_JOB_NAME | VARCHAR2 | (4000) | ||
| TP_JOB_ID | NUMBER | (15) | ||
| TP_JOB_NAME | VARCHAR2 | (4000) | ||
| PROV_PROJ_BILL_JOB_ID | NUMBER | (15) | ||
| PROV_PROJ_BILL_JOB_NAME | VARCHAR2 | (4000) | ||
| BILL_TRANS_FORECAST_CURR_CODE | VARCHAR2 | (15) | ||
| BILL_TRANS_FORECAST_REVENUE | NUMBER | |||
| BILL_TRANS_CURRENCY_CODE | VARCHAR2 | (15) | ||
| BILL_TRANS_RAW_REVENUE | NUMBER | |||
| BILL_TRANS_BILL_AMOUNT | NUMBER | |||
| PROJECT_RAW_REVENUE | NUMBER | |||
| PROJECT_BILL_AMOUNT | NUMBER | |||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
| PROJFUNC_RAW_REVENUE | NUMBER | |||
| PROJFUNC_BILL_AMOUNT | NUMBER | |||
| INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
| 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) | ||
| PROJECT_TP_RATE_DATE | DATE | |||
| PROJECT_TP_RATE_TYPE | VARCHAR2 | (30) | ||
| USER_PROJECT_TP_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJECT_TP_EXCHANGE_RATE | NUMBER | |||
| PROJECT_TRANSFER_PRICE | NUMBER | |||
| WORK_TYPE_NAME | VARCHAR2 | (4000) | ||
| ASSIGNMENT_NAME | VARCHAR2 | (4000) | ||
| TP_AMT_TYPE_CODE | VARCHAR2 | (30) | ||
| PROJFUNC_TP_RATE_DATE | DATE | |||
| PROJFUNC_TP_RATE_TYPE | VARCHAR2 | (30) | ||
| USER_PROJFUNC_TP_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJFUNC_TP_EXCHANGE_RATE | NUMBER | |||
| PROJFUNC_TRANSFER_PRICE | NUMBER | |||
| USER_PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
| PRVDR_ACCRUAL_DATE | DATE | |||
| RECVR_ACCRUAL_DATE | DATE | |||
| RETIREMENT_COST_FLAG | VARCHAR2 | (1) | ||
| CAPITAL_EVENT_NUMBER | NUMBER | |||
| GROUPED_RWIP_FLAG | VARCHAR2 | (1) | ||
| LATEST_PA_DATE | DATE | |||
| LATEST_GL_DATE | DATE | |||
| LATEST_RECVR_PA_DATE | DATE | |||
| LATEST_RECVR_GL_DATE | DATE | |||
| LATEST_PA_PERIOD_NAME | VARCHAR2 | (15) | ||
| LATEST_GL_PERIOD_NAME | VARCHAR2 | (15) | ||
| LATEST_RECVR_PA_PERIOD_NAME | VARCHAR2 | (15) | ||
| LATEST_RECVR_GL_PERIOD_NAME | VARCHAR2 | (15) | ||
| PERSON_TYPE | VARCHAR2 | (30) | ||
| PO_LINE_ID | NUMBER | |||
| PO_PRICE_TYPE | VARCHAR2 | (30) | ||
| PO_NUMBER | VARCHAR2 | (20) | ||
| PO_LINE_NUMBER | NUMBER | |||
| PO_PRICE_TYPE_M | VARCHAR2 | (80) | ||
| PA_PERSON_TYPE_M | VARCHAR2 | (80) | ||
| WIP_RESOURCE_ID | NUMBER | |||
| WIP_RESOURCE | VARCHAR2 | (4000) | ||
| INVENTORY_ITEM_ID | NUMBER | |||
| INVENTORY_ITEM | VARCHAR2 | (4000) | ||
| DOCUMENT_HEADER_ID | NUMBER | (15) | The header-level record identifier from another application. If the expenditure item originated in Oracle Payables, then the column holds AP_INVOICES_ALL.INVOICE_ID. If the expenditure item originated in Oracle Purchasing, then the column holds PO_HEADERS_ALL.PO_HEADER_ID. | |
| DOCUMENT_DISTRIBUTION_ID | NUMBER | (15) | The distribution-level record identifier from another application. If the expenditure item originated in Oracle Payables, then the column holds AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID. If the expenditure item originated in Oracle Purchasing, then the column holds RCV_TRANSACTIONS.TRANSACTION_ID. | |
| DOCUMENT_LINE_NUMBER | NUMBER | (15) | The line-level record identifier from another application. If the expenditure item originated in Oracle Payables, then the column holds AP_INVOICE_LINES_ALL.LINE_NUMBER. If the expenditure item originated in Oracle Purchasing, then the column holds PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID. | |
| DOCUMENT_PAYMENT_ID | NUMBER | (15) | The payment record identifier from Oracle Payables. The column holds AP_PAYMENT_HIST_DISTS.INVOICE_PAYMENT_ID. This column is populated when you use cash basis accounting. It is also populated for payment discounts when you use accrual basis accounting. | |
| DOCUMENT_TYPE | VARCHAR2 | (30) | The document type for supplier costs. If the expenditure item originated in Oracle Payables, then the column holds AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE. If the expenditure item originated in Oracle Purchasing, then the column holds RCV_TRANSACTIONS.DESTINATION_TYPE_CODE. | |
| DOCUMENT_DISTRIBUTION_TYPE | VARCHAR2 | (30) | The distribution type for supplier costs. If the expenditure item originated in Oracle Payables, then the column holds AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE. If the expenditure item originated in Oracle Purchasing, then the column holds RCV_TRANSACTIONS.TRANSACTION_TYPE. | |
| EXPENSED | VARCHAR2 | (1) | This column indicates whether or not the expenditure item is expensed on a capital project. | |
| AGREEMENT_ID | NUMBER | |||
| AGREEMENT_NUMBER | NUMBER | |||
| LOCATION_ID | NUMBER | (15) | HR location identifier | |
| LOCATION_CODE | VARCHAR2 | (60) | Name of the location | |
| PAY_ELEMENT_TYPE_ID | NUMBER | (15) | Identifier of the pay element type | |
| PAY_ELEMENT_NAME | VARCHAR2 | (80) | Name of the timecard pay element | |
| COSTING_METHOD_M | VARCHAR2 | (80) | Meaning of the lookup code for the costing method | |
| RATE_SOURCE_M | VARCHAR2 | (80) | Meaning of the lookup code for the rate source | |
| PAYROLL_ACCRUAL_FLAG | VARCHAR2 | (1) | Flag to indicate if the labor costs are accrued to a project | |
| COSTED_PAYROLL_SET_ID | NUMBER | (15) | Unique identifier generated in Oracle Projects when you run the Interface Payroll Process | |
| PAYROLL_NAME | VARCHAR2 | (80) | Name of the payroll | |
| PAY_PERIOD_START_DATE | DATE | Start date of the pay period | ||
| PAY_PERIOD_END_DATE | DATE | End date of the pay period |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SEARCH_CRITERIA
, EXPENDITURE_ITEM_ID
, EXPENDITURE_ID
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_TYPE
, PROJECT_TYPE_CLASS_CODE
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY_CODE
, INCURRED_BY_PERSON_ID
, EMPLOYEE_NAME
, EMPLOYEE_NUMBER
, JOB_ID
, JOB_NAME
, INCURRED_BY_ORGANIZATION_ID
, OVERRIDE_TO_ORGANIZATION_ID
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ORGANIZATION_NAME
, NON_LABOR_RESOURCE
, NLR_ORGANIZATION_ID
, NLR_ORGANIZATION_NAME
, SYSTEM_LINKAGE_FUNCTION
, EXPENDITURE_COMMENT
, TRANSACTION_SOURCE
, ORIG_TRANSACTION_REFERENCE
, EXPENDITURE_GROUP
, EXPENDITURE_STATUS_CODE
, EXPENDITURE_ENDING_DATE
, QUANTITY
, BURDEN_COST
, UNIT_OF_MEASURE
, UNIT_OF_MEASURE_M
, RAW_COST
, RAW_COST_RATE
, COST_DISTRIBUTED_FLAG
, COST_DIST_REJECTION_CODE
, LABOR_COST_MULTIPLIER_NAME
, BURDENED_COST
, BURDENED_COST_RATE
, RECEIPT_CURRENCY_CODE
, RECEIPT_EXCHANGE_RATE
, RECEIPT_CURRENCY_AMOUNT
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_EXCHANGE_ROUNDING_LIMIT
, ACCT_CURRENCY_CODE
, ACCT_RATE_TYPE
, ACCT_RATE_DATE
, ACCT_EXCHANGE_RATE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_TYPE
, PROJECT_RATE_DATE
, PROJECT_EXCHANGE_RATE
, COST_BURDEN_DISTRIBUTED_FLAG
, IND_COST_DIST_REJECTION_CODE
, COST_IND_COMPILED_SET_ID
, CAPITALIZABLE_FLAG
, ACCRUED_REVENUE
, ACCRUAL_RATE
, RAW_REVENUE
, FORECAST_REVENUE
, BILL_AMOUNT
, BILL_RATE
, BILL_RATE_MULTIPLIER
, ADJUSTED_REVENUE
, ADJUSTED_RATE
, BILLABLE_FLAG
, GROUPED_CIP_FLAG
, REVENUE_DISTRIBUTED_FLAG
, BILL_HOLD_FLAG
, REV_DIST_REJECTION_CODE
, BILL_JOB_ID
, BILL_JOB_BILLING_TITLE
, BILL_EMPLOYEE_BILLING_TITLE
, REV_IND_COMPILED_SET_ID
, INV_IND_COMPILED_SET_ID
, EVENT_NUM
, EVENT_TASK_ID
, EVENT_PROJECT_ID
, ADJUSTED_EXPENDITURE_ITEM_ID
, NET_ZERO_ADJUSTMENT_FLAG
, TRANSFERRED_FROM_EXP_ITEM_ID
, TRANSFERRED_ITEM_FLAG
, CONVERTED_FLAG
, SOURCE_EXPENDITURE_ITEM_ID
, 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
, ORG_ID
, EXPENDITURE_ORG_ID
, USER_TRANSACTION_SOURCE
, ALLOW_ADJUSTMENTS_FLAG
, COSTED_FLAG
, COST_BURDENED_FLAG
, GL_ACCOUNTED_FLAG
, ALLOW_REVERSAL_FLAG
, ALLOW_BURDEN_FLAG
, BURDEN_SUM_DEST_RUN_ID
, PROJECT_STATUS_CODE
, USER_ACCT_RATE_TYPE
, USER_PROJECT_RATE_TYPE
, 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
, TRANSFER_STATUS_CODE
, USER_BATCH_NAME
, CC_PRVDR_ORGANIZATION_ID
, CC_RECVR_ORGANIZATION_ID
, CC_PRVDR_ORGANIZATION_NAME
, CC_RECVR_ORGANIZATION_NAME
, PRVDR_ORG_ID
, RECVR_ORG_ID
, PRVDR_ORG_NAME
, RECVR_ORG_NAME
, CC_CROSS_CHARGE_CODE
, CC_CROSS_CHARGE_TYPE
, CC_REJECTION_CODE
, CC_BL_DISTRIBUTED_CODE
, CC_IC_PROCESSED_CODE
, DENOM_TP_CURRENCY_CODE
, DENOM_TRANSFER_PRICE
, ACCT_TP_RATE_TYPE
, USER_ACCT_TP_RATE_TYPE
, ACCT_TP_RATE_DATE
, ACCT_TP_EXCHANGE_RATE
, ACCT_TRANSFER_PRICE
, PROJACCT_TRANSFER_PRICE
, BILL_JOB_NAME
, COST_JOB_ID
, COST_JOB_NAME
, TP_JOB_ID
, TP_JOB_NAME
, PROV_PROJ_BILL_JOB_ID
, PROV_PROJ_BILL_JOB_NAME
, BILL_TRANS_FORECAST_CURR_CODE
, BILL_TRANS_FORECAST_REVENUE
, BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_RAW_REVENUE
, BILL_TRANS_BILL_AMOUNT
, PROJECT_RAW_REVENUE
, PROJECT_BILL_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_RAW_REVENUE
, PROJFUNC_BILL_AMOUNT
, INVPROC_CURRENCY_CODE
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_EXCHANGE_RATE
, PROJECT_RAW_COST
, PROJECT_BURDENED_COST
, ASSIGNMENT_ID
, WORK_TYPE_ID
, PROJECT_TP_RATE_DATE
, PROJECT_TP_RATE_TYPE
, USER_PROJECT_TP_RATE_TYPE
, PROJECT_TP_EXCHANGE_RATE
, PROJECT_TRANSFER_PRICE
, WORK_TYPE_NAME
, ASSIGNMENT_NAME
, TP_AMT_TYPE_CODE
, PROJFUNC_TP_RATE_DATE
, PROJFUNC_TP_RATE_TYPE
, USER_PROJFUNC_TP_RATE_TYPE
, PROJFUNC_TP_EXCHANGE_RATE
, PROJFUNC_TRANSFER_PRICE
, USER_PROJFUNC_COST_RATE_TYPE
, PRVDR_ACCRUAL_DATE
, RECVR_ACCRUAL_DATE
, RETIREMENT_COST_FLAG
, CAPITAL_EVENT_NUMBER
, GROUPED_RWIP_FLAG
, LATEST_PA_DATE
, LATEST_GL_DATE
, LATEST_RECVR_PA_DATE
, LATEST_RECVR_GL_DATE
, LATEST_PA_PERIOD_NAME
, LATEST_GL_PERIOD_NAME
, LATEST_RECVR_PA_PERIOD_NAME
, LATEST_RECVR_GL_PERIOD_NAME
, PERSON_TYPE
, PO_LINE_ID
, PO_PRICE_TYPE
, PO_NUMBER
, PO_LINE_NUMBER
, PO_PRICE_TYPE_M
, PA_PERSON_TYPE_M
, WIP_RESOURCE_ID
, WIP_RESOURCE
, INVENTORY_ITEM_ID
, INVENTORY_ITEM
, DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID
, DOCUMENT_LINE_NUMBER
, DOCUMENT_PAYMENT_ID
, DOCUMENT_TYPE
, DOCUMENT_DISTRIBUTION_TYPE
, EXPENSED
, AGREEMENT_ID
, AGREEMENT_NUMBER
, LOCATION_ID
, LOCATION_CODE
, PAY_ELEMENT_TYPE_ID
, PAY_ELEMENT_NAME
, COSTING_METHOD_M
, RATE_SOURCE_M
, PAYROLL_ACCRUAL_FLAG
, COSTED_PAYROLL_SET_ID
, PAYROLL_NAME
, PAY_PERIOD_START_DATE
, PAY_PERIOD_END_DATE
FROM APPS.PA_EXPENDITURE_ITEMS_ONLINE_V;
APPS
FND_GLOBAL
- show dependent code
FND_LOOKUPS
HR_ALL_ORGANIZATION_UNITS_TL
HR_GENERAL
- show dependent code
HR_LOCATIONS
HR_SECURITY
- show dependent code
PAY_ELEMENT_TYPES_F_TL
PAY_PAYROLLS_F
PA_CAPITAL_EVENTS
PA_CONVERSION_TYPES_V
PA_EXPENDITURES_ALL
PA_EXPENDITURES_UTILS
- show dependent code
PA_EXPENDITURE_COMMENTS
PA_EXPENDITURE_ITEMS_ALL
PA_EXPENDITURE_TYPES
PA_LOOKUPS
PA_PAY_AUDIT_ALL
PA_PAY_EXTERNAL_PAYROLL
PA_PROJECTS_ALL
PA_PROJECT_TYPES_ALL
PA_SECURITY
- show dependent code
PA_TASKS
PA_TRANSACTION_SOURCES
PA_UTILS2
- show dependent code
PA_UTILS4
- show dependent code
PER_ALL_PEOPLE_F
PER_JOBS
PO_HEADERS_ALL
PO_LINES_ALL
APPS.PA_EXPENDITURE_ITEMS_ONLINE_V is not referenced by any database object
|
|
|
|