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

VIEW: APPS.DDR_IS_MFG_SHIP_ERR_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes Unique Record ID per Transaction for Error Handling
BSNS_UNIT_CD VARCHAR2 (30)
Global identifier for the location (typically a retail store or distribution center)
SHIP_TO_ORG_CD VARCHAR2 (30)
Natural Key Code for the ship to Organization
SHIP_TO_BSNS_UNIT_CD VARCHAR2 (30)
Global identifier for the location shipped to (retail store or distribution center)
MFG_SKU_ITEM_NBR VARCHAR2 (30)
Unique Manufacturer proprietary SKU Item Number
TRANS_DT DATE
Yes The date for which the value is being reported
UOM VARCHAR2 (30)
Unit of measure code for the transaction
SHIP_QTY NUMBER

Day total Shipment Quantity in Transition UOM specified
SHIP_AMT NUMBER

Value of Shipment Amount
SHIP_COST NUMBER

The cost of the products being shipped
SRC_SYS_IDNT VARCHAR2 (40) Yes Source file name or system that provided the data. It can be used to cross-reference the data with the source system, mainly for auditing purpose
SRC_SYS_DT DATE
Yes The date that the data was created. It can be used to cross-reference the data with the source system, mainly for auditing purpose
Query Text

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


SELECT REC_ID
,      BSNS_UNIT_CD
,      SHIP_TO_ORG_CD
,      SHIP_TO_BSNS_UNIT_CD
,      MFG_SKU_ITEM_NBR
,      TRANS_DT
,      UOM
,      SHIP_QTY
,      SHIP_AMT
,      SHIP_COST
,      SRC_SYS_IDNT
,      SRC_SYS_DT
FROM APPS.DDR_IS_MFG_SHIP_ERR_V;

Dependencies

[top of page]

APPS.DDR_IS_MFG_SHIP_ERR_V references the following:

SchemaAPPS
SynonymDDR_I_MFG_SHIP_ITEM
SynonymDDR_S_MFG_SHIP_ITEM

APPS.DDR_IS_MFG_SHIP_ERR_V is not referenced by any database object