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


VIEW: APPS.PA_EXPEND_ITEMS_ADJUST2_V

Object Details
Object Name: PA_EXPEND_ITEMS_ADJUST2_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_EXPEND_ITEMS_ADJUST2_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)
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)
MRC_RAW_REVENUE VARCHAR2 (0)
MRC_BILL_RATE VARCHAR2 (0)
MRC_ACCRUED_REVENUE VARCHAR2 (0)
MRC_ACCRUAL_RATE VARCHAR2 (0)
MRC_ADJUSTED_REVENUE VARCHAR2 (0)
MRC_ADJUSTED_RATE VARCHAR2 (0)
MRC_BILL_AMOUNT VARCHAR2 (0)
MRC_FORECAST_REVENUE VARCHAR2 (0)
MRC_ACCT_CURRENCY_CODE VARCHAR2 (0)
MRC_ACCT_RATE_DATE VARCHAR2 (0)
MRC_ACCT_RATE_TYPE VARCHAR2 (0)
MRC_USER_ACCT_RATE_TYPE VARCHAR2 (0)
MRC_ACCT_EXCHANGE_RATE VARCHAR2 (0)
MRC_ACCT_RAW_COST VARCHAR2 (0)
MRC_ACCT_BURDENED_COST VARCHAR2 (0)
MRC_REVENUE_RATE_TYPE VARCHAR2 (0)
MRC_REVENUE_CONVERSION_DATE VARCHAR2 (0)
MRC_REVENUE_EXCHANGE_RATE VARCHAR2 (0)
MRC_ACCT_TP_RATE_TYPE VARCHAR2 (0)
MRC_USER_ACCT_TP_RATE_TYPE VARCHAR2 (0)
MRC_ACCT_TP_RATE_DATE VARCHAR2 (0)
MRC_ACCT_TP_EXCHANGE_RATE VARCHAR2 (0)
MRC_ACCT_TRANSFER_PRICE VARCHAR2 (0)
MRC_PROJFUNC_INV_RATE_TYPE VARCHAR2 (0)
MRC_PROJFUNC_INV_RATE_DATE VARCHAR2 (0)
MRC_PROJFUNC_INV_EXCHANGE_RATE VARCHAR2 (0)
MRC_PROJFUNC_FCST_RATE_TYPE VARCHAR2 (0)
MRC_PROJFUNC_FCST_RATE_DATE VARCHAR2 (0)
MRC_PROJFUNC_FCST_XCHANGE_RATE VARCHAR2 (0)
MRC_RAW_COST_RATE VARCHAR2 (0)
MRC_BURDENED_COST_RATE VARCHAR2 (0)
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 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
RATE_SOURCE_CODE VARCHAR2 (30)
Name of the source from which employee rates are derived
RATE_SOURCE_M VARCHAR2 (80)
Meaning of the lookup code for the rate source
COSTING_METHOD VARCHAR2 (150)
The method used to cost the expenditure item
COSTING_METHOD_M VARCHAR2 (80)
Meaning of the lookup code for the costing method
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
CBS_ELEMENT_ID NUMBER (15)
COST_CODE VARCHAR2 (250)
COST_CODE_NAME VARCHAR2 (240)
Query Text

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
,      MRC_RAW_REVENUE
,      MRC_BILL_RATE
,      MRC_ACCRUED_REVENUE
,      MRC_ACCRUAL_RATE
,      MRC_ADJUSTED_REVENUE
,      MRC_ADJUSTED_RATE
,      MRC_BILL_AMOUNT
,      MRC_FORECAST_REVENUE
,      MRC_ACCT_CURRENCY_CODE
,      MRC_ACCT_RATE_DATE
,      MRC_ACCT_RATE_TYPE
,      MRC_USER_ACCT_RATE_TYPE
,      MRC_ACCT_EXCHANGE_RATE
,      MRC_ACCT_RAW_COST
,      MRC_ACCT_BURDENED_COST
,      MRC_REVENUE_RATE_TYPE
,      MRC_REVENUE_CONVERSION_DATE
,      MRC_REVENUE_EXCHANGE_RATE
,      MRC_ACCT_TP_RATE_TYPE
,      MRC_USER_ACCT_TP_RATE_TYPE
,      MRC_ACCT_TP_RATE_DATE
,      MRC_ACCT_TP_EXCHANGE_RATE
,      MRC_ACCT_TRANSFER_PRICE
,      MRC_PROJFUNC_INV_RATE_TYPE
,      MRC_PROJFUNC_INV_RATE_DATE
,      MRC_PROJFUNC_INV_EXCHANGE_RATE
,      MRC_PROJFUNC_FCST_RATE_TYPE
,      MRC_PROJFUNC_FCST_RATE_DATE
,      MRC_PROJFUNC_FCST_XCHANGE_RATE
,      MRC_RAW_COST_RATE
,      MRC_BURDENED_COST_RATE
,      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
,      PAY_ELEMENT_TYPE_ID
,      PAY_ELEMENT_NAME
,      RATE_SOURCE_CODE
,      RATE_SOURCE_M
,      COSTING_METHOD
,      COSTING_METHOD_M
,      PAYROLL_ACCRUAL_FLAG
,      COSTED_PAYROLL_SET_ID
,      PAYROLL_NAME
,      PAY_PERIOD_START_DATE
,      PAY_PERIOD_END_DATE
,      CBS_ELEMENT_ID
,      COST_CODE
,      COST_CODE_NAME
FROM APPS.PA_EXPEND_ITEMS_ADJUST2_V;

Dependencies

[top of page]

APPS.PA_EXPEND_ITEMS_ADJUST2_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_LOCATIONS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ELEMENT_TYPES_F_TL
ViewPAY_PAYROLLS_F
SynonymPA_CAPITAL_EVENTS
ViewPA_CONVERSION_TYPES_V
SynonymPA_EXPENDITURES_ALL
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
SynonymPA_EXPENDITURE_COMMENTS
PL/SQL PackagePA_EXPENDITURE_INQUIRY - show dependent code
SynonymPA_EXPENDITURE_ITEMS_ALL
SynonymPA_EXPENDITURE_TYPES
SynonymPA_IMPLEMENTATIONS
ViewPA_LOOKUPS
SynonymPA_PAY_AUDIT_ALL
SynonymPA_PAY_EXTERNAL_PAYROLL
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_TYPES_ALL
SynonymPA_RBS_ELEMENTS
PL/SQL PackagePA_SECURITY - show dependent code
SynonymPA_TASKS
SynonymPA_TRANSACTION_SOURCES
PL/SQL PackagePA_UTILS2 - show dependent code
PL/SQL PackagePA_UTILS4 - show dependent code
SynonymPER_ALL_PEOPLE_F
SynonymPER_JOBS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL

APPS.PA_EXPEND_ITEMS_ADJUST2_V is not referenced by any database object