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: HR.HR_PUMP_SPREAD_LOADERS

Object Details

Object Name:	HR_PUMP_SPREAD_LOADERS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.HR_PUMP_SPREAD_LOADERS
Subobject Name:
Status:	VALID

Contains seed data to drive Data Pump spreadsheets.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MODULE_NAME	VARCHAR2	(30)	Yes	Name of the module
INTEGRATOR_CODE	VARCHAR2	(30)	Yes	Integrator code from BNE_INTEGRATORS_B table
ENTITY_NAME	VARCHAR2	(30)		Name of the entity
MODULE_MODE	VARCHAR2	(7)	Yes	Mode will be I, IC, U or UC
API_MODULE_ID	NUMBER			api_module_id of hr_api_modules table
INTEGRATOR_PARAMETERS	VARCHAR2	(2000)	Yes	Parameter for the integrator
ENTITY_SQL_COLUMN_NAME	VARCHAR2	(200)		Column name in the sql for the given entity
ENTITY_SQL_COLUMN_ID	VARCHAR2	(200)		Column ID in the sql for the given entity
ENTITY_SQL_ADDL_COLUMN	VARCHAR2	(200)		Additional column details in the sql for the given entity
ENTITY_SQL_OBJECT_NAME	VARCHAR2	(2000)		SQL object for the given entity
ENTITY_SQL_WHERE_CLAUSE	VARCHAR2	(4000)		Where clause in the sql for the given entity
ENTITY_SQL_PARAMETERS	VARCHAR2	(1000)		sql parameters for the given entity
ENTITY_SQL_ORDER_BY	VARCHAR2	(1000)		order by clause in the sql for the given entity

Query Text

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


SELECT MODULE_NAME
,      INTEGRATOR_CODE
,      ENTITY_NAME
,      MODULE_MODE
,      API_MODULE_ID
,      INTEGRATOR_PARAMETERS
,      ENTITY_SQL_COLUMN_NAME
,      ENTITY_SQL_COLUMN_ID
,      ENTITY_SQL_ADDL_COLUMN
,      ENTITY_SQL_OBJECT_NAME
,      ENTITY_SQL_WHERE_CLAUSE
,      ENTITY_SQL_PARAMETERS
,      ENTITY_SQL_ORDER_BY
FROM HR.HR_PUMP_SPREAD_LOADERS;

Dependencies

[top of page]

HR.HR_PUMP_SPREAD_LOADERS does not reference any database object

HR.HR_PUMP_SPREAD_LOADERS is referenced by following:

APPS: HR_PUMP_SPREAD_LOADERS
PUBLIC: HR_PUMP_SPREAD_LOADERS