DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CSP_RESOURCE_DEFAULT_INV_LOC_V

Object Details
Object Name: CSP_RESOURCE_DEFAULT_INV_LOC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSP.CSP_RESOURCE_DEFAULT_INV_LOC_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


The view is used to retrieve the Part In or Part Out subinventories assigned to a Resource in a loop. The Where clause must specify whether the view should return Part In default subinventory or the Part Out default subinventory.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (35) Yes Resource identifier
RESOURCE_TYPE VARCHAR2 (30) Yes Resource type
SUBINVENOTRY_CODE VARCHAR2 (10) Yes Subinventory name
DEFAULT_CODE VARCHAR2 (30)
Default code
PARTS_LOOP_ID NUMBER (35)
Parts loop identifier
ORGANIZATION_ID NUMBER (35) Yes Organization identifier
EFFECTIVE_DATE_START DATE

Effective from this date
EFFECTIVE_DATE_END DATE

Effective through this date
Query Text

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


SELECT RESOURCE_ID
,      RESOURCE_TYPE
,      SUBINVENOTRY_CODE
,      DEFAULT_CODE
,      PARTS_LOOP_ID
,      ORGANIZATION_ID
,      EFFECTIVE_DATE_START
,      EFFECTIVE_DATE_END
FROM APPS.CSP_RESOURCE_DEFAULT_INV_LOC_V;

Dependencies

[top of page]

APPS.CSP_RESOURCE_DEFAULT_INV_LOC_V references the following:

SchemaAPPS
SynonymCSP_INV_LOC_ASSIGNMENTS
SynonymCSP_SEC_INVENTORIES

APPS.CSP_RESOURCE_DEFAULT_INV_LOC_V is not referenced by any database object