[Home] [Help] [Dependency Information]
Object Name: | INVBV_PHYSICAL_INVENTORIES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.INVBV_PHYSICAL_INVENTORIES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This shows periodic reconciliation of item counts with system on-hand quantities.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PHYSICAL_INVENTORY_ID | NUMBER | Yes | ||
PHYSICAL_INVENTORY_NAME | VARCHAR2 | (30) | Yes | |
DESCRIPTION | VARCHAR2 | (50) | ||
ORGANIZATION_ID | NUMBER | Yes | ||
PHYSICAL_INVENTORY_DATE | DATE | Yes | ||
LAST_ADJUSTMENT_DATE | DATE | |||
TOTAL_ADJUSTMENT_VALUE | NUMBER | |||
SNAPSHOT_DATE | DATE | |||
_LA:APPROVAL_FLAG | CHAR | (62) | ||
_LA:ALL_SUBINVENTORIES_FLAG | CHAR | (62) | ||
NEXT_TAG_NUMBER | VARCHAR2 | (40) | ||
TAG_NUMBER_INCREMENTS | VARCHAR2 | (40) | ||
POSITIVE_APPROVAL_TOLERANCE | NUMBER | |||
NEGATIVE_APPROVAL_TOLERANCE | NUMBER | |||
POSITIVE_COST_VARIANCE | NUMBER | |||
NEGATIVE_COST_VARIANCE | NUMBER | |||
NUMBER_OF_SKUS | NUMBER | |||
_LA:ALLOW_DYNAMIC_TAGS_FLAG | CHAR | (61) | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes |
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;
APPS.INVBV_PHYSICAL_INVENTORIES is not referenced by any database object
|
|
|