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: IPA.IPA_APIS_INTERFACE

Object Details

Object Name:	IPA_APIS_INTERFACE
Object Type:	TABLE
Owner:	IPA
FND Design Data:	IPA.IPA_APIS_INTERFACE
Subobject Name:
Status:	VALID

Interface table to populate the Date placed in service in project assets from external systems.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IPA_APIS_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INTERFACE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_ID	NUMBER	(10)	Yes	System generated Id to identify interface records
BATCH_NAME	VARCHAR2	(60)		User entered Batch name to group records in interface table
PROJECT_ID	NUMBER	(10)		Project Ids whose assets are to be placed in service
PROJECT_NUMBER	VARCHAR2	(60)		Project Number whose assets are to be placed in service
PROJECT_NAME	VARCHAR2	(80)		Project Name whose assets are to be placed in service
PROJECT_ASSET_ID	NUMBER	(10)		Project Asset which is to be placed in service
ASSET_NUMBER	VARCHAR2	(15)		Asset Number which is to be placed in service
ASSET_NAME	VARCHAR2	(80)		Asset Name which is to be placed in service
ASSET_STATUS	VARCHAR2	(60)		Asset Status to be updated in Asset record
GROUPING_METHOD1	VARCHAR2	(60)		Grouping Method element1 used to identify the assets to place in service
GROUPING_METHOD2	VARCHAR2	(60)		Grouping Method element2 used to identify the assets to place in service
GROUPING_METHOD3	VARCHAR2	(60)		Grouping Method element3 used to identify the assets to place in service
DATE_PLACED_IN_SERVICE	DATE		Yes	Value of date place in service for Assets
RECORD_STATUS	VARCHAR2	(10)		Interface record status

Query Text

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


SELECT INTERFACE_ID
,      BATCH_NAME
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_ASSET_ID
,      ASSET_NUMBER
,      ASSET_NAME
,      ASSET_STATUS
,      GROUPING_METHOD1
,      GROUPING_METHOD2
,      GROUPING_METHOD3
,      DATE_PLACED_IN_SERVICE
,      RECORD_STATUS
FROM IPA.IPA_APIS_INTERFACE;

Dependencies

[top of page]

IPA.IPA_APIS_INTERFACE does not reference any database object

IPA.IPA_APIS_INTERFACE is referenced by following:

APPS: IPA_APIS_INTERFACE