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


VIEW: APPS.AHL_PC_ASSOCIATIONS_V

Object Details
Object Name: AHL_PC_ASSOCIATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_PC_ASSOCIATIONS_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
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PC_ASSOCIATION_ID NUMBER
Yes PK for the table
OBJECT_VERSION_NUMBER NUMBER
Yes Stores locking sequence number
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PC_NODE_ID NUMBER
Yes FK to AHL_PC_NODES_B
UNIT_ITEM_ID NUMBER
Yes Unit or Item ID
UNIT_ITEM_NAME VARCHAR2 (80)
UNIT_ITEM_DESCRIPTION VARCHAR2 (240)
ASSOCIATION_TYPE_FLAG VARCHAR2 (1) Yes Assocition Type (U or I)
LINK_TO_ASSOCIATION_ID NUMBER

ID of duplicate record with different Draft Flag
DRAFT_FLAG VARCHAR2 (1) Yes This flag tells that current record has duplicate entry with different Draft Flag
OPERATION_STATUS_FLAG VARCHAR2 (1)
This indicates the operation (Copy, Delete etc). This is used mainly with the link_id.
INVENTORY_ORG_ID NUMBER

Inventory Org ID related to Item
SERIAL_NUMBER VARCHAR2 (30)
ITEM_NUMBER VARCHAR2 (40)
PRODUCT_TYPE VARCHAR2 (30)
SECURITY_GROUP_ID NUMBER

Used in application hosting
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive 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
PC_HEADER_ID NUMBER
Yes Product Classification Header Id
Query Text

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


SELECT ROW_ID
,      PC_ASSOCIATION_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PC_NODE_ID
,      UNIT_ITEM_ID
,      UNIT_ITEM_NAME
,      UNIT_ITEM_DESCRIPTION
,      ASSOCIATION_TYPE_FLAG
,      LINK_TO_ASSOCIATION_ID
,      DRAFT_FLAG
,      OPERATION_STATUS_FLAG
,      INVENTORY_ORG_ID
,      SERIAL_NUMBER
,      ITEM_NUMBER
,      PRODUCT_TYPE
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PC_HEADER_ID
FROM APPS.AHL_PC_ASSOCIATIONS_V;

Dependencies

[top of page]

APPS.AHL_PC_ASSOCIATIONS_V references the following:

SchemaAPPS
SynonymAHL_PC_ASSOCIATIONS
SynonymAHL_PC_HEADERS_B
SynonymAHL_PC_NODES_B
SynonymAHL_UNIT_CONFIG_HEADERS
SynonymCSI_ITEM_INSTANCES
SynonymMTL_SYSTEM_ITEMS_KFV
APPS.AHL_PC_ASSOCIATIONS_V is referenced by following:

SchemaAPPS
ViewAHL_PC_HEADER_DETAILS_V
ViewAHL_PC_TREE_V