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: ORG_ACCT_PERIODS

Product:	INV - Inventory
Description:	Organization accounting period definition table
Implementation/DBA Data:	INV.ORG_ACCT_PERIODS

Primary Key: ORG_ACCT_PERIODS_PK

ACCT_PERIOD_ID
ORGANIZATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
ORG_ACCT_PERIODS	MTL_PARAMETERS	ORG_ACCT_PERIODS.ORGANIZATION_ID
ORG_ACCT_PERIODS	GL_PERIODS	ORG_ACCT_PERIODS.PERIOD_SET_NAME ORG_ACCT_PERIODS.PERIOD_NAME
CST_EAM_BALANCE_BY_ACCOUNTS	ORG_ACCT_PERIODS	CST_EAM_BALANCE_BY_ACCOUNTS.ACCT_PERIOD_ID CST_EAM_BALANCE_BY_ACCOUNTS.ORGANIZATION_ID
CST_MGD_INFL_ADJUSTED_COSTS	ORG_ACCT_PERIODS	CST_MGD_INFL_ADJUSTED_COSTS.ACCT_PERIOD_ID CST_MGD_INFL_ADJUSTED_COSTS.ORGANIZATION_ID
CST_MGD_INFL_ADJ_PER_STATUSES	ORG_ACCT_PERIODS	CST_MGD_INFL_ADJ_PER_STATUSES.ACCT_PERIOD_ID CST_MGD_INFL_ADJ_PER_STATUSES.ORGANIZATION_ID
CST_MGD_INFL_TSF_ORG_ENTRIES	ORG_ACCT_PERIODS	CST_MGD_INFL_TSF_ORG_ENTRIES.ACCT_PERIOD_ID CST_MGD_INFL_TSF_ORG_ENTRIES.ORGANIZATION_ID
EAM_JOB_COMPLETION_TXNS	ORG_ACCT_PERIODS	EAM_JOB_COMPLETION_TXNS.ACCT_PERIOD_ID EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID
EAM_OP_COMPLETION_TXNS	ORG_ACCT_PERIODS	EAM_OP_COMPLETION_TXNS.ACCT_PERIOD_ID EAM_OP_COMPLETION_TXNS.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS	ORG_ACCT_PERIODS	MTL_MATERIAL_TRANSACTIONS.ACCT_PERIOD_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	ORG_ACCT_PERIODS	MTL_MATERIAL_TRANSACTIONS_TEMP.ACCT_PERIOD_ID MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID
MTL_PERIOD_CG_SUMMARY	ORG_ACCT_PERIODS	MTL_PERIOD_CG_SUMMARY.ACCT_PERIOD_ID MTL_PERIOD_CG_SUMMARY.ORGANIZATION_ID
MTL_PERIOD_SUMMARY	ORG_ACCT_PERIODS	MTL_PERIOD_SUMMARY.ACCT_PERIOD_ID MTL_PERIOD_SUMMARY.ORGANIZATION_ID
ORG_GL_BATCHES	ORG_ACCT_PERIODS	ORG_GL_BATCHES.ACCT_PERIOD_ID ORG_GL_BATCHES.ORGANIZATION_ID
WIP_COST_TXN_INTERFACE	ORG_ACCT_PERIODS	WIP_COST_TXN_INTERFACE.ACCT_PERIOD_ID WIP_COST_TXN_INTERFACE.ORGANIZATION_ID
WIP_MOVE_TRANSACTIONS	ORG_ACCT_PERIODS	WIP_MOVE_TRANSACTIONS.ACCT_PERIOD_ID WIP_MOVE_TRANSACTIONS.ORGANIZATION_ID
WIP_MOVE_TXN_INTERFACE	ORG_ACCT_PERIODS	WIP_MOVE_TXN_INTERFACE.ACCT_PERIOD_ID WIP_MOVE_TXN_INTERFACE.ORGANIZATION_ID
WIP_PERIOD_BALANCES	ORG_ACCT_PERIODS	WIP_PERIOD_BALANCES.ACCT_PERIOD_ID WIP_PERIOD_BALANCES.ORGANIZATION_ID
WIP_TRANSACTIONS	ORG_ACCT_PERIODS	WIP_TRANSACTIONS.ACCT_PERIOD_ID WIP_TRANSACTIONS.ORGANIZATION_ID