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

VIEW: APPS.IGI_RPI_UPDATE_HDR_V

Object Details
Object Name: IGI_RPI_UPDATE_HDR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_RPI_UPDATE_HDR_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
ROW_ID ROWID (10)
RUN_ID NUMBER
Yes
ITEM_ID_FROM NUMBER (15) Yes
ITEM_CODE_FROM VARCHAR2 (50) Yes
ITEM_ID_TO NUMBER (15) Yes
ITEM_CODE_TO VARCHAR2 (50) Yes
EFFECTIVE_DATE DATE
Yes
OPTION_FLAG VARCHAR2 (25) Yes
UPDATE_OPTION VARCHAR2 (80) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15) Yes
ORG_ID NUMBER

AMOUNT NUMBER

PERCENTAGE_AMOUNT NUMBER

STATUS VARCHAR2 (25)
UPDATE_STATUS VARCHAR2 (80) Yes
PROCESS_ID NUMBER

INCR_DECR_FLAG VARCHAR2 (240)
Query Text

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


SELECT ROW_ID
,      RUN_ID
,      ITEM_ID_FROM
,      ITEM_CODE_FROM
,      ITEM_ID_TO
,      ITEM_CODE_TO
,      EFFECTIVE_DATE
,      OPTION_FLAG
,      UPDATE_OPTION
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      ORG_ID
,      AMOUNT
,      PERCENTAGE_AMOUNT
,      STATUS
,      UPDATE_STATUS
,      PROCESS_ID
,      INCR_DECR_FLAG
FROM APPS.IGI_RPI_UPDATE_HDR_V;

Dependencies

[top of page]

APPS.IGI_RPI_UPDATE_HDR_V references the following:

SchemaAPPS
ViewIGI_LOOKUPS
SynonymIGI_RPI_ITEMS_ALL
SynonymIGI_RPI_UPDATE_HDR

APPS.IGI_RPI_UPDATE_HDR_V is not referenced by any database object