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]

TABLE: GML.OP_PKGD_ITM

Object Details

Object Name:	OP_PKGD_ITM
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_PKGD_ITM
Subobject Name:
Status:	VALID

The packaged name and shipping weights and volumes are maintained in this table. If an item is referenced in order entry by its packaged name, then shipping weights and volumes are computed using the information in this table.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_PKGD_ITM_PK	NORMAL	UNIQUE	APPS_TS_SEED	SALESPKG_ID
OP_PKGD_ITM_U1	NORMAL	UNIQUE	APPS_TS_SEED	PACKAGED_ITEM_NO

Columns

Name	Datatype	Length	Mandatory	Comments
SALESPKG_ID	NUMBER	(10)	Yes	Surrogate id to uniquely identify packaged item in op.
BULK_ITEM_ID	NUMBER	(10)	Yes	Fk to ic_item_mst; item packaged in container. This is the item number that will be used for inventory purposes.
PKG_FORMULA_ID	NUMBER	(10)		Reference to formula which lists components of this packaged item. Fk to fm_form_mst. For future use.
QTY_TOLERANCE_HI	NUMBER		Yes	Upper limit by which quantities for this item can be changed and still be considered within a normal range.
PACKAGED_DESC	VARCHAR2	(70)	Yes	Description of packaged item.
USE_PKG_DESC	NUMBER	(5)	Yes	Indicates if the description contained in the packaged_desc column should display as the item description on the order, otherwise the description from the item master will display. Defaults to 0; value of 1 means that the description from
PKGITEM_UM	VARCHAR2	(4)	Yes	Unit of measure for this item. Defaults on order line if this item is entered on the line. Fk to sy_uoms_mst.
FILL_QTY	NUMBER		Yes	Quantity of the bulk item that fills this packaged item. Quantity will be used to do quantity conversions for inventory and other purposes.
FILL_UM	VARCHAR2	(4)	Yes	Unit of measure for the fill quantity. Fk to sy_uoms_mst. This unit of measure should be convertible to the primary unit of measure of the bulk item (ic_item_mst.item_um1).
PACKAGED_ITEM_NO	VARCHAR2	(32)	Yes	Item number of the packaged item. Can be entered in place of the item number from the item master table.
QTY_TOLERANCE_LO	NUMBER		Yes	Lower limit by which quantities for this item can be changed and still considered within the normal range.
TARE_WT	NUMBER			Weight of the packaging alone (one package).
TARE_UM	VARCHAR2	(4)		Unit of measure of the package. Defaults from system variable for shipping weight uom. Fk to sy_uoms_mst.
UNITS_PER_PALLET	NUMBER		Yes	Number of packages that fit on a pallet.
PALLET_WT	NUMBER			Weight of one pallet.
PALLET_UM	VARCHAR2	(4)		Unit of measure of the weight of the pallet. Defaults from the system variable for shipping weight uom. Fk to sy_uoms_mst.
PER_UNIT_VOL	NUMBER		Yes	Volume measure of one packaged item.
PER_PALLET_VOL	NUMBER		Yes	Volume measure of one pallet.
VOLUME_UM	VARCHAR2	(4)	Yes	Volume unit of measure. Defaults from the system variable for shipping volume uom. Fk to sy_uoms_mst.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module

Query Text

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


SELECT SALESPKG_ID
,      BULK_ITEM_ID
,      PKG_FORMULA_ID
,      QTY_TOLERANCE_HI
,      PACKAGED_DESC
,      USE_PKG_DESC
,      PKGITEM_UM
,      FILL_QTY
,      FILL_UM
,      PACKAGED_ITEM_NO
,      QTY_TOLERANCE_LO
,      TARE_WT
,      TARE_UM
,      UNITS_PER_PALLET
,      PALLET_WT
,      PALLET_UM
,      PER_UNIT_VOL
,      PER_PALLET_VOL
,      VOLUME_UM
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
FROM GML.OP_PKGD_ITM;

Dependencies

[top of page]

GML.OP_PKGD_ITM does not reference any database object

GML.OP_PKGD_ITM is referenced by following:

APPS: OP_PKGD_ITM