[Home] [Help] [Dependency Information]
Object Name: | CSD_RETURNS_BI_RCV_TXNS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
View for receiving transactions used in Business Intelligence
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_HEADER_ID | NUMBER | Yes | Order Header Id | |
ORDER_LINE_ID | NUMBER | Yes | Order Line Id | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Id | |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit of Measure for Inventory Item Id | |
RECEIVED_QUANTITY | NUMBER | Quantity Received | ||
QUANTITY_UOM_CODE | VARCHAR2 | (3) | Unit of Measure for Quantity Received | |
INVENTORY_ORG_ID | NUMBER | Inventory Organization Id | ||
TRANSACTION_DATE | DATE | Truncated Transaction Date | ||
RETURN_REASON_CODE | VARCHAR2 | (30) | Return Reason Lookup Code | |
RETURN_STREAM_CODE | VARCHAR2 | (30) | Return Stream Lookup Code | |
OPERATING_UNIT_ID | NUMBER | Operating Unit Id | ||
RECEIVED_WEIGHT | NUMBER | Weight of Received Items | ||
WEIGHT_UOM_CODE | VARCHAR2 | (3) | Unit of Measure for Received Weight | |
RECEIVED_VALUE | NUMBER | Value of Received Items | ||
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency Code for Value of Received Item |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_HEADER_ID
, ORDER_LINE_ID
, INVENTORY_ITEM_ID
, PRIMARY_UOM_CODE
, RECEIVED_QUANTITY
, QUANTITY_UOM_CODE
, INVENTORY_ORG_ID
, TRANSACTION_DATE
, RETURN_REASON_CODE
, RETURN_STREAM_CODE
, OPERATING_UNIT_ID
, RECEIVED_WEIGHT
, WEIGHT_UOM_CODE
, RECEIVED_VALUE
, CURRENCY_CODE
FROM APPS.CSD_RETURNS_BI_RCV_TXNS_V;
APPS.CSD_RETURNS_BI_RCV_TXNS_V is not referenced by any database object
|
|
|