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

VIEW: APPS.INVBV_PHYSICAL_ADJUSTMENTS

Object Details
Object Name: INVBV_PHYSICAL_ADJUSTMENTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.INVBV_PHYSICAL_ADJUSTMENTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows physical inventory adjustments created by item counts.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ADJUSTMENT_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
PHYSICAL_INVENTORY_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
SYSTEM_QUANTITY NUMBER
Yes
COUNT_QUANTITY NUMBER


ADJUSTMENT_QUANTITY NUMBER
Yes
REVISION VARCHAR2 (3)

SUBINVENTORY_NAME NUMBER


INVENTORY_LOCATOR_ID VARCHAR2 (10) Yes
LOT_NUMBER VARCHAR2 (80)

LOT_EXPIRATION_DATE DATE


SERIAL_NUMBER VARCHAR2 (30)

COST_PER_UNIT NUMBER


_LA:APPROVAL_STATUS CHAR (57)

APPROVED_BY_EMPLOYEE_ID NUMBER (9)

ADJUSTMENT_ACCOUNT_ID NUMBER


CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
Query Text

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


SELECT ADJUSTMENT_ID
,      ORGANIZATION_ID
,      PHYSICAL_INVENTORY_ID
,      INVENTORY_ITEM_ID
,      SYSTEM_QUANTITY
,      COUNT_QUANTITY
,      ADJUSTMENT_QUANTITY
,      REVISION
,      SUBINVENTORY_NAME
,      INVENTORY_LOCATOR_ID
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      SERIAL_NUMBER
,      COST_PER_UNIT
,      _LA:APPROVAL_STATUS
,      APPROVED_BY_EMPLOYEE_ID
,      ADJUSTMENT_ACCOUNT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.INVBV_PHYSICAL_ADJUSTMENTS;

Dependencies

[top of page]

APPS.INVBV_PHYSICAL_ADJUSTMENTS references the following:

SchemaAPPS
SynonymMTL_PHYSICAL_ADJUSTMENTS

APPS.INVBV_PHYSICAL_ADJUSTMENTS is not referenced by any database object