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

VIEW: APPS.CSF_M_ITEM_INSTANCES_V

Object Details
Object Name: CSF_M_ITEM_INSTANCES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCESS_ID NUMBER
Yes The Unique Access Identifier
INSTANCE_ID NUMBER
Yes
INSTANCE_NUMBER VARCHAR2 (30) Yes
INVENTORY_ITEM_ID NUMBER
Yes
INVENTORY_REVISION VARCHAR2 (3)
INV_MASTER_ORGANIZATION_ID NUMBER
Yes
SERIAL_NUMBER VARCHAR2 (30)
LOT_NUMBER VARCHAR2 (80)
QUANTITY NUMBER
Yes
UNIT_OF_MEASURE VARCHAR2 (3) Yes
INSTANCE_STATUS_ID NUMBER
Yes
LOCATION_ID NUMBER

INV_ORGANIZATION_ID NUMBER

INV_SUBINVENTORY_NAME VARCHAR2 (10)
INV_LOCATOR_ID NUMBER

INSTALL_DATE DATE

OWNER_PARTY_SOURCE_TABLE VARCHAR2 (30)
OWNER_PARTY_ID NUMBER

OWNER_PARTY_ACCOUNT_ID NUMBER

ACTIVE_START_DATE DATE

ACTIVE_END_DATE DATE

LOCATION_TYPE_CODE VARCHAR2 (30)
NAME VARCHAR2 (40)
DESCRIPTION VARCHAR2 (240)
CLIENT_NAME VARCHAR2 (4000)
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
PARENT_INSTANCE_ID NUMBER

ACTUAL_RETURN_DATE DATE

CREATION_COMPLETE_FLAG VARCHAR2 (1)
COMPLETENESS_FLAG VARCHAR2 (1)
EXTERNAL_REFERENCE VARCHAR2 (30)
INSTALL_LOCATION_ID NUMBER

INSTALL_LOCATION_TYPE_CODE VARCHAR2 (30)
INSTANCE_TYPE_CODE VARCHAR2 (30)
INSTANCE_USAGE_CODE VARCHAR2 (30)
MFG_SERIAL_NUMBER_FLAG VARCHAR2 (1)
RETURN_BY_DATE DATE

VERSION_LABEL VARCHAR2 (30)
ACCOUNTING_CLASS_CODE VARCHAR2 (10)
LAST_OE_ORDER_LINE_ID NUMBER

TERMINATED_FLAG CHAR (1)
LAST_VLD_ORGANIZATION_ID NUMBER

MATERIAL_BILLABLE_FLAG VARCHAR2 (30)
Query Text

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


SELECT ACCESS_ID
,      INSTANCE_ID
,      INSTANCE_NUMBER
,      INVENTORY_ITEM_ID
,      INVENTORY_REVISION
,      INV_MASTER_ORGANIZATION_ID
,      SERIAL_NUMBER
,      LOT_NUMBER
,      QUANTITY
,      UNIT_OF_MEASURE
,      INSTANCE_STATUS_ID
,      LOCATION_ID
,      INV_ORGANIZATION_ID
,      INV_SUBINVENTORY_NAME
,      INV_LOCATOR_ID
,      INSTALL_DATE
,      OWNER_PARTY_SOURCE_TABLE
,      OWNER_PARTY_ID
,      OWNER_PARTY_ACCOUNT_ID
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      LOCATION_TYPE_CODE
,      NAME
,      DESCRIPTION
,      CLIENT_NAME
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PARENT_INSTANCE_ID
,      ACTUAL_RETURN_DATE
,      CREATION_COMPLETE_FLAG
,      COMPLETENESS_FLAG
,      EXTERNAL_REFERENCE
,      INSTALL_LOCATION_ID
,      INSTALL_LOCATION_TYPE_CODE
,      INSTANCE_TYPE_CODE
,      INSTANCE_USAGE_CODE
,      MFG_SERIAL_NUMBER_FLAG
,      RETURN_BY_DATE
,      VERSION_LABEL
,      ACCOUNTING_CLASS_CODE
,      LAST_OE_ORDER_LINE_ID
,      TERMINATED_FLAG
,      LAST_VLD_ORGANIZATION_ID
,      MATERIAL_BILLABLE_FLAG
FROM APPS.CSF_M_ITEM_INSTANCES_V;

Dependencies

[top of page]

APPS.CSF_M_ITEM_INSTANCES_V references the following:

SchemaAPPS
PL/SQL PackageASG_BASE - show dependent code
SynonymCSI_ITEM_INSTANCES
SynonymCSM_ITEM_INSTANCES_ACC
ViewMTL_SYSTEM_ITEMS_B_KFV

APPS.CSF_M_ITEM_INSTANCES_V is not referenced by any database object