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_DEST_SHIP_V

Object Details

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

View Type

A Business Intelligence System view

This view provides the relationship between a lot and the shipments that its destination lots have been involved in.

[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	(240)	Organization Code
ORDER_NO	VARCHAR2	(40)	Sales Order Number
CUSTOMER_NO	VARCHAR2	(4000)	Customer Number
CUSTOMER_NAME	VARCHAR2	(360)	Customer Name
INGREDIENT_ITEM_NO	VARCHAR2	(32)	Ingredient Item 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_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_ITEM_INV_CLASS	VARCHAR2	(8)	Product Inventory Class
PRODUCT_ITEM_PLAN_CLASS	VARCHAR2	(8)	Product Planing Class
PRODUCT_ITEM_SALES_CLASS	VARCHAR2	(8)	Product Sales Class
PRODUCT_LOT_NO	VARCHAR2	(32)	Product Lot Number
PRODUCT_SUBLOT_NO	VARCHAR2	(32)	Product Sublot Number
TRANSACTION_COMPLETE_INDICATOR	NUMBER	(5)

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
,      ORDER_NO
,      CUSTOMER_NO
,      CUSTOMER_NAME
,      INGREDIENT_ITEM_NO
,      INGREDIENT_ITEM_DESCRIPTION
,      INGREDIENT_ITEM_UOM
,      INGREDIENT_ITEM_UOM2
,      INGREDIENT_LOT_NO
,      INGREDIENT_SUBLOT_NO
,      PRODUCT_ITEM_NO
,      PRODUCT_ITEM_DESCRIPTION
,      PRODUCT_ITEM_UOM
,      PRODUCT_ITEM_UOM2
,      PRODUCT_ITEM_INV_CLASS
,      PRODUCT_ITEM_PLAN_CLASS
,      PRODUCT_ITEM_SALES_CLASS
,      PRODUCT_LOT_NO
,      PRODUCT_SUBLOT_NO
,      TRANSACTION_COMPLETE_INDICATOR
FROM APPS.PMIBV_LOT_DEST_SHIP_V;

Dependencies

[top of page]

APPS.PMIBV_LOT_DEST_SHIP_V references the following:

APPS: FND_PROFILE - show dependent code; HR_ALL_ORGANIZATION_UNITS_VL; IC_ITEM_MST; IC_LOTS_MST; IC_TRAN_PND; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OP_CUST_MST; OP_ORDR_HDR; PMI_HZ_PARTY_V; PMI_LOT_GENEALOGY

APPS.PMIBV_LOT_DEST_SHIP_V is not referenced by any database object