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]

VIEW: APPS.CSP_RS_SUBINVENTORIES_V

Object Details

Object Name:	CSP_RS_SUBINVENTORIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSP.CSP_RS_SUBINVENTORIES_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
CSP_INV_LOC_ASSIGNMENT_ID	NUMBER	(35)	Yes	Inventory location assignment identifier
CREATED_BY	NUMBER	(35)	Yes	Standard Who Column - with the user id from FND_USER
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(35)	Yes	Standard Who Column - with the user id from FND_USER
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(35)		Standard Who Column
RESOURCE_TYPE	VARCHAR2	(30)	Yes	Resource type
RESOURCE_ID	NUMBER	(35)	Yes	Resource identifier
RESOURCE_NAME	VARCHAR2	(4000)		Resource name
ORGANIZATION_ID	NUMBER	(35)	Yes	Organization identifier
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
SUBINVENTORY_CODE	VARCHAR2	(10)	Yes	Subinventory name
SECONDARY_INVENTORY_ID	NUMBER	(35)		Secondary inventory identifier
LOCATION_ID	NUMBER	(35)		Location identifier
LOCATOR_ID	NUMBER	(35)		Locator identifier
CONDITION_TYPE	VARCHAR2	(30)		Condition type
CONDITION_TYPE_MEANING	VARCHAR2	(80)		Condition type meaning
DEFAULT_FLAG	VARCHAR2	(1)		Default flag
DEFAULT_CODE	VARCHAR2	(30)		Default code
DEFAULT_CODE_MEANING	VARCHAR2	(80)		Default code meaning
EFFECTIVE_DATE_START	DATE			Effective start date
EFFECTIVE_DATE_END	DATE			Effective end date
OWNER_FLAG	VARCHAR2	(1)		Owner flag
GROUP_NAME	VARCHAR2	(60)		Group Name
GROUP_ID	NUMBER	(35)		Group Id
OWNER_RESOURCE_TYPE	VARCHAR2	(30)		Owner resource type
OWNER_RESOURCE_ID	NUMBER	(35)		Owner resource identifier
OWNER_RESOURCE_NAME	VARCHAR2	(4000)		Owner resource name
RETURN_ORGANIZATION_ID	NUMBER	(35)		Return organizationidentifier
RETURN_ORGANIZATION_CODE	VARCHAR2	(3)		Return organization code
RETURN_SUBINVENTORY_NAME	VARCHAR2	(10)		Return subinventory name
RETURN_CONDITION_TYPE	VARCHAR2	(30)		Return condition type
RETURN_CONDITION_TYPE_MEANING	VARCHAR2	(80)		Return condition type meaning

Query Text

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


SELECT CSP_INV_LOC_ASSIGNMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RESOURCE_TYPE
,      RESOURCE_ID
,      RESOURCE_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      SUBINVENTORY_CODE
,      SECONDARY_INVENTORY_ID
,      LOCATION_ID
,      LOCATOR_ID
,      CONDITION_TYPE
,      CONDITION_TYPE_MEANING
,      DEFAULT_FLAG
,      DEFAULT_CODE
,      DEFAULT_CODE_MEANING
,      EFFECTIVE_DATE_START
,      EFFECTIVE_DATE_END
,      OWNER_FLAG
,      GROUP_NAME
,      GROUP_ID
,      OWNER_RESOURCE_TYPE
,      OWNER_RESOURCE_ID
,      OWNER_RESOURCE_NAME
,      RETURN_ORGANIZATION_ID
,      RETURN_ORGANIZATION_CODE
,      RETURN_SUBINVENTORY_NAME
,      RETURN_CONDITION_TYPE
,      RETURN_CONDITION_TYPE_MEANING
FROM APPS.CSP_RS_SUBINVENTORIES_V;

Dependencies

[top of page]

APPS.CSP_RS_SUBINVENTORIES_V references the following:

APPS: CSP_INV_LOC_ASSIGNMENTS; CSP_PICK_UTILS - show dependent code; CSP_SEC_INVENTORIES; FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_RS_GROUPS_TL; MTL_PARAMETERS

APPS.CSP_RS_SUBINVENTORIES_V is referenced by following:

APPS: CSP_PARTS_REQUIREMENT - show dependent code; CSP_PORTAL_EXCESS_PARTS_PVT - show dependent code; CSP_SCH_INT_PVT - show dependent code