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_SHARED_SHIP_V

Object Details

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

View Type

A Business Intelligence System view

Provides the relationship between a lot and the shipments that its destination lots have been involved in. A Shared Lot here refers to the lots that shared the same source lots.

[View Source]

Columns

Name	Datatype	Length	Comments
START_ITEM_ID	NUMBER		Start Item ID to find Shared Lots
START_LOT_ID	NUMBER		Start Lot ID to find Shared Lots
SHARED_ITEM_ID	NUMBER		Shared Item ID which uses same Item,lots as start Item, Lots
SHARED_LOT_ID	NUMBER		Shared Lot ID which uses same Item,lots as start Item, Lots
START_ITEM_NO	VARCHAR2	(32)	Start Item Number to find Shared Lots
START_ITEM_DESCRIPTION	VARCHAR2	(70)	Start Item Description to find Shared Lots
START_LOT_NO	VARCHAR2	(32)	Start Lot Number to find Shared Lots
START_SUBLOT_NO	VARCHAR2	(32)	Start Sublot Number to find Shared Lots
SHARED_ITEM_NO	VARCHAR2	(32)	Shared Item Number which uses same Item,lots as start Item, Lots
SHARED_ITEM_DESCRIPTION	VARCHAR2	(70)	Shared Item Description which uses same Item,lots as start Item, Lots
SHARED_ITEM_UOM	VARCHAR2	(4)	Shared Item Primary UOM
SHARED_ITEM_UOM2	VARCHAR2	(4)	Shared Item Secondary UOM
SHARED_INVENTORY_CLASS	VARCHAR2	(8)	Shared Item Inventory Class
SHARED_PLANNING_CLASS	VARCHAR2	(8)	Shared Item Planning Class
SHARED_SALES_CLASS	VARCHAR2	(8)	Shared Item Sales Class
SHARED_LOT_NO	VARCHAR2	(32)	Shared Lot Number
SHARED_SUBLOT_NO	VARCHAR2	(32)	Shared sublot Number
ORGANIZATION_CODE	VARCHAR2	(240)	Organization Code for OM it is Operating Unit name
WAREHOUSE	VARCHAR2	(4)	Warehouse
LOCATION	VARCHAR2	(16)	Location
ORDER_NO	VARCHAR2	(40)	Sales Order Number
CUSTOMER_NO	VARCHAR2	(4000)	Customer Number
CUSTOMER_NAME	VARCHAR2	(360)	Customer Name
SHIP_DATE	DATE		Ship date
SHIPPED_QUANTITY	NUMBER		Shipped Quantity in Primary UOM
SHIPPED_QUANTITY_UOM2	NUMBER		Shipped Quantity in Secondary UOM
TRANSACTION_COMPLETE_INDICATOR	NUMBER	(5)	Completed Indicator

Query Text

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


SELECT START_ITEM_ID
,      START_LOT_ID
,      SHARED_ITEM_ID
,      SHARED_LOT_ID
,      START_ITEM_NO
,      START_ITEM_DESCRIPTION
,      START_LOT_NO
,      START_SUBLOT_NO
,      SHARED_ITEM_NO
,      SHARED_ITEM_DESCRIPTION
,      SHARED_ITEM_UOM
,      SHARED_ITEM_UOM2
,      SHARED_INVENTORY_CLASS
,      SHARED_PLANNING_CLASS
,      SHARED_SALES_CLASS
,      SHARED_LOT_NO
,      SHARED_SUBLOT_NO
,      ORGANIZATION_CODE
,      WAREHOUSE
,      LOCATION
,      ORDER_NO
,      CUSTOMER_NO
,      CUSTOMER_NAME
,      SHIP_DATE
,      SHIPPED_QUANTITY
,      SHIPPED_QUANTITY_UOM2
,      TRANSACTION_COMPLETE_INDICATOR
FROM APPS.PMIBV_LOT_SHARED_SHIP_V;

Dependencies

[top of page]

APPS.PMIBV_LOT_SHARED_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_SHARED_V

APPS.PMIBV_LOT_SHARED_SHIP_V is not referenced by any database object