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]

VIEW: APPS.IGI_RPI_LINE_DETAILS_V

Object Details

Object Name:	IGI_RPI_LINE_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGI.IGI_RPI_LINE_DETAILS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CHARGE_ITEM_NUMBER	NUMBER		Yes	Line sequence number
QUANTITY	NUMBER		Yes	Quantity of item
PERIOD_NAME	VARCHAR2	(25)	Yes	Charge period name
DESCRIPTION	VARCHAR2	(240)	Yes	Line description
PRICE	NUMBER		Yes	Current price
PREVIOUS_EFFECTIVE_DATE	DATE			Previous effective date
CURRENT_EFFECTIVE_DATE	DATE		Yes	Date current price effective
REVISED_PRICE	NUMBER			Revised price
REVISED_EFFECTIVE_DATE	DATE			Date revised price effective
PREVIOUS_PRICE	NUMBER			Previous price
ADDITIONAL_REFERENCE	VARCHAR2	(240)		Additional reference information
ITEM_ID	NUMBER	(15)	Yes	Item identifier
VAT_TAX_ID	NUMBER	(15)		Tax rate identifier
LINE_ITEM_ID	NUMBER	(15)	Yes	Line item identifier
STANDING_CHARGE_ID	NUMBER	(15)	Yes	Standing charge identifier
ACCOUNTING_RULE_ID	NUMBER	(15)		Accounting rule information
ACCOUNTING_RULE_NAME	VARCHAR2	(30)		Revenue recognition rule name
START_DATE	DATE			Start date
DURATION	NUMBER			Accounting duration
REVENUE_CODE_COMBINATION_ID	NUMBER	(15)		Revenue General Ledger account
RECEIVABLE_CODE_COMBINATION_ID	NUMBER	(15)		Receivables General Ledger account
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (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).
ROW_ID	ROWID	(10)
ORG_ID	NUMBER

Query Text

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


SELECT CHARGE_ITEM_NUMBER
,      QUANTITY
,      PERIOD_NAME
,      DESCRIPTION
,      PRICE
,      PREVIOUS_EFFECTIVE_DATE
,      CURRENT_EFFECTIVE_DATE
,      REVISED_PRICE
,      REVISED_EFFECTIVE_DATE
,      PREVIOUS_PRICE
,      ADDITIONAL_REFERENCE
,      ITEM_ID
,      VAT_TAX_ID
,      LINE_ITEM_ID
,      STANDING_CHARGE_ID
,      ACCOUNTING_RULE_ID
,      ACCOUNTING_RULE_NAME
,      START_DATE
,      DURATION
,      REVENUE_CODE_COMBINATION_ID
,      RECEIVABLE_CODE_COMBINATION_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ROW_ID
,      ORG_ID
FROM APPS.IGI_RPI_LINE_DETAILS_V;

Dependencies

[top of page]

APPS.IGI_RPI_LINE_DETAILS_V references the following:

APPS: IGI_RPI_LINE_DETAILS; RA_RULES

APPS.IGI_RPI_LINE_DETAILS_V is not referenced by any database object