eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PA_TRANSACTION_INTERFACE_ALL

Product:	PA - Projects
Description:	Interface table to import transactions from external sources into Oracle Projects
Implementation/DBA Data:	PA.PA_TRANSACTION_INTERFACE_ALL

Primary Key: PA_TRANSACTION_INTERFACE_PK

TXN_INTERFACE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_TRANSACTION_INTERFACE_ALL	PA_TRANSACTION_SOURCES	PA_TRANSACTION_INTERFACE_ALL.TRANSACTION_SOURCE
PA_TRANSACTION_INTERFACE_ALL	HR_ALL_ORGANIZATION_UNITS	PA_TRANSACTION_INTERFACE_ALL.PERSON_BUSINESS_GROUP_ID
PA_TRANSACTION_INTERFACE_ALL	PO_VENDORS	PA_TRANSACTION_INTERFACE_ALL.VENDOR_ID
PA_TRANSACTION_INTERFACE_ALL	BOM_RESOURCES	PA_TRANSACTION_INTERFACE_ALL.WIP_RESOURCE_ID
PA_TRANSACTION_INTERFACE_ALL	PO_HEADERS_ALL	PA_TRANSACTION_INTERFACE_ALL.PO_HEADER_ID
PA_TRANSACTION_INTERFACE_ALL	PO_LINES_ALL	PA_TRANSACTION_INTERFACE_ALL.PO_LINE_ID
PA_TRANSACTION_INTERFACE_ALL	PA_EXPENDITURE_TYPES	PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_TYPE
PA_TRANSACTION_INTERFACE_ALL	FND_CURRENCIES	PA_TRANSACTION_INTERFACE_ALL.PROJFUNC_CURRENCY_CODE
PA_TRANSACTION_INTERFACE_ALL	GL_DAILY_CONVERSION_TYPES	PA_TRANSACTION_INTERFACE_ALL.PROJFUNC_COST_RATE_TYPE
PA_TRANSACTION_INTERFACE_ALL	PA_PROJECTS_ALL	PA_TRANSACTION_INTERFACE_ALL.PROJECT_ID
PA_TRANSACTION_INTERFACE_ALL	PA_TASKS	PA_TRANSACTION_INTERFACE_ALL.TASK_ID
PA_TRANSACTION_INTERFACE_ALL	PA_PROJECT_ASSIGNMENTS	PA_TRANSACTION_INTERFACE_ALL.ASSIGNMENT_ID
PA_MC_TXN_INTERFACE_ALL	PA_TRANSACTION_INTERFACE_ALL	PA_MC_TXN_INTERFACE_ALL.TXN_INTERFACE_ID