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: CSI.CSI_INSTALL_PARAMETERS

Object Details

Object Name:	CSI_INSTALL_PARAMETERS
Object Type:	TABLE
Owner:	CSI
FND Design Data:	CSI.CSI_INSTALL_PARAMETERS
Subobject Name:
Status:	VALID

This table stores the Install Parameters. These are set at the Installation time.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
INTERNAL_PARTY_ID	NUMBER		Party Identifier from HZ_PARTIES ( TCA Party model ) which is defined for the Internal Organization (The Enterprise where the product is being installed ).
PROJECT_LOCATION_ID	NUMBER		Location Identifier to be stamped on an Instance when the Instance is in a Project.
WIP_LOCATION_ID	NUMBER		Location Identifier to be stamped on an Instance when the Instance is in a WIP Job.
IN_TRANSIT_LOCATION_ID	NUMBER		Location Identifier to be stamped on an Instance when the Instance is in-transit.
PO_LOCATION_ID	NUMBER		Location Identifier to be stamped on an Instance when the Instance is referred in a Purchase Order.
CATEGORY_SET_ID	NUMBER		Category Set which would be refered while defining the Instance Extended Attributes.
HISTORY_FULL_DUMP_FREQUENCY	NUMBER		An Integer Number to specify the frequency of the dumping the complete data in the History table.
FREEZE_FLAG	VARCHAR2	(1)	IMPORTANT : A Swith that enables the 11.5.6 Installed Base application. Once this is set, the api's start functioning and no updates are allowed to the Install Parameters.
CREATED_BY	NUMBER	(15)	Standard WHO Columns
CREATION_DATE	DATE		Standard WHO Columns
LAST_UPDATED_BY	NUMBER	(15)	Standard WHO Columns
LAST_UPDATE_DATE	DATE		Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard WHO Columns
FREEZE_DATE	DATE		Date When the Install Parameters is frozen.
SECURITY_GROUP_ID	NUMBER		Security Group Identifier.
SHOW_ALL_PARTY_LOCATION	VARCHAR2	(1)	This flag indicates if the List of Values in the UI displays all or related parties / Locations.
OWNERSHIP_OVERRIDE_AT_TXN	VARCHAR2	(1)	This flag indicates if ownership needs to be flexible when performing Receipts and Shipments.
SFM_QUEUE_BYPASS_FLAG	VARCHAR2	(1)	This flag indicates determines the behavior of how the events are processed in Installed Base.If the flag is set to 'Y', events coming in from Inventory Hook are to be processed online andwould not go thru SFM event manager queue. If the flag is 'N', the events go thru the SFM Event Manager Queue. The default value is 'N'. Null to be treated as 'N'. It is not recommended to set this flag 'Y'. This is provided for troubleshooting purposes only.
AUTO_ALLOCATE_COMP_AT_WIP	VARCHAR2	(1)	This flag indicates when the components issued to a WIP job are to be approtioned and attachedto the assemblies even though the user does not choose the parent for each component issued.The apportioning is completely random and is done automatically, if the flag is set to 'Y''.
TXN_SEQ_START_DATE	DATE		Transaction sequencing enforcement start date, same as freeze_date if null.
OWNERSHIP_CASCADE_AT_TXN	VARCHAR2	(1)	Option to cascade ownership to the children in a component configuration when shipping.
FA_CREATION_GROUP_BY	VARCHAR2	(30)	FA Group By Creation

Query Text

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


SELECT INTERNAL_PARTY_ID
,      PROJECT_LOCATION_ID
,      WIP_LOCATION_ID
,      IN_TRANSIT_LOCATION_ID
,      PO_LOCATION_ID
,      CATEGORY_SET_ID
,      HISTORY_FULL_DUMP_FREQUENCY
,      FREEZE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FREEZE_DATE
,      SECURITY_GROUP_ID
,      SHOW_ALL_PARTY_LOCATION
,      OWNERSHIP_OVERRIDE_AT_TXN
,      SFM_QUEUE_BYPASS_FLAG
,      AUTO_ALLOCATE_COMP_AT_WIP
,      TXN_SEQ_START_DATE
,      OWNERSHIP_CASCADE_AT_TXN
,      FA_CREATION_GROUP_BY
FROM CSI.CSI_INSTALL_PARAMETERS;

Dependencies

[top of page]

CSI.CSI_INSTALL_PARAMETERS does not reference any database object

CSI.CSI_INSTALL_PARAMETERS is referenced by following:

APPS: CSI_INSTALL_PARAMETERS