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


VIEW: APPS.CST_DISTRIBUTION_V

Object Details
Object Name: CST_DISTRIBUTION_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_DISTRIBUTION_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
TRANSACTION_ID NUMBER


ORGANIZATION_ID NUMBER


WIP_ENTITY_ID NUMBER


WIP_ENTITY_NAME VARCHAR2 (240)

PRIMARY_ITEM_ID NUMBER


LINE_ID NUMBER


LINE_CODE VARCHAR2 (10)

ACCT_PERIOD_ID NUMBER


TRANSACTION_TYPE_NAME VARCHAR2 (80)

TRANSACTION_DATE DATE


TRANSACTION_QUANTITY NUMBER


TRANSACTION_UOM VARCHAR2 (3)

PRIMARY_QUANTITY NUMBER


PRIMARY_UOM VARCHAR2 (3)

OPERATION_SEQ_NUM NUMBER


CURRENCY_CODE VARCHAR2 (15)

CURRENCY_CONVERSION_DATE DATE


CURRENCY_CONVERSION_TYPE VARCHAR2 (30)

CURRENCY_CONVERSION_RATE NUMBER


DEPARTMENT_CODE VARCHAR2 (10)

DEPARTMENT_DESCRIPTION VARCHAR2 (240)

REASON_NAME VARCHAR2 (30)

REFERENCE VARCHAR2 (240)

INVENTORY_ITEM_ID NUMBER


REVISION VARCHAR2 (3)

SUBINVENTORY_CODE VARCHAR2 (10)

RESOURCE_SEQ_NUM NUMBER


REFERENCE_ACCOUNT NUMBER


RESOURCE_CODE VARCHAR2 (10)

REPETITIVE_SCHEDULE_ID NUMBER


LINE_TYPE_NAME VARCHAR2 (80)

TRANSACTION_VALUE NUMBER


BASE_TRANSACTION_VALUE NUMBER


CONTRA_SET_ID NUMBER


BASIS VARCHAR2 (80)

COST_ELEMENT VARCHAR2 (18)

ACTIVITY VARCHAR2 (10)

RATE_OR_AMOUNT NUMBER


GL_BATCH_ID NUMBER


OVERHEAD_BASIS_FACTOR NUMBER


BASIS_RESOURCE_ID NUMBER


TRANSACTION_SOURCE VARCHAR2 (20)

UNIT_COST VARCHAR2 (40)

ROW_ID ROWID (10)

LAST_UPDATE_DATE DATE


LAST_UPDATED_BY NUMBER


CREATION_DATE DATE


CREATED_BY NUMBER


LAST_UPDATE_LOGIN NUMBER


REQUEST_ID NUMBER


PROGRAM_APPLICATION_ID NUMBER


PROGRAM_ID NUMBER


PROGRAM_UPDATE_DATE DATE


ASSET_NUMBER VARCHAR2 (30)
ASSET_GROUP_ID NUMBER

REBUILD_ITEM_ID NUMBER

REBUILD_SERIAL_NUMBER VARCHAR2 (30)
Query Text

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


SELECT TRANSACTION_ID
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      PRIMARY_ITEM_ID
,      LINE_ID
,      LINE_CODE
,      ACCT_PERIOD_ID
,      TRANSACTION_TYPE_NAME
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      OPERATION_SEQ_NUM
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      DEPARTMENT_CODE
,      DEPARTMENT_DESCRIPTION
,      REASON_NAME
,      REFERENCE
,      INVENTORY_ITEM_ID
,      REVISION
,      SUBINVENTORY_CODE
,      RESOURCE_SEQ_NUM
,      REFERENCE_ACCOUNT
,      RESOURCE_CODE
,      REPETITIVE_SCHEDULE_ID
,      LINE_TYPE_NAME
,      TRANSACTION_VALUE
,      BASE_TRANSACTION_VALUE
,      CONTRA_SET_ID
,      BASIS
,      COST_ELEMENT
,      ACTIVITY
,      RATE_OR_AMOUNT
,      GL_BATCH_ID
,      OVERHEAD_BASIS_FACTOR
,      BASIS_RESOURCE_ID
,      TRANSACTION_SOURCE
,      UNIT_COST
,      ROW_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ASSET_NUMBER
,      ASSET_GROUP_ID
,      REBUILD_ITEM_ID
,      REBUILD_SERIAL_NUMBER
FROM APPS.CST_DISTRIBUTION_V;

Dependencies

[top of page]

APPS.CST_DISTRIBUTION_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymBOM_RESOURCES
SynonymCSI_ITEM_INSTANCES
SynonymCST_ACTIVITIES
ViewMFG_LOOKUPS
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_TRANSACTION_ACCOUNTS
SynonymMTL_TRANSACTION_REASONS
SynonymMTL_TRANSACTION_TYPES
SynonymPO_HEADERS
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES
SynonymWIP_LINES
SynonymWIP_REPETITIVE_ITEMS
SynonymWIP_TRANSACTIONS
SynonymWIP_TRANSACTION_ACCOUNTS

APPS.CST_DISTRIBUTION_V is not referenced by any database object