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: TablePAY.HR_PUMP_SPREAD_LOADERS
Subobject Name:
Status: VALID


Contains seed data to drive Data Pump spreadsheets.


Storage Details
Tablespace: TablespaceAPPS_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:

SchemaAPPS
SynonymHR_PUMP_SPREAD_LOADERS
SchemaPUBLIC
SynonymHR_PUMP_SPREAD_LOADERS