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

VIEW: APPS.PMIFV_INVENTORY_TRANSACTIONS_V

Object Details
Object Name: PMIFV_INVENTORY_TRANSACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMIFV_INVENTORY_TRANSACTIONS_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view contains detail information about all completed and pending Inventory transaction .


[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE CHAR (1)
C=from completed transactions, P=from pending transactions
TRANS_ID NUMBER (10)
Surrogate key for the item.
ITEM_ID NUMBER (10)
Unique key for the transaction.
LINE_ID NUMBER (10)
Surrogate key for the document line that produced the transaction.
CO_CODE VARCHAR2 (4)
Company affected by the transaction (company which owns the organization which created the transaction).
ORGN_CODE VARCHAR2 (4)
Organization which created the transaction.
WHSE_CODE VARCHAR2 (4)
Warehouse affected by the transaction.
LOT_ID NUMBER (10)
Surrogate key of the lot.
LOCATION VARCHAR2 (16)
Location affected by the transaction.
DOC_ID NUMBER (10)
Surrogate key of the document that created the transaction.
DOC_TYPE VARCHAR2 (4)
Type of document which created the transaction.
DOC_LINE NUMBER (10)
Not currently used.
LINE_TYPE NUMBER (5)
Line type.
LINE_TYPE_MEANING VARCHAR2 (80)
Line type.
REASON_CODE VARCHAR2 (4)
Reason code associated with the transaction.
TRANS_DATE DATE

Transaction date.
TRANS_QTY NUMBER

Quantity of the transaction in the primary UOM of an item.
TRANS_QTY2 NUMBER

Quantity of the transaction in the secodary UOM of an item, if dual UOM controlled.
QC_GRADE VARCHAR2 (4)
Grade associated with the transaction.
LOT_STATUS VARCHAR2 (4)
Lot status associated with the transaction.
TRANS_STAT VARCHAR2 (4)
Not currently used.
TRANS_UM VARCHAR2 (4)
UOM in which trans_qty is expressed.
TRANS_UM2 VARCHAR2 (4)
UOM in which trans_qty2 is expressed.
OP_CODE NUMBER (15)
Operator who created the transaction.
GL_POSTED_IND NUMBER (10)
GL posted indicator. 0=Not posted to GL, 1=Posted to GL.
EVENT_ID NUMBER (10)
Event ID.
ITEM_NO VARCHAR2 (32)
Name of the item.
ITEM_DESCRIPTION VARCHAR2 (70)
Short description of the item that is displayed during the item look up.
ITEM_UOM VARCHAR2 (4)
Uom of the item by which the inventory balances are maintained.
CURRENT_FISCAL_YEAR VARCHAR2 (4)
Fiscal year defined in Inventory calendar
CURRENT_PERIOD NUMBER (5)
Current Period
PERIOD_DESC VARCHAR2 (40)
Period Description
PERIOD_START_DATE DATE

Period start date
PERIOD_END_DATE DATE

Period end date
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
Query Text

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


SELECT SOURCE
,      TRANS_ID
,      ITEM_ID
,      LINE_ID
,      CO_CODE
,      ORGN_CODE
,      WHSE_CODE
,      LOT_ID
,      LOCATION
,      DOC_ID
,      DOC_TYPE
,      DOC_LINE
,      LINE_TYPE
,      LINE_TYPE_MEANING
,      REASON_CODE
,      TRANS_DATE
,      TRANS_QTY
,      TRANS_QTY2
,      QC_GRADE
,      LOT_STATUS
,      TRANS_STAT
,      TRANS_UM
,      TRANS_UM2
,      OP_CODE
,      GL_POSTED_IND
,      EVENT_ID
,      ITEM_NO
,      ITEM_DESCRIPTION
,      ITEM_UOM
,      CURRENT_FISCAL_YEAR
,      CURRENT_PERIOD
,      PERIOD_DESC
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.PMIFV_INVENTORY_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.PMIFV_INVENTORY_TRANSACTIONS_V references the following:

SchemaAPPS
PL/SQL PackageGMICUOM - show dependent code
SynonymIC_ITEM_MST
SynonymIC_TRAN_CMP
SynonymIC_TRAN_PND
PL/SQL PackagePMI_COST_ANALZ_PACK - show dependent code
ViewPMI_INV_CALENDAR_V
PL/SQL PackagePMI_SECURITY_PKG - show dependent code
SynonymSY_ORGN_MST

APPS.PMIFV_INVENTORY_TRANSACTIONS_V is not referenced by any database object