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: IGI.IGI_RPI_LINE_DETAILS_ALL#

Object Details

Object Name:	IGI_RPI_LINE_DETAILS_ALL#
Object Type:	VIEW
Owner:	IGI
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

IGI_RPI_LINE_DETAILS contains standing charge line details information. It is based on IGI_RPI_LINE_DETAILS_ALL table.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STANDING_CHARGE_ID	NUMBER	(15)	Yes	Standing charge identifier
LINE_ITEM_ID	NUMBER	(15)	Yes	Line item identifier
CHARGE_ITEM_NUMBER	NUMBER		Yes	Line sequence number
ITEM_ID	NUMBER	(15)	Yes	Item identifier
PRICE	NUMBER		Yes	Current price
QUANTITY	NUMBER		Yes	Quantity of item
PERIOD_NAME	VARCHAR2	(25)	Yes	Charge period name
CURRENT_EFFECTIVE_DATE	DATE		Yes	Date current price effective
PREVIOUS_EFFECTIVE_DATE	DATE			Previous effective date
DESCRIPTION	VARCHAR2	(240)	Yes	Line description
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_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
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).
ACCOUNTING_RULE_ID	NUMBER	(15)		Accounting rule information
START_DATE	DATE			Start date
DURATION	NUMBER			Accounting duration
REVISED_EFFECTIVE_DATE	DATE			Date revised price effective
REVISED_PRICE	NUMBER			Revised price
PREVIOUS_PRICE	NUMBER			Previous price
VAT_TAX_ID	NUMBER	(15)		Tax rate identifier
REVENUE_CODE_COMBINATION_ID	NUMBER	(15)		Revenue General Ledger account
RECEIVABLE_CODE_COMBINATION_ID	NUMBER	(15)		Receivables General Ledger account
ORG_ID	NUMBER			Organization identifier
RUN_ID	NUMBER			Run identifier
ADDITIONAL_REFERENCE	VARCHAR2	(240)		Additional reference information
LEGAL_ENTITY_ID	NUMBER

Query Text

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


SELECT STANDING_CHARGE_ID
,      LINE_ITEM_ID
,      CHARGE_ITEM_NUMBER
,      ITEM_ID
,      PRICE
,      QUANTITY
,      PERIOD_NAME
,      CURRENT_EFFECTIVE_DATE
,      PREVIOUS_EFFECTIVE_DATE
,      DESCRIPTION
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACCOUNTING_RULE_ID
,      START_DATE
,      DURATION
,      REVISED_EFFECTIVE_DATE
,      REVISED_PRICE
,      PREVIOUS_PRICE
,      VAT_TAX_ID
,      REVENUE_CODE_COMBINATION_ID
,      RECEIVABLE_CODE_COMBINATION_ID
,      ORG_ID
,      RUN_ID
,      ADDITIONAL_REFERENCE
,      LEGAL_ENTITY_ID
FROM IGI.IGI_RPI_LINE_DETAILS_ALL#;

Dependencies

[top of page]

IGI.IGI_RPI_LINE_DETAILS_ALL# references the following:

IGI: IGI_RPI_LINE_DETAILS_ALL

IGI.IGI_RPI_LINE_DETAILS_ALL# is referenced by following:

APPS: IGI_RPI_LINE_DETAILS; IGI_RPI_LINE_DETAILS_ALL