[Home] [Help] [Dependency Information]

VIEW: APPS.INVBV_PHYSICAL_INVENTORIES

Object Details

Object Name:	INVBV_PHYSICAL_INVENTORIES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.INVBV_PHYSICAL_INVENTORIES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows periodic reconciliation of item counts with system on-hand quantities.

[View Source]

Columns

Query Text

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

SELECT PHYSICAL_INVENTORY_ID
,      PHYSICAL_INVENTORY_NAME
,      DESCRIPTION
,      ORGANIZATION_ID
,      PHYSICAL_INVENTORY_DATE
,      LAST_ADJUSTMENT_DATE
,      TOTAL_ADJUSTMENT_VALUE
,      SNAPSHOT_DATE
,      _LA:APPROVAL_FLAG
,      _LA:ALL_SUBINVENTORIES_FLAG
,      NEXT_TAG_NUMBER
,      TAG_NUMBER_INCREMENTS
,      POSITIVE_APPROVAL_TOLERANCE
,      NEGATIVE_APPROVAL_TOLERANCE
,      POSITIVE_COST_VARIANCE
,      NEGATIVE_COST_VARIANCE
,      NUMBER_OF_SKUS
,      _LA:ALLOW_DYNAMIC_TAGS_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.INVBV_PHYSICAL_INVENTORIES;

Dependencies

[top of page]

APPS

MTL_PHYSICAL_INVENTORIES

APPS.INVBV_PHYSICAL_INVENTORIES is not referenced by any database object