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

VIEW: AMS.AMS_ACT_PRODUCTS#

Object Details
Object Name: AMS_ACT_PRODUCTS#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTIVITY_PRODUCT_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
ACT_PRODUCT_USED_BY_ID NUMBER
Yes
ARC_ACT_PRODUCT_USED_BY VARCHAR2 (30) Yes
PRODUCT_SALE_TYPE VARCHAR2 (30)
PRIMARY_PRODUCT_FLAG VARCHAR2 (1) Yes
ENABLED_FLAG VARCHAR2 (1) Yes
INVENTORY_ITEM_ID NUMBER (38)
ORGANIZATION_ID NUMBER (32)
CATEGORY_ID NUMBER

CATEGORY_SET_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
LEVEL_TYPE_CODE VARCHAR2 (30)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
EXCLUDED_FLAG VARCHAR2 (1)
SECURITY_GROUP_ID NUMBER

LINE_LUMPSUM_AMOUNT NUMBER

LINE_LUMPSUM_QTY NUMBER

SCAN_VALUE NUMBER

UOM_CODE VARCHAR2 (3)
ADJUSTMENT_FLAG VARCHAR2 (1)
SCAN_UNIT_FORECAST NUMBER

CHANNEL_ID NUMBER

QUANTITY NUMBER

Query Text

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


SELECT ACTIVITY_PRODUCT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ACT_PRODUCT_USED_BY_ID
,      ARC_ACT_PRODUCT_USED_BY
,      PRODUCT_SALE_TYPE
,      PRIMARY_PRODUCT_FLAG
,      ENABLED_FLAG
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      LEVEL_TYPE_CODE
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EXCLUDED_FLAG
,      SECURITY_GROUP_ID
,      LINE_LUMPSUM_AMOUNT
,      LINE_LUMPSUM_QTY
,      SCAN_VALUE
,      UOM_CODE
,      ADJUSTMENT_FLAG
,      SCAN_UNIT_FORECAST
,      CHANNEL_ID
,      QUANTITY
FROM AMS.AMS_ACT_PRODUCTS#;

Dependencies

[top of page]

AMS.AMS_ACT_PRODUCTS# references the following:

SchemaAMS
TableAMS_ACT_PRODUCTS
AMS.AMS_ACT_PRODUCTS# is referenced by following:

SchemaAPPS
SynonymAMS_ACT_PRODUCTS