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

VIEW: APPS.CSP_SEC_INVENTORIES_V

Object Details
Object Name: CSP_SEC_INVENTORIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSP.CSP_SEC_INVENTORIES_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
ROW_ID ROWID (10)
Row identifier
SECONDARY_INVENTORY_ID NUMBER (35) Yes Subinventory 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
ORGANIZATION_ID NUMBER (35) Yes Organization identifier
PARTS_LOOP_ID NUMBER (35)
Parts loop identifier
HIERARCHY_NODE_ID NUMBER (35)
Hierarchy node identifier
LOCATION_ID NUMBER (15)
Location identifier
CONDITION_TYPE VARCHAR2 (30) Yes Subinventory condition type
AUTORECEIPT_FLAG VARCHAR2 (30) Yes Autoreceipt flag
SPARES_LOCATION_FLAG VARCHAR2 (30) Yes Spares location flag
LOCATION_CODE VARCHAR2 (60)
Location Code
STYLE VARCHAR2 (7)
Address style
ADDRESS_LINE_1 VARCHAR2 (240)
Address Line 1
ADDRESS_LINE_2 VARCHAR2 (240)
Address Line 2
ADDRESS_LINE_3 VARCHAR2 (240)
Address Line 3
COUNTRY VARCHAR2 (60)
Country
LOC_INFORMATION13 VARCHAR2 (150)
LOC_INFORMATION14 VARCHAR2 (150)
LOC_INFORMATION15 VARCHAR2 (150)
LOC_INFORMATION16 VARCHAR2 (150)
LOC_INFORMATION17 VARCHAR2 (150)
LOC_INFORMATION18 VARCHAR2 (150)
LOC_INFORMATION19 VARCHAR2 (150)
LOC_INFORMATION20 VARCHAR2 (150)
POSTAL_CODE VARCHAR2 (30)
Postal code
REGION_1 VARCHAR2 (120)
REGION_2 VARCHAR2 (120)
REGION_3 VARCHAR2 (120)
TELEPHONE_NUMBER_1 VARCHAR2 (60)
TELEPHONE_NUMBER_2 VARCHAR2 (60)
TELEPHONE_NUMBER_3 VARCHAR2 (60)
TOWN_OR_CITY VARCHAR2 (30)
City
BILL_TO_SITE_FLAG VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)
DESIGNATED_RECEIVER_ID NUMBER (15)
ECE_TP_LOCATION_CODE VARCHAR2 (35)
INACTIVE_DATE DATE

ENTERED_BY NUMBER (15)
INVENTORY_ORGANIZATION_ID NUMBER (15)
IN_ORGANIZATION_FLAG VARCHAR2 (30)
OFFICE_SITE_FLAG VARCHAR2 (30)
RECEIVING_SITE_FLAG VARCHAR2 (30)
SHIP_TO_LOCATION_ID NUMBER (15)
SHIP_TO_SITE_FLAG VARCHAR2 (30)
TAX_NAME VARCHAR2 (15)
TP_HEADER_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
escriptive Flexfield Structure Defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment Column
SECONDARY_INVENTORY_NAME VARCHAR2 (10) Yes Subinventory name
MEANING VARCHAR2 (80) Yes Subinventory condition type
RETURN_ORGANIZATION_ID NUMBER (35)
Organization identifier for spare parts return
RETURN_SUBINVENTORY_NAME VARCHAR2 (10)
Subinventory name for spare parts return
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization name
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
OWNER_RESOURCE_TYPE VARCHAR2 (30)
OWNER_RESOURCE_ID NUMBER (35)
TERRITORY_SHORT_NAME VARCHAR2 (80)
Territory short name
Query Text

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


SELECT ROW_ID
,      SECONDARY_INVENTORY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      PARTS_LOOP_ID
,      HIERARCHY_NODE_ID
,      LOCATION_ID
,      CONDITION_TYPE
,      AUTORECEIPT_FLAG
,      SPARES_LOCATION_FLAG
,      LOCATION_CODE
,      STYLE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      COUNTRY
,      LOC_INFORMATION13
,      LOC_INFORMATION14
,      LOC_INFORMATION15
,      LOC_INFORMATION16
,      LOC_INFORMATION17
,      LOC_INFORMATION18
,      LOC_INFORMATION19
,      LOC_INFORMATION20
,      POSTAL_CODE
,      REGION_1
,      REGION_2
,      REGION_3
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      TOWN_OR_CITY
,      BILL_TO_SITE_FLAG
,      DESCRIPTION
,      DESIGNATED_RECEIVER_ID
,      ECE_TP_LOCATION_CODE
,      INACTIVE_DATE
,      ENTERED_BY
,      INVENTORY_ORGANIZATION_ID
,      IN_ORGANIZATION_FLAG
,      OFFICE_SITE_FLAG
,      RECEIVING_SITE_FLAG
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_SITE_FLAG
,      TAX_NAME
,      TP_HEADER_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECONDARY_INVENTORY_NAME
,      MEANING
,      RETURN_ORGANIZATION_ID
,      RETURN_SUBINVENTORY_NAME
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      OWNER_RESOURCE_TYPE
,      OWNER_RESOURCE_ID
,      TERRITORY_SHORT_NAME
FROM APPS.CSP_SEC_INVENTORIES_V;

Dependencies

[top of page]

APPS.CSP_SEC_INVENTORIES_V references the following:

SchemaAPPS
SynonymCSP_SEC_INVENTORIES
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewFND_TERRITORIES_VL
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_SECONDARY_INVENTORIES
ViewORG_ORGANIZATION_DEFINITIONS
APPS.CSP_SEC_INVENTORIES_V is referenced by following:

SchemaAPPS
Package BodyCSP_PLANNING_PARAMETERS_PVT - show dependent code