Product: | PA - Projects |
---|---|
Description: | The smallest units of expenditure charged to projects and tasks |
Implementation/DBA Data: | PA.PA_EXPENDITURE_ITEMS_ALL |
Table | |
Foreign Table | Foreign Key Column |
---|---|---|---|
PA_EXPENDITURE_ITEMS_ALL | PA_TASKS | PA_EXPENDITURE_ITEMS_ALL.TASK_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL.TRANSFERRED_FROM_EXP_ITEM_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_PROJECTS_ALL | PA_EXPENDITURE_ITEMS_ALL.PROJECT_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_SYSTEM_LINKAGES | PA_EXPENDITURE_ITEMS_ALL.SYSTEM_LINKAGE_FUNCTION | |
PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_TYPES | PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_TYPE | |
PA_EXPENDITURE_ITEMS_ALL | PER_JOBS | PA_EXPENDITURE_ITEMS_ALL.JOB_ID | |
PA_EXPENDITURE_ITEMS_ALL | FND_CURRENCIES | PA_EXPENDITURE_ITEMS_ALL.RECEIPT_CURRENCY_CODE | |
PA_EXPENDITURE_ITEMS_ALL | FND_CURRENCIES | PA_EXPENDITURE_ITEMS_ALL.DENOM_CURRENCY_CODE | |
PA_EXPENDITURE_ITEMS_ALL | FND_CURRENCIES | PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE | |
PA_EXPENDITURE_ITEMS_ALL | FND_CURRENCIES | PA_EXPENDITURE_ITEMS_ALL.PROJECT_CURRENCY_CODE | |
PA_EXPENDITURE_ITEMS_ALL | FND_CURRENCIES | PA_EXPENDITURE_ITEMS_ALL.DENOM_TP_CURRENCY_CODE | |
PA_EXPENDITURE_ITEMS_ALL | GL_DAILY_CONVERSION_TYPES | PA_EXPENDITURE_ITEMS_ALL.ACCT_RATE_TYPE | |
PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURES_ALL | PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ID | |
PA_EXPENDITURE_ITEMS_ALL | GL_DAILY_CONVERSION_TYPES | PA_EXPENDITURE_ITEMS_ALL.PROJECT_RATE_TYPE | |
PA_EXPENDITURE_ITEMS_ALL | GL_DAILY_CONVERSION_TYPES | PA_EXPENDITURE_ITEMS_ALL.ACCT_TP_RATE_TYPE | |
PA_EXPENDITURE_ITEMS_ALL | HR_ALL_ORGANIZATION_UNITS | PA_EXPENDITURE_ITEMS_ALL.CC_PRVDR_ORGANIZATION_ID | |
PA_EXPENDITURE_ITEMS_ALL | HR_ALL_ORGANIZATION_UNITS | PA_EXPENDITURE_ITEMS_ALL.CC_RECVR_ORGANIZATION_ID | |
PA_EXPENDITURE_ITEMS_ALL | GL_DAILY_CONVERSION_TYPES | PA_EXPENDITURE_ITEMS_ALL.PROJECT_TP_RATE_TYPE | |
PA_EXPENDITURE_ITEMS_ALL | GL_DAILY_CONVERSION_TYPES | PA_EXPENDITURE_ITEMS_ALL.PROJFUNC_TP_RATE_TYPE | |
PA_EXPENDITURE_ITEMS_ALL | GL_DAILY_CONVERSION_TYPES | PA_EXPENDITURE_ITEMS_ALL.PROJFUNC_COST_RATE_TYPE | |
PA_EXPENDITURE_ITEMS_ALL | PA_PROJECT_ASSIGNMENTS | PA_EXPENDITURE_ITEMS_ALL.ASSIGNMENT_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_WORK_TYPES_B | PA_EXPENDITURE_ITEMS_ALL.WORK_TYPE_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_NON_LABOR_RESOURCE_ORGS |
PA_EXPENDITURE_ITEMS_ALL.ORGANIZATION_ID
PA_EXPENDITURE_ITEMS_ALL.NON_LABOR_RESOURCE | |
PA_EXPENDITURE_ITEMS_ALL | FND_CURRENCIES | PA_EXPENDITURE_ITEMS_ALL.PROJFUNC_CURRENCY_CODE | |
PA_EXPENDITURE_ITEMS_ALL | PA_CAPITAL_EVENTS | PA_EXPENDITURE_ITEMS_ALL.CAPITAL_EVENT_ID | |
PA_EXPENDITURE_ITEMS_ALL | BOM_RESOURCES | PA_EXPENDITURE_ITEMS_ALL.WIP_RESOURCE_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_LABOR_COST_MULTIPLIERS | PA_EXPENDITURE_ITEMS_ALL.LABOR_COST_MULTIPLIER_NAME | |
PA_EXPENDITURE_ITEMS_ALL | PA_TRANSACTION_SOURCES | PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE | |
PA_EXPENDITURE_ITEMS_ALL | PER_JOBS | PA_EXPENDITURE_ITEMS_ALL.BILL_JOB_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURES_ALL | PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ID | |
GMS_ENCUMBRANCE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL | GMS_ENCUMBRANCE_ITEMS_ALL.PEL_EXPENDITURE_ITEM_ID | |
GMS_BURDEN_COMPONENTS | PA_EXPENDITURE_ITEMS_ALL | GMS_BURDEN_COMPONENTS.EXPENDITURE_ITEM_ID | |
GMS_EVENT_INTERSECT | PA_EXPENDITURE_ITEMS_ALL | GMS_EVENT_INTERSECT.EXPENDITURE_ITEM_ID | |
PA_ALLOC_TXN_DETAILS | PA_EXPENDITURE_ITEMS_ALL | PA_ALLOC_TXN_DETAILS.EXPENDITURE_ITEM_ID | |
PA_AUD_COST_DIST_LINES | PA_EXPENDITURE_ITEMS_ALL | PA_AUD_COST_DIST_LINES.EXPENDITURE_ITEM_ID | |
PA_CC_DIST_LINES_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_CC_DIST_LINES_ALL.EXPENDITURE_ITEM_ID | |
PA_COST_DISTRIBUTION_LINES_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_COST_DISTRIBUTION_LINES_ALL.EXPENDITURE_ITEM_ID | |
PA_CUST_REV_DIST_LINES_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_CUST_REV_DIST_LINES_ALL.EXPENDITURE_ITEM_ID | |
PA_DRAFT_INVOICE_DETAILS_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_DRAFT_INVOICE_DETAILS_ALL.EXPENDITURE_ITEM_ID | |
PA_EXPEND_ITEM_ADJ_ACTIVITIES | PA_EXPENDITURE_ITEMS_ALL | PA_EXPEND_ITEM_ADJ_ACTIVITIES.EXPENDITURE_ITEM_ID | |
PA_EXPENDITURE_COMMENTS | PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_COMMENTS.EXPENDITURE_ITEM_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL.TRANSFERRED_FROM_EXP_ITEM_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID | |
PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID | |
PA_MC_CC_DIST_LINES_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_MC_CC_DIST_LINES_ALL.EXPENDITURE_ITEM_ID | |
PA_MC_COST_DIST_LINES_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_MC_COST_DIST_LINES_ALL.EXPENDITURE_ITEM_ID | |
PA_MC_EXP_ITEMS_ALL | PA_EXPENDITURE_ITEMS_ALL | PA_MC_EXP_ITEMS_ALL.EXPENDITURE_ITEM_ID |
|
|
|