eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PMIFV_LOT_SOURCE_PURCH_V

Object Details

Object Name:	PMIFV_LOT_SOURCE_PURCH_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMIFV_LOT_SOURCE_PURCH_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Comments
PRODUCT_ITEM_ID	NUMBER		Product Item ID
PRODUCT_LOT_ID	NUMBER		Product Lot ID
INGREDIENT_ITEM_ID	NUMBER		Ingredient Item ID
INGREDIENT_LOT_ID	NUMBER		Ingredient Lot ID
PRODUCT_WAREHOUSE	VARCHAR2	(4)	Product Warehouse
PRODUCT_LOCATION	VARCHAR2	(16)	Product Location
TRANSACTION_DATE	DATE		Transaction Date
TRANSACTION_QUANTITY	NUMBER		Transaction Quantity
TRANSACTION_QUANTITY_UOM2	NUMBER		Transaction Quantity UOM2
ORGANIZATION_CODE	VARCHAR2	(4)	Organization Code
RECEIPT_NO	VARCHAR2	(32)	Receipt Number
PURCHASE_ORDER_NO	VARCHAR2	(32)	Purchase Order Number
VENDOR_NO	VARCHAR2	(154)	Vender Number
VENDOR_NAME	VARCHAR2	(240)	Vendor Name
INGREDIENT_ITEM_NO	VARCHAR2	(32)	Ingredient Item Number
INGREDIENT_ITEM_DESCRIPTION	VARCHAR2	(70)	Ingredient Item Description
INGREDIENT_ITEM_UOM	VARCHAR2	(4)	Ingredient Item UOM
INGREDIENT_ITEM_UOM2	VARCHAR2	(4)	Ingredient Item UOM2
INGREDIENT_ITEM_INV_CLASS	VARCHAR2	(8)	Ingredient Item Inventory Class
INGREDIENT_ITEM_PLAN_CLASS	VARCHAR2	(8)	Ingredient Item Planning Class
INGREDIENT_ITEM_SALES_CLASS	VARCHAR2	(8)	Ingredient Item Sales Class
INGREDIENT_LOT_NO	VARCHAR2	(32)	Ingredient Lot Number
INGREDIENT_SUBLOT_NO	VARCHAR2	(32)	Ingredient Sublot Number
PRODUCT_ITEM_NO	VARCHAR2	(32)	Product Item Number
PRODUCT_ITEM_DESCRIPTION	VARCHAR2	(70)	Product Item Description
PRODUCT_ITEM_UOM	VARCHAR2	(4)	Product Item UOM
PRODUCT_ITEM_UOM2	VARCHAR2	(4)	Product Item UOM2
PRODUCT_LOT_NO	VARCHAR2	(32)	Product Lot Number
PRODUCT_SUBLOT_NO	VARCHAR2	(32)	Product Sublot Number

Query Text

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


SELECT PRODUCT_ITEM_ID
,      PRODUCT_LOT_ID
,      INGREDIENT_ITEM_ID
,      INGREDIENT_LOT_ID
,      PRODUCT_WAREHOUSE
,      PRODUCT_LOCATION
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      TRANSACTION_QUANTITY_UOM2
,      ORGANIZATION_CODE
,      RECEIPT_NO
,      PURCHASE_ORDER_NO
,      VENDOR_NO
,      VENDOR_NAME
,      INGREDIENT_ITEM_NO
,      INGREDIENT_ITEM_DESCRIPTION
,      INGREDIENT_ITEM_UOM
,      INGREDIENT_ITEM_UOM2
,      INGREDIENT_ITEM_INV_CLASS
,      INGREDIENT_ITEM_PLAN_CLASS
,      INGREDIENT_ITEM_SALES_CLASS
,      INGREDIENT_LOT_NO
,      INGREDIENT_SUBLOT_NO
,      PRODUCT_ITEM_NO
,      PRODUCT_ITEM_DESCRIPTION
,      PRODUCT_ITEM_UOM
,      PRODUCT_ITEM_UOM2
,      PRODUCT_LOT_NO
,      PRODUCT_SUBLOT_NO
FROM APPS.PMIFV_LOT_SOURCE_PURCH_V;

Dependencies

[top of page]

APPS.PMIFV_LOT_SOURCE_PURCH_V references the following:

APPS: FND_GLOBAL - show dependent code; IC_ITEM_MST; IC_LOTS_MST; IC_TRAN_CMP; IC_TRAN_PND; IC_WHSE_MST; PMI_LOT_GENEALOGY; PMI_LOT_SOURCE_LEAF_V; PO_HEADERS_ALL; PO_ORDR_HDR; PO_RECV_DTL; PO_RECV_HDR; PO_VENDORS_VIEW; PO_VENDOR_SITES_ALL; PO_VEND_MST; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.PMIFV_LOT_SOURCE_PURCH_V is not referenced by any database object