[Home] [Help] [Dependency Information]

VIEW: APPS.CSI_INSTANCE_PARTY_V

Object Details

Object Name:	CSI_INSTANCE_PARTY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSI.CSI_INSTANCE_PARTY_V
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

Internal

[View Source]

Columns

Query Text

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

SELECT INSTANCE_ID
,      INSTANCE_NUMBER
,      EXTERNAL_REFERENCE
,      INVENTORY_ITEM_ID
,      INVENTORY_REVISION
,      INV_MASTER_ORGANIZATION_ID
,      SERIAL_NUMBER
,      MFG_SERIAL_NUMBER_FLAG
,      LOT_NUMBER
,      QUANTITY
,      UNIT_OF_MEASURE
,      ACCOUNTING_CLASS_CODE
,      INSTANCE_CONDITION_ID
,      INSTANCE_STATUS_ID
,      CUSTOMER_VIEW_FLAG
,      MERCHANT_VIEW_FLAG
,      SELLABLE_FLAG
,      SYSTEM_ID
,      INSTANCE_TYPE_CODE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      LOCATION_TYPE_CODE
,      LOCATION_ID
,      INV_ORGANIZATION_ID
,      INV_SUBINVENTORY_NAME
,      INV_LOCATOR_ID
,      PA_PROJECT_ID
,      PA_PROJECT_TASK_ID
,      IN_TRANSIT_ORDER_LINE_ID
,      WIP_JOB_ID
,      PO_ORDER_LINE_ID
,      LAST_OE_ORDER_LINE_ID
,      LAST_OE_RMA_LINE_ID
,      LAST_PO_PO_LINE_ID
,      LAST_OE_PO_NUMBER
,      LAST_WIP_JOB_ID
,      LAST_PA_PROJECT_ID
,      LAST_PA_TASK_ID
,      LAST_OE_AGREEMENT_ID
,      INSTALL_DATE
,      MANUALLY_CREATED_FLAG
,      RETURN_BY_DATE
,      ACTUAL_RETURN_DATE
,      CREATION_COMPLETE_FLAG
,      COMPLETENESS_FLAG
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      LAST_TXN_LINE_DETAIL_ID
,      INSTALL_LOCATION_TYPE_CODE
,      INSTALL_LOCATION_ID
,      INSTANCE_USAGE_CODE
,      INSTANCE_PARTY_ID
,      PARTY_SOURCE_TABLE
,      PARTY_ID
,      IP_RELATIONSHIP_TYPE_CODE
,      PREFERRED_FLAG
,      PRIMARY_FLAG
,      CONTACT_FLAG
,      CONTACT_IP_ID
,      IP_CONTEXT
,      IP_ATTRIBUITE1
,      IP_ATTRIBUTE2
,      IP_ATTRIBUTE3
,      IP_ATTRIBUTE4
,      IP_ATTRIBUTE5
,      IP_ATTRIBUTE6
,      IP_ATTRIBUTE7
,      IP_ATTRIBUTE8
,      IP_ATTRIBUTE9
,      IP_ATTRIBUTE10
,      IP_ATTRIBUTE11
,      IP_ATTRIBUTE12
,      IP_ATTRIBUTE13
,      IP_ATTRIBUTE14
,      IP_ATTRIBUTE15
,      IP_ACTIVE_START_DATE
,      IP_ACTIVE_END_DATE
,      PARTY_ACCOUNT_ID
,      IPA_RELATIONSHIP_TYPE_CODE
,      IPA_ACTIVE_START_DATE
,      IPA_ACTIVE_END_DATE
,      BILL_TO_ADDRESS
,      SHIP_TO_ADDRESS
FROM APPS.CSI_INSTANCE_PARTY_V;

Dependencies

[top of page]

APPS

CSI_INSTALL_PARAMETERS

CSI_IP_ACCOUNTS

CSI_ITEM_INSTANCES

CSI_I_PARTIES

APPS

OKS_EXTWARPRGM_PVT - show dependent code