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

VIEW: APPS.CSD_RETURNS_BI_MTL_TXNS_V

Object Details
Object Name: CSD_RETURNS_BI_MTL_TXNS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


View for material transactions used in Business Intelligence


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

Material Transaction Id
INVENTORY_ORG_ID NUMBER

Inventory Organziation Id
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
INVENTORY_ITEM_DESC VARCHAR2 (40)
Inventory Item Description
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary Unit Of Measure for Inventory Item
TRANSACTION_QUANTITY NUMBER

Quantity Transacted
TRANSACTION_UOM_CODE VARCHAR2 (3)
Unit of Measure for Transaction Quantity
TRANSACTION_DATE DATE

Truncated Transaction Date
REASON_ID NUMBER

Material Transaction Reason Id
MTL_DISPOSITION_CODE VARCHAR2 (30)
Material Disposition Lookup Code
TRANSACTED_WEIGHT NUMBER

Transacted Weight
WEIGHT_UOM_CODE VARCHAR2 (3)
Unit of Measure for Transacted Weight
OPERATING_UNIT_ID NUMBER

Operating Unit Id
Query Text

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


SELECT TRANSACTION_ID
,      INVENTORY_ORG_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_DESC
,      PRIMARY_UOM_CODE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM_CODE
,      TRANSACTION_DATE
,      REASON_ID
,      MTL_DISPOSITION_CODE
,      TRANSACTED_WEIGHT
,      WEIGHT_UOM_CODE
,      OPERATING_UNIT_ID
FROM APPS.CSD_RETURNS_BI_MTL_TXNS_V;

Dependencies

[top of page]

APPS.CSD_RETURNS_BI_MTL_TXNS_V references the following:

SchemaAPPS
SynonymCSD_MTL_DISPOSITION_REASONS
PL/SQL PackageCSD_RETURNS_BI_UTIL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_SYSTEM_ITEMS_KFV
ViewORG_ORGANIZATION_DEFINITIONS

APPS.CSD_RETURNS_BI_MTL_TXNS_V is not referenced by any database object