Skip to content

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

VIEW: BOM.CST_ITEM_CST_DTLS_INTERFACE#

Object Details
Object Name: CST_ITEM_CST_DTLS_INTERFACE#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

COST_TYPE_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

GROUP_ID NUMBER

ORGANIZATION_ID NUMBER

OPERATION_SEQUENCE_ID NUMBER

OPERATION_SEQ_NUM NUMBER

DEPARTMENT_ID NUMBER

LEVEL_TYPE NUMBER

ACTIVITY_ID NUMBER

RESOURCE_SEQ_NUM NUMBER

RESOURCE_ID NUMBER

RESOURCE_RATE NUMBER

ITEM_UNITS NUMBER

ACTIVITY_UNITS NUMBER

USAGE_RATE_OR_AMOUNT NUMBER

BASIS_TYPE NUMBER

BASIS_RESOURCE_ID NUMBER

BASIS_FACTOR NUMBER

NET_YIELD_OR_SHRINKAGE_FACTOR NUMBER

ITEM_COST NUMBER

COST_ELEMENT_ID NUMBER

ROLLUP_SOURCE_TYPE NUMBER

ACTIVITY_CONTEXT VARCHAR2 (30)
REQUEST_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (3)
COST_TYPE VARCHAR2 (10)
INVENTORY_ITEM VARCHAR2 (240)
DEPARTMENT VARCHAR2 (10)
ACTIVITY VARCHAR2 (10)
RESOURCE_CODE VARCHAR2 (10)
BASIS_RESOURCE_CODE VARCHAR2 (10)
COST_ELEMENT VARCHAR2 (50)
ERROR_TYPE NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

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)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TRANSACTION_ID NUMBER

PROCESS_FLAG NUMBER

ITEM_NUMBER VARCHAR2 (81)
TRANSACTION_TYPE VARCHAR2 (10)
YIELDED_COST NUMBER

ERROR_CODE VARCHAR2 (240)
ERROR_EXPLANATION VARCHAR2 (240)
LOT_SIZE NUMBER

BASED_ON_ROLLUP_FLAG NUMBER

SHRINKAGE_RATE NUMBER

INVENTORY_ASSET_FLAG NUMBER

ERROR_FLAG VARCHAR2 (1)
GROUP_DESCRIPTION VARCHAR2 (80)
Query Text

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


SELECT INVENTORY_ITEM_ID
,      COST_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      GROUP_ID
,      ORGANIZATION_ID
,      OPERATION_SEQUENCE_ID
,      OPERATION_SEQ_NUM
,      DEPARTMENT_ID
,      LEVEL_TYPE
,      ACTIVITY_ID
,      RESOURCE_SEQ_NUM
,      RESOURCE_ID
,      RESOURCE_RATE
,      ITEM_UNITS
,      ACTIVITY_UNITS
,      USAGE_RATE_OR_AMOUNT
,      BASIS_TYPE
,      BASIS_RESOURCE_ID
,      BASIS_FACTOR
,      NET_YIELD_OR_SHRINKAGE_FACTOR
,      ITEM_COST
,      COST_ELEMENT_ID
,      ROLLUP_SOURCE_TYPE
,      ACTIVITY_CONTEXT
,      REQUEST_ID
,      ORGANIZATION_CODE
,      COST_TYPE
,      INVENTORY_ITEM
,      DEPARTMENT
,      ACTIVITY
,      RESOURCE_CODE
,      BASIS_RESOURCE_CODE
,      COST_ELEMENT
,      ERROR_TYPE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TRANSACTION_ID
,      PROCESS_FLAG
,      ITEM_NUMBER
,      TRANSACTION_TYPE
,      YIELDED_COST
,      ERROR_CODE
,      ERROR_EXPLANATION
,      LOT_SIZE
,      BASED_ON_ROLLUP_FLAG
,      SHRINKAGE_RATE
,      INVENTORY_ASSET_FLAG
,      ERROR_FLAG
,      GROUP_DESCRIPTION
FROM BOM.CST_ITEM_CST_DTLS_INTERFACE#;

Dependencies

[top of page]

BOM.CST_ITEM_CST_DTLS_INTERFACE# references the following:

SchemaBOM
TableCST_ITEM_CST_DTLS_INTERFACE
BOM.CST_ITEM_CST_DTLS_INTERFACE# is referenced by following:

SchemaAPPS
SynonymCST_ITEM_CST_DTLS_INTERFACE