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

VIEW: APPS.OPI_EDW_OPIINV_DAILY_STAT_FCV

Object Details
Object Name: OPI_EDW_OPIINV_DAILY_STAT_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOPI.OPI_EDW_OPIINV_DAILY_STAT_FCV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This is the source view for extracting Invetory Daily Transaction Summary data from the discrete Manufacturing source tables.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INV_DAILY_STATUS_PK VARCHAR2 (275)
Primary key on the inventory daily status record.
BASE_CURRENCY_FK VARCHAR2 (40)
Foreign key on the currency dimension for the functional currency.
BASE_UOM_FK VARCHAR2 (20)
Foreign key on the UOM dimension.
INSTANCE_FK VARCHAR2 (30)
Foreign key to Instance Dimension
INV_ORG_FK VARCHAR2 (71)
Foreign key on the Internal Organization Dimension.
ITEM_ORG_FK VARCHAR2 (117)
Foreign key on the item dimension.
LOCATOR_FK VARCHAR2 (75)
Foreign key on inventory locator dimension.
LOT_FK VARCHAR2 (143)
Foreign key on lot dimension.
PRD_DATE_FK VARCHAR2 (4000)
Foreign key on period of time dimension.
TRX_DATE_FK VARCHAR2 (4000)
Foreign key on the transaction date.
AVG_INT_QTY NUMBER

Average daily intransit quantity in the warehouse base UOM (beginning intransit quantity + ending intransit quantity) / 2.
AVG_INT_VAL_B NUMBER

(Beginning intransit value + ending intransit value) / 2 in functional currency.
AVG_INT_VAL_G NUMBER

(Beginning intransit value + ending intransit value) / 2 in warehouse currency.
AVG_ONH_QTY NUMBER

Average daily onhand quantity (in warehouse base UOM) (beginning onhand inventory quantity + ending onhand inventory quantity) /2.
AVG_ONH_VAL_B NUMBER

Average onhand daily inventory (beginning inventory + ending inventory) / 2 in functional currency.
AVG_ONH_VAL_G NUMBER

Average onhand daily inventory (begining inventory + ending inventory) / 2 in warehouse currency.
AVG_WIP_QTY NUMBER

(Beginning WIP Quantityy + ending WIP quantity) / 2 in warehouse base UOM.
AVG_WIP_VAL_B NUMBER

(Beginning WIP value + ending WIP value) / 2 in set of books (i.e in functional currency).
AVG_WIP_VAL_G NUMBER

(Beginning WIP value + ending WIP value) / 2 in warehouse currency.
BEG_INT_QTY NUMBER

Intransit quantity balance at the beginning of the day in warehouse base UOM.
BEG_INT_VAL_B NUMBER

Intransit value at the beginning of the day in functional currency .
BEG_INT_VAL_G NUMBER

Intransit value at the beginning of the day in warehouse currency .
BEG_ONH_QTY NUMBER

Onhand quantity balance at the beginning of the day in warehouse base UOM.
BEG_ONH_VAL_B NUMBER

Onhand Inventory value at the beginning of the day in functional currency.
BEG_ONH_VAL_G NUMBER

Onhand inventory value at the beginning of the day in warehouse currency.
BEG_WIP_QTY NUMBER

WIP quantity balance at the beginning of the day in warehouse base UOM.
BEG_WIP_VAL_B NUMBER

WIP value at the beginning of the day in functional currency .
BEG_WIP_VAL_G NUMBER

WIP value at the beginning of the day in warehouse currency.
EDW_CONV_RATE NUMBER

Currency conversion rate between the organization base currency and the global currency.
END_INT_QTY NUMBER

Intransit quantity balance at the end of the day in warehouse currency.
END_INT_VAL_B NUMBER

Intransit value at the end of the day in functional currency.
END_INT_VAL_G NUMBER

Intransit value at the end of the day in warehouse currency .
END_ONH_QTY NUMBER

Onhand quantity balance at the end of the day in warehouse base UOM.
END_ONH_VAL_B NUMBER

Onhand inventory value at the end of the day in functional currency .
END_ONH_VAL_G NUMBER

Onhand inventory value at the end of the day in warehouse currency.
END_WIP_QTY NUMBER

WIP quantity balance at the ending of the day in warehouse base UOM.
END_WIP_VAL_B NUMBER

WIP value at the end of the day in functional currency.
END_WIP_VAL_G NUMBER

WIP value at the end of the day in warehouse currency.
FROM_ORG_QTY NUMBER

Quantity transferred to other organizations in warehouse base UOM.
FROM_ORG_VAL_B NUMBER

Value of inventory transferred to other organizations in functional currency.
FROM_ORG_VAL_G NUMBER

Value of inventory transferred to other organizations in warehouse currency.
INV_ADJ_QTY NUMBER

Quantity of misc inventory adjustments during the day.
INV_ADJ_VAL_B NUMBER

Value of quantity of misc inventory adjustments during the day in functional currency.
INV_ADJ_VAL_G NUMBER

Value of quantity of misc inventory adjustments during the day in warehouse currency.
PO_DEL_QTY NUMBER

Net PO receipt quantity delivered to inventory for the day in warehouse base UOM.
PO_DEL_VAL_B NUMBER

Value of PO deliveries for the day in warehouse currency in functional currency.
PO_DEL_VAL_G NUMBER

Value of PO deliveries for the day in warehouse currency in warehouse currency.
TOTAL_REC_QTY NUMBER

Total quantity received into inventory for the day in warehouse base UOM.
TOTAL_REC_VAL_B NUMBER

Total value of inventory deliveries for the day in functional currency.
TOTAL_REC_VAL_G NUMBER

Total value of inventory deliveries for the day in warehouse currency.
TOT_CUST_SHIP_QTY NUMBER

Net customer shipment quantity for the day in warehouse base UOM.
TOT_CUST_SHIP_VAL_B NUMBER

Value of customer shipments for the day in functional currency .
TOT_CUST_SHIP_VAL_G NUMBER

Value of customer shipments for the day in warehouse currency .
TOT_ISSUES_QTY NUMBER

Total quantity of issues from inventory for the day in warehouse base UOM.
TOT_ISSUES_VAL_B NUMBER

Total value of inventory issues for the day in functional currency .
TOT_ISSUES_VAL_G NUMBER

Total value of inventory issues for the day in warehouse currency .
TO_ORG_QTY NUMBER

Quantity transferred from other oraganisationss for the day in warehouse base UOM.
TO_ORG_VAL_B NUMBER

Value of interorg inventory receipts for the day in functional currency .
TO_ORG_VAL_G NUMBER

Value of interorg inventory receipts for the day in warehouse currency .
WIP_ASSY_QTY NUMBER

Return Quantity of WIP assembly.
WIP_ASSY_VAL_B NUMBER

Return value of WIP assembly in functional currency .
WIP_ASSY_VAL_G NUMBER

Return value of WIP assembly in warehouse currency.
WIP_COMP_QTY NUMBER

Net quantity completed for the day in warehouse base UOM.
WIP_COMP_VAL_B NUMBER

Value of assembly completed for the day in functional currency.
WIP_COMP_VAL_G NUMBER

Value of assembly completed for the day in warehouse currency.
WIP_ISSUE_QTY NUMBER

Net quantity issued to jobs or schedules for the day in warehouse base UOM.
WIP_ISSUE_VAL_B NUMBER

Value of inventory issued to jobs or schedules for the day in functional currency .
WIP_ISSUE_VAL_G NUMBER

Value of inventory issued to jobs or schedules for the day in warehouse currency .
LAST_UPDATE_DATE DATE

Standard WHO column.
COMMODITY_CODE VARCHAR2 (40)
Commodity code.
COST_GROUP VARCHAR2 (10)
Cost group.
CREATION_DATE DATE

Standard WHO column.
ITEM_STATUS VARCHAR2 (10)
Status of an item (Obsolete, inactive etc.).
ITEM_TYPE VARCHAR2 (30)
Seeded or user defined item type.
NETTABLE_FLAG VARCHAR2 (15)
Flag to indicate if the inventory is nettable to planning.
PERIOD_FLAG NUMBER

Flag to indicate that a record represents a period summary.
TRX_DATE DATE
Yes Transaction date.
USER_ATTRIBUTE1 VARCHAR2 (0)
User Defined Attribute1.
USER_ATTRIBUTE2 VARCHAR2 (0)
User Defined Attribute2.
USER_ATTRIBUTE3 VARCHAR2 (0)
User Defined Attribute3.
USER_ATTRIBUTE4 VARCHAR2 (0)
User Defined Attribute4.
USER_ATTRIBUTE5 VARCHAR2 (0)
User Defined Attribute5.
USER_ATTRIBUTE6 VARCHAR2 (0)
User Defined Attribute6.
USER_ATTRIBUTE7 VARCHAR2 (0)
User Defined Attribute7.
USER_ATTRIBUTE8 VARCHAR2 (0)
User Defined Attribute8.
USER_ATTRIBUTE9 VARCHAR2 (0)
User Defined Attribute9.
USER_ATTRIBUTE10 VARCHAR2 (0)
User Defined Attribute10.
USER_ATTRIBUTE11 VARCHAR2 (0)
User Defined Attribute11.
USER_ATTRIBUTE12 VARCHAR2 (0)
User Defined Attribute12.
USER_ATTRIBUTE13 VARCHAR2 (0)
User Defined Attribute13.
USER_ATTRIBUTE14 VARCHAR2 (0)
User Defined Attribute14.
USER_ATTRIBUTE15 VARCHAR2 (0)
User Defined Attribute15.
USER_MEASURE1 NUMBER

User defined measure.
USER_MEASURE2 NUMBER

User defined measure.
USER_MEASURE3 NUMBER

User defined measure.
USER_MEASURE4 NUMBER

User defined measure.
USER_MEASURE5 NUMBER

User defined measure.
USER_FK1 VARCHAR2 (0)
User defined dimension foreign key.
USER_FK2 VARCHAR2 (0)
User defined dimension the foreign key.
USER_FK3 VARCHAR2 (0)
User defined dimension the foreign key.
USER_FK4 VARCHAR2 (0)
User defined dimension the foreign key.
USER_FK5 VARCHAR2 (0)
User defined dimension the foreign key.
OPERATION_CODE VARCHAR2 (0)
Operation code.
PUSH_FLAG NUMBER

Indicates whether the data will be collected into staging table (opi_edw_inv_daily_stat_fstg) in the current load.
Query Text

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


SELECT INV_DAILY_STATUS_PK
,      BASE_CURRENCY_FK
,      BASE_UOM_FK
,      INSTANCE_FK
,      INV_ORG_FK
,      ITEM_ORG_FK
,      LOCATOR_FK
,      LOT_FK
,      PRD_DATE_FK
,      TRX_DATE_FK
,      AVG_INT_QTY
,      AVG_INT_VAL_B
,      AVG_INT_VAL_G
,      AVG_ONH_QTY
,      AVG_ONH_VAL_B
,      AVG_ONH_VAL_G
,      AVG_WIP_QTY
,      AVG_WIP_VAL_B
,      AVG_WIP_VAL_G
,      BEG_INT_QTY
,      BEG_INT_VAL_B
,      BEG_INT_VAL_G
,      BEG_ONH_QTY
,      BEG_ONH_VAL_B
,      BEG_ONH_VAL_G
,      BEG_WIP_QTY
,      BEG_WIP_VAL_B
,      BEG_WIP_VAL_G
,      EDW_CONV_RATE
,      END_INT_QTY
,      END_INT_VAL_B
,      END_INT_VAL_G
,      END_ONH_QTY
,      END_ONH_VAL_B
,      END_ONH_VAL_G
,      END_WIP_QTY
,      END_WIP_VAL_B
,      END_WIP_VAL_G
,      FROM_ORG_QTY
,      FROM_ORG_VAL_B
,      FROM_ORG_VAL_G
,      INV_ADJ_QTY
,      INV_ADJ_VAL_B
,      INV_ADJ_VAL_G
,      PO_DEL_QTY
,      PO_DEL_VAL_B
,      PO_DEL_VAL_G
,      TOTAL_REC_QTY
,      TOTAL_REC_VAL_B
,      TOTAL_REC_VAL_G
,      TOT_CUST_SHIP_QTY
,      TOT_CUST_SHIP_VAL_B
,      TOT_CUST_SHIP_VAL_G
,      TOT_ISSUES_QTY
,      TOT_ISSUES_VAL_B
,      TOT_ISSUES_VAL_G
,      TO_ORG_QTY
,      TO_ORG_VAL_B
,      TO_ORG_VAL_G
,      WIP_ASSY_QTY
,      WIP_ASSY_VAL_B
,      WIP_ASSY_VAL_G
,      WIP_COMP_QTY
,      WIP_COMP_VAL_B
,      WIP_COMP_VAL_G
,      WIP_ISSUE_QTY
,      WIP_ISSUE_VAL_B
,      WIP_ISSUE_VAL_G
,      LAST_UPDATE_DATE
,      COMMODITY_CODE
,      COST_GROUP
,      CREATION_DATE
,      ITEM_STATUS
,      ITEM_TYPE
,      NETTABLE_FLAG
,      PERIOD_FLAG
,      TRX_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      OPERATION_CODE
,      PUSH_FLAG
FROM APPS.OPI_EDW_OPIINV_DAILY_STAT_FCV;

Dependencies

[top of page]

APPS.OPI_EDW_OPIINV_DAILY_STAT_FCV references the following:

SchemaAPPS
SynonymCST_COST_GROUPS
SynonymEDW_LOCAL_INSTANCE
PL/SQL PackageEDW_TIME_PKG - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
SynonymOPI_IDS_PUSH_LOG
ViewORG_ORGANIZATION_DEFINITIONS
APPS.OPI_EDW_OPIINV_DAILY_STAT_FCV is referenced by following:

SchemaAPPS
Package BodyOPI_EDW_INV_DAILY_STAT_F_C - show dependent code