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.

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

TABLE: PSP.PSP_ENC_LINES_HISTORY

Object Details

Object Name:	PSP_ENC_LINES_HISTORY
Object Type:	TABLE
Owner:	PSP
FND Design Data:	PSP.PSP_ENC_LINES_HISTORY
Subobject Name:
Status:	VALID

PSP_ENC_LINES_ HISTORY stores successful encumbrance lines transferred into General Ledger, Grants Accounting, or Project Accounting.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSP_ENC_LINES_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENC_LINE_ID
PSP_ENC_LINES_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENC_CONTROL_ID
PSP_ENC_LINES_HISTORY_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_ID
PSP_ENC_LINES_HISTORY_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENC_ELEMENT_TYPE_ID
PSP_ENC_LINES_HISTORY_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEFAULT_REASON_CODE
PSP_ENC_LINES_HISTORY_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUSPENSE_REASON_CODE
PSP_ENC_LINES_HISTORY_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID PAYROLL_ID CHANGE_FLAG
PSP_ENC_LINES_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENC_SUMMARY_LINE_ID
PSP_ENC_LINES_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIME_PERIOD_ID
PSP_ENC_LINES_HISTORY_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_FLAG
PSP_ENC_LINES_HISTORY_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUSPENSE_ORG_ACCOUNT_ID
PSP_ENC_LINES_HISTORY_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEFAULT_ORG_ACCOUNT_ID
PSP_ENC_LINES_HISTORY_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELEMENT_ACCOUNT_ID
PSP_ENC_LINES_HISTORY_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_SCHEDULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ENC_LINE_ID	NUMBER	(9)	Yes	Encumbrance line identifier
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS
ENC_ELEMENT_TYPE_ID	NUMBER	(9)	Yes	Foreign key to PSP_ENC_ELEMENTS
ENCUMBRANCE_DATE	DATE		Yes	Encumbrance date
DR_CR_FLAG	VARCHAR2	(1)	Yes	Debit or Credit flag. D indicates debit and C indicates credit.
ENCUMBRANCE_AMOUNT	NUMBER	(10)	Yes	Encumbrance amount
ENC_LINE_TYPE	VARCHAR2	(1)	Yes	Indicates status of current encumbrance line type. N indicates New and U indicates Update.
SCHEDULE_LINE_ID	NUMBER	(9)		Foreign key to PSP_SCHEDULE_LINES
ORG_SCHEDULE_ID	NUMBER	(9)		Foreign key to PSP_DEFAULT_LABOR_SCHEDULES
DEFAULT_ORG_ACCOUNT_ID	NUMBER	(10)		Foreign key to PSP_ORGANIZATION_ACCOUNTS
SUSPENSE_ORG_ACCOUNT_ID	NUMBER	(10)		Foreign key to PSP_ORGANIZATION_ACCOUNTS
ELEMENT_ACCOUNT_ID	NUMBER	(10)		Foreign key to PSP_ELEMENT_TYPE_ACCOUNTS
GL_PROJECT_FLAG	VARCHAR2	(1)	Yes	General Ledger or Projects flag. G indicates General Ledger and P indicates POETA.
ENC_SUMMARY_LINE_ID	NUMBER	(9)	Yes	Foreign key to PSP_ENC_SUMMARY_LINES
PERSON_ID	NUMBER	(9)	Yes	Foreign key to PER_PEOPLE_F
ASSIGNMENT_ID	NUMBER	(10)	Yes	Foreign key to PER_ASSIGNMENTS_F
AWARD_ID	NUMBER	(10)		Foreign key to GMS_AWARDS
TASK_ID	NUMBER	(10)		Foreign key to PA_TASKS
EXPENDITURE_TYPE	VARCHAR2	(30)		Expenditure type reference to PA_ORGANIZATIONS_EXPEND_V
EXPENDITURE_ORGANIZATION_ID	NUMBER	(10)		Expenditure Organization identifier
PROJECT_ID	NUMBER	(10)		Foreign key to PA_PROJECTS
GL_CODE_COMBINATION_ID	NUMBER	(15)		Foreign key to GL_CODE_COMBINATIONS
TIME_PERIOD_ID	NUMBER	(15)	Yes	Foreign key to PER_TIME_PERIODS.
PAYROLL_ID	NUMBER	(9)	Yes	Foreign key to PAY_PAYROLLS_F
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Foreign key to GL_SETS_OF_BOOKS
DEFAULT_REASON_CODE	VARCHAR2	(50)		Default reason code
SUSPENSE_REASON_CODE	VARCHAR2	(50)		Suspense reason code
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
STATUS_CODE	VARCHAR2	(1)	Yes	Indicates status of the encumbrance lines. A indicates accepted by General Ledger or Grants Accounting.
ENC_CONTROL_ID	NUMBER	(10)	Yes	Foreign key to PSP_ENC_CONTROLS
CHANGE_FLAG	VARCHAR2	(1)		Indicates whether the current line is new line or liquidated line, L for liquidated and N for new
ENC_START_DATE	DATE			POETA start date update by Pre-Processor
ENC_END_DATE	DATE			POETA end date update by Pre-Processor
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment column
PAYROLL_ACTION_ID	NUMBER			Payroll Action Id
ORIG_GL_CODE_COMBINATION_ID	NUMBER	(15)		Original GL Code Combination
ORIG_PROJECT_ID	NUMBER	(15)		Original Project Id
ORIG_TASK_ID	NUMBER	(15)		Original Task Id
ORIG_AWARD_ID	NUMBER	(15)		Original Award Id
ORIG_EXPENDITURE_ORG_ID	NUMBER	(15)		Original Expenditure Organization Id
ORIG_EXPENDITURE_TYPE	VARCHAR2	(30)		Original Expenditure Type
HIERARCHY_CODE	VARCHAR2	(30)		Hierarchy Code
HIERARCHY_START_DATE	DATE			Hierarchy Start Date
HIERARCHY_END_DATE	DATE			Hierarchy End Date

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ENC_LINE_ID
,      BUSINESS_GROUP_ID
,      ENC_ELEMENT_TYPE_ID
,      ENCUMBRANCE_DATE
,      DR_CR_FLAG
,      ENCUMBRANCE_AMOUNT
,      ENC_LINE_TYPE
,      SCHEDULE_LINE_ID
,      ORG_SCHEDULE_ID
,      DEFAULT_ORG_ACCOUNT_ID
,      SUSPENSE_ORG_ACCOUNT_ID
,      ELEMENT_ACCOUNT_ID
,      GL_PROJECT_FLAG
,      ENC_SUMMARY_LINE_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      AWARD_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      PROJECT_ID
,      GL_CODE_COMBINATION_ID
,      TIME_PERIOD_ID
,      PAYROLL_ID
,      SET_OF_BOOKS_ID
,      DEFAULT_REASON_CODE
,      SUSPENSE_REASON_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      STATUS_CODE
,      ENC_CONTROL_ID
,      CHANGE_FLAG
,      ENC_START_DATE
,      ENC_END_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      PAYROLL_ACTION_ID
,      ORIG_GL_CODE_COMBINATION_ID
,      ORIG_PROJECT_ID
,      ORIG_TASK_ID
,      ORIG_AWARD_ID
,      ORIG_EXPENDITURE_ORG_ID
,      ORIG_EXPENDITURE_TYPE
,      HIERARCHY_CODE
,      HIERARCHY_START_DATE
,      HIERARCHY_END_DATE
FROM PSP.PSP_ENC_LINES_HISTORY;

Dependencies

[top of page]

PSP.PSP_ENC_LINES_HISTORY does not reference any database object

PSP.PSP_ENC_LINES_HISTORY is referenced by following:

APPS: PSP_ENC_LINES_HISTORY; PSP_ENC_LINES_HISTORY_WHO