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

VIEW: GML.OP_PKGD_ITM#

Object Details
Object Name: OP_PKGD_ITM#
Object Type: VIEW
Owner: GML
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SALESPKG_ID NUMBER (10) Yes
BULK_ITEM_ID NUMBER (10) Yes
PKG_FORMULA_ID NUMBER (10)
QTY_TOLERANCE_HI NUMBER
Yes
PACKAGED_DESC VARCHAR2 (70) Yes
USE_PKG_DESC NUMBER (5) Yes
PKGITEM_UM VARCHAR2 (4) Yes
FILL_QTY NUMBER
Yes
FILL_UM VARCHAR2 (4) Yes
PACKAGED_ITEM_NO VARCHAR2 (32) Yes
QTY_TOLERANCE_LO NUMBER
Yes
TARE_WT NUMBER

TARE_UM VARCHAR2 (4)
UNITS_PER_PALLET NUMBER
Yes
PALLET_WT NUMBER

PALLET_UM VARCHAR2 (4)
PER_UNIT_VOL NUMBER
Yes
PER_PALLET_VOL NUMBER
Yes
VOLUME_UM VARCHAR2 (4) Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
TRANS_CNT NUMBER (10)
DELETE_MARK NUMBER (5) Yes
TEXT_CODE NUMBER (10)
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# references the following:

SchemaGML
TableOP_PKGD_ITM
GML.OP_PKGD_ITM# is referenced by following:

SchemaAPPS
SynonymOP_PKGD_ITM