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: PN.PN_VOL_HIST_LINES_ITF

Object Details

Object Name:	PN_VOL_HIST_LINES_ITF
Object Type:	TABLE
Owner:	PN
FND Design Data:	PN.PN_VOL_HIST_LINES_ITF
Subobject Name:
Status:	VALID

This is interface table whcih contains information of Variable Rent Volume History Batch lines which is being imported into Variable Rent Volume History table.
Scope: public
Product: PN
Lifecycle: active
Display Name: PN Volume History Lines Interface
Category: BUSINESS_ENTITY PN_VOLUME_HISTORY

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_VOL_HIST_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	Identifier of volume history batch to which batch line belongs
VAR_RENT_ID	NUMBER	(15)	Yes	Identifier of the variable rent agreement
LINE_ITEM_ID	NUMBER	(15)	Yes	Identifier of variable rent agreement line
REP_STR_DATE	DATE		Yes	Reporting start date of volume history batch line
REP_END_DATE	DATE		Yes	Reporting end date of volume history batch line
AMOUNT	NUMBER			Amount for volume history batch line.
DEDUCTION_AMT	NUMBER			Deduction amount for volume history batch line if volume type of batch is of type Deduction.
DEDUCTION_TYPE_CODE	VARCHAR2	(30)		Deduction type code for volume history batch line if volume type of batch is of type Deduction.
STATUS	VARCHAR2	(1)		Status of volume history line to indicate whether batch line is pending for import, errored out or imported.
ERROR_LOG	VARCHAR2	(2000)		Error log message for volume history batch line mentioning reason for which the import of line failed.
GROUP_DATE	DATE			Group Date for volume history batch line.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column: Date on which a user updated the row
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column: User who updated the row. This column is a foreign key to FND_USER.USER_ID
CREATION_DATE	DATE		Yes	Standard Who column: Date on which the row was created
CREATED_BY	NUMBER	(15)	Yes	Standard Who column: User who created the row. This column is a foreign key to FND_USER.USER_ID
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REPORTING_DATE	DATE			Reporting date for volume
VOL_HIST_STATUS_CODE	VARCHAR2	(30)		Code specifying status of the volume.
REPORT_TYPE_CODE	VARCHAR2	(30)		Code specifying report type of the volume.
VOL_DEDUCT_ID	NUMBER			Identifier of volume or deduction.
CERTIFIED_BY	NUMBER			User name of the person responsible for approving the reported volume

Query Text

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


SELECT BATCH_ID
,      VAR_RENT_ID
,      LINE_ITEM_ID
,      REP_STR_DATE
,      REP_END_DATE
,      AMOUNT
,      DEDUCTION_AMT
,      DEDUCTION_TYPE_CODE
,      STATUS
,      ERROR_LOG
,      GROUP_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REPORTING_DATE
,      VOL_HIST_STATUS_CODE
,      REPORT_TYPE_CODE
,      VOL_DEDUCT_ID
,      CERTIFIED_BY
FROM PN.PN_VOL_HIST_LINES_ITF;

Dependencies

[top of page]

PN.PN_VOL_HIST_LINES_ITF does not reference any database object

PN.PN_VOL_HIST_LINES_ITF is referenced by following:

APPS: PN_VOL_HIST_LINES_ITF