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

VIEW: APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV

Object Details
Object Name: OPI_EDW_OPMINV_DAILY_STAT_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOPI.OPI_EDW_OPMINV_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 Process Manufacturing source tables.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INV_DAILY_STATUS_PK VARCHAR2 (172)
Primary key on the inventory daily status record.
BASE_CURRENCY_FK VARCHAR2 (4) Yes Foreign key on the currency dimension for functional currency.
BASE_UOM_FK VARCHAR2 (4000)
Foreign key on the UOM dimension.
INSTANCE_FK VARCHAR2 (30)
Foreign key to instance dimension
INV_ORG_FK VARCHAR2 (4000)
Foreign key on the internal organization dimension.
ITEM_ORG_FK VARCHAR2 (4000)
Foreign key on the item dimension.
LOCATOR_FK VARCHAR2 (4000)
Foreign key on the inventory locator dimension.
LOT_FK VARCHAR2 (116)
Foreign key on the lot dimension.
PRD_DATE_FK VARCHAR2 (4000)
Foreign key on the period of time dimension.
TRX_DATE_FK VARCHAR2 (4000)
Foreign key on the transaction date.
AVG_INT_QTY VARCHAR2 (0)
Average daily intransit quantity in warehouse base UOM (beginning Intransit Qty + ending Intransit Qty) / 2.
AVG_INT_VAL_B VARCHAR2 (0)
(Beginning Intransit value + ending Intransit value) / 2 in functional currency.
AVG_INT_VAL_G VARCHAR2 (0)
(Beginning Intransit value + ending Intransit value) / 2 in warehouse currency.
AVG_ONH_QTY NUMBER

Average daily onhand quantity (in warehouse base UOM) (beginning Onh Inv Qty + ending Onh Inv Qty) /2.
AVG_ONH_VAL_B VARCHAR2 (0)
Average onhand daily inventory (beginning. Inv + ending inventory) / 2 in functional currency.
AVG_ONH_VAL_G VARCHAR2 (0)
Average onhand daily inventory (beginning. Inv + ending inventory) / 2 in warehouse currency.
AVG_WIP_QTY VARCHAR2 (0)
(Beginning WIP Qty + ending WIP Qty) / 2 in warehouse base UOM.
AVG_WIP_VAL_B VARCHAR2 (0)
(Beginning WIP value + ending WIP value) / 2 in functional currency.
AVG_WIP_VAL_G VARCHAR2 (0)
(Beginning WIP value + ending WIP value) / 2 in warehouse currency.
BEG_INT_QTY VARCHAR2 (0)
Intransit quantity balance at the beginning of the day in warehouse base UOM.
BEG_INT_VAL_B VARCHAR2 (0)
Intransit value at the beginning of the day in functional currency.
BEG_INT_VAL_G VARCHAR2 (0)
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 VARCHAR2 (40)
Onhand inventory value at the beginning of the day in warehouse currency.
BEG_WIP_QTY VARCHAR2 (0)
WIP quantity balance at the beginning of the day in warehouse base UOM.
BEG_WIP_VAL_B VARCHAR2 (0)
WIP value at the beginning of the day in functional currency.
BEG_WIP_VAL_G VARCHAR2 (0)
WIP value at the beginning of the day in warehouse currency.
END_INT_QTY VARCHAR2 (0)
Intransit quantity balance at the end of the day in warehouse currency.
END_INT_VAL_B VARCHAR2 (0)
Intransit value at the end of the day in warehouse currency in functional currency.
END_INT_VAL_G VARCHAR2 (0)
Intransit value at the end of the day in warehouse currency 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 VARCHAR2 (40)
Onhand inventory value at the end of the day in warehouse currency.
END_WIP_QTY VARCHAR2 (0)
WIP quantity balance at the end of the day in warehouse base UOM.
END_WIP_VAL_B VARCHAR2 (0)
WIP value at the end of the day in functional currency.
END_WIP_VAL_G VARCHAR2 (0)
WIP value at the end of the day in warehouse currency.
FROM_ORG_QTY NUMBER

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

Value of inventory transferred to other organzations in functional currency.
FROM_ORG_VAL_G VARCHAR2 (40)
Value of inventory transferred to other organzations 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 day in functional currency.
INV_ADJ_VAL_G VARCHAR2 (40)
Value of quantity of misc inventory adjustments during 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 VARCHAR2 (40)
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 VARCHAR2 (40)
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 VARCHAR2 (40)
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 VARCHAR2 (0)
Total value of inventory issues for the day in functional currency.
TOT_ISSUES_VAL_G VARCHAR2 (0)
Total value of inventory issues for the day in warehouse currency.
TO_ORG_QTY NUMBER

Quantity transferred from other organzations 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 VARCHAR2 (40)
Value of interorg inventory receipts for the day in warehouse currency.
WIP_ASSY_QTY VARCHAR2 (0)
Return Qty of WIP assembly.
WIP_ASSY_VAL_B VARCHAR2 (0)
Return value of WIP Assembly in functional currency.
WIP_ASSY_VAL_G VARCHAR2 (0)
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 VARCHAR2 (40)
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 VARCHAR2 (40)
Value of inventory issued to jobs or schedules for the day in warehouse currency.
LAST_UPDATE_DATE DATE

Standard WHO Column.
COMMODITY_CODE VARCHAR2 (9)
Commoditiy code.
COST_GROUP CHAR (13)
Cost group.
CREATION_DATE DATE

Standard WHO column.
ITEM_STATUS NUMBER (5) Yes Status of an item (Obsolete, inactive etc.).
ITEM_TYPE VARCHAR2 (4)
Seeded or user-defined item type.
NETTABLE_FLAG VARCHAR2 (0)
Indicates if inventory is nettable to planning.
PERIOD_FLAG NUMBER

Flag to indicate that a record represents a period summary.
TRX_DATE DATE
Yes Standard WHO Column.
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 foreign key.
USER_FK3 VARCHAR2 (0)
User defined dimension foreign key.
USER_FK4 VARCHAR2 (0)
User defined dimension foreign key.
USER_FK5 VARCHAR2 (0)
User defined dimension foreign key.
COST_MTHD VARCHAR2 (4) Yes Cost method.
SOB_ID NUMBER (10)
Set of books identifier.
LOT_ID NUMBER
Yes Surrogate key for the lot/sublot.
ITEM_ID NUMBER
Yes Surrogate key for the item.
CO_CODE VARCHAR2 (4) Yes Company code of the organisation.
ORGN_CODE VARCHAR2 (4) Yes Organisation code.
WHSE_CODE VARCHAR2 (4) Yes Warehouse code.
LOCATION VARCHAR2 (16) Yes Location name for the daily inventory.
VIEW_ID NUMBER

View Identifier.
SEQ_ID NUMBER

Surrogate key for the sequence.
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
,      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
,      COST_MTHD
,      SOB_ID
,      LOT_ID
,      ITEM_ID
,      CO_CODE
,      ORGN_CODE
,      WHSE_CODE
,      LOCATION
,      VIEW_ID
,      SEQ_ID
FROM APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV;

Dependencies

[top of page]

APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV references the following:

SchemaAPPS
PL/SQL PackageEDW_CURRENCY - show dependent code
PL/SQL PackageEDW_ITEMS_PKG - show dependent code
SynonymEDW_LOCAL_INSTANCE
PL/SQL PackageEDW_MTL_INVENTORY_LOC_PKG - show dependent code
PL/SQL PackageEDW_ORGANIZATION_PKG - show dependent code
PL/SQL PackageEDW_TIME_PKG - show dependent code
PL/SQL PackageEDW_UTIL - show dependent code
SynonymGL_PLCY_MST
SynonymIC_ITEM_MST
SynonymIC_LOCT_MST
SynonymIC_WHSE_MST
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymOPI_EDW_OPMINV_DAILY_STAT_INC
SynonymOPI_PMI_INV_DAILY_STAT_SUM
SynonymOPI_PMI_UOMS_MST
APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV is referenced by following:

SchemaAPPS
Package BodyOPI_EDW_OPMINV_DAILY_STAT_F_C - show dependent code