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

VIEW: APPS.INVFV_LOT_TRANSACTIONS

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

View Type

A Business Intelligence System view


This shows lot-triggered transactions.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER


LOT_NUMBER VARCHAR2 (80) Yes
INVENTORY_ITEM_ID NUMBER
Yes
_KF:INVENTORY_ITEM_NAME CHAR (16)
ORGANIZATION_ID NUMBER
Yes
SUBINVENTORY_NAME VARCHAR2 (10)

INVENTORY_LOCATOR_ID NUMBER


REVISION VARCHAR2 (3)

TRANSACTION_DATE DATE
Yes
TRANSACTION_SOURCE_ID NUMBER


TRANSACTION_SOURCE_TYPE_ID NUMBER


TRANSACTION_SOURCE_TYPE_NAME VARCHAR2 (30) Yes
TRANSACTION_SOURCE_NAME VARCHAR2 (240)

SERIAL_NUMBER_TRANSACTION_ID NUMBER


LOT_TXN_QUANTITY NUMBER
Yes
PRIMARY_LOT_TXN_QUANTITY NUMBER
Yes
TRANSACTION_UOM VARCHAR2 (3) Yes
PRIMARY_UOM VARCHAR2 (3)

Query Text

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


SELECT TRANSACTION_ID
,      LOT_NUMBER
,      INVENTORY_ITEM_ID
,      _KF:INVENTORY_ITEM_NAME
,      ORGANIZATION_ID
,      SUBINVENTORY_NAME
,      INVENTORY_LOCATOR_ID
,      REVISION
,      TRANSACTION_DATE
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_TYPE_NAME
,      TRANSACTION_SOURCE_NAME
,      SERIAL_NUMBER_TRANSACTION_ID
,      LOT_TXN_QUANTITY
,      PRIMARY_LOT_TXN_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_UOM
FROM APPS.INVFV_LOT_TRANSACTIONS;

Dependencies

[top of page]

APPS.INVFV_LOT_TRANSACTIONS references the following:

SchemaAPPS
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_TRANSACTION_LOT_NUMBERS
SynonymMTL_TXN_SOURCE_TYPES

APPS.INVFV_LOT_TRANSACTIONS is not referenced by any database object