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.PMIBV_LOT_SOURCE_PURCH_V

Object Details

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

View Type

A Business Intelligence System view

This view lists the raw material lots that went into a product lot.

[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		Transacted Quantity in Primary UOM
TRANSACTION_QUANTITY_UOM2	NUMBER		Transacted Quantity in Secondary UOM
ORGANIZATION_CODE	VARCHAR2	(4)	Organization Code
RECEIPT_NO	VARCHAR2	(32)	PO Receipt Number
PURCHASE_ORDER_NO	VARCHAR2	(32)	Purchase Order Number
VENDOR_NO	VARCHAR2	(154)	Vendor Number
VENDOR_NAME	VARCHAR2	(240)	Vendor Name
INGREDIENT_ITEM_NO	VARCHAR2	(32)	Ingredient Number
INGREDIENT_ITEM_DESCRIPTION	VARCHAR2	(70)	Ingredient Item Description
INGREDIENT_ITEM_UOM	VARCHAR2	(4)	Ingredient Primary UOM
INGREDIENT_ITEM_UOM2	VARCHAR2	(4)	Ingredient Secondary UOM
INGREDIENT_ITEM_INV_CLASS	VARCHAR2	(8)	Ingredient Inventory Class
INGREDIENT_ITEM_PLAN_CLASS	VARCHAR2	(8)	Ingredient Planing Class
INGREDIENT_ITEM_SALES_CLASS	VARCHAR2	(8)	Ingredient 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 Primary UOM
PRODUCT_ITEM_UOM2	VARCHAR2	(4)	Product Secondary UOM
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.PMIBV_LOT_SOURCE_PURCH_V;

Dependencies

[top of page]

APPS.PMIBV_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.PMIBV_LOT_SOURCE_PURCH_V is not referenced by any database object