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]

TYPE: APPS.POS_EXCELASN_LOT_TABLE

Object Details

Object Name:	POS_EXCELASN_LOT_TABLE
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
HEADER_ID	PO_TBL_NUMBER
LINE_ID	PO_TBL_NUMBER
LOT_ID	PO_TBL_NUMBER
LOT_NUMBER	PO_TBL_VARCHAR60
LICENSE_PLATE_NUMBER	PO_TBL_VARCHAR60
QUANTITY	PO_TBL_NUMBER
LINE_NUMBER	PO_TBL_NUMBER
VENDOR_ID	PO_TBL_NUMBER
GRADE_CODE	PO_TBL_VARCHAR2000
ORIGINATION_DATE	PO_TBL_DATE
DATE_CODE	PO_TBL_VARCHAR2000
STATUS_ID	PO_TBL_NUMBER
CHANGE_DATE	PO_TBL_DATE
AGE	PO_TBL_NUMBER
RETEST_DATE	PO_TBL_DATE
MATURITY_DATE	PO_TBL_DATE
ITEM_SIZE	PO_TBL_NUMBER
COLOR	PO_TBL_VARCHAR2000
VOLUME	PO_TBL_NUMBER
VOLUME_UOM	PO_TBL_VARCHAR60
PLACE_OF_ORIGIN	PO_TBL_VARCHAR2000
BEST_BY_DATE	PO_TBL_DATE
LENGTH	PO_TBL_NUMBER
LENGTH_UOM	PO_TBL_VARCHAR60
RECYCLED_CONTENT	PO_TBL_NUMBER
THICKNESS	PO_TBL_NUMBER
THICKNESS_UOM	PO_TBL_VARCHAR60
WIDTH	PO_TBL_NUMBER
WIDTH_UOM	PO_TBL_VARCHAR60
CURL_WRINKLE_FOLD	PO_TBL_VARCHAR2000
SUPPLIER_LOT_NUMBER	PO_TBL_VARCHAR2000
TERRITORY_CODE	PO_TBL_VARCHAR60
VENDOR_NAME	PO_TBL_VARCHAR2000
LOT_ATTRIBUTE_CATEGORY	PO_TBL_VARCHAR60
CATTRIBUTE1	PO_TBL_VARCHAR2000
CATTRIBUTE2	PO_TBL_VARCHAR2000
CATTRIBUTE3	PO_TBL_VARCHAR2000
CATTRIBUTE4	PO_TBL_VARCHAR2000
CATTRIBUTE5	PO_TBL_VARCHAR2000
CATTRIBUTE6	PO_TBL_VARCHAR2000
CATTRIBUTE7	PO_TBL_VARCHAR2000
CATTRIBUTE8	PO_TBL_VARCHAR2000
CATTRIBUTE9	PO_TBL_VARCHAR2000
CATTRIBUTE10	PO_TBL_VARCHAR2000
CATTRIBUTE11	PO_TBL_VARCHAR2000
CATTRIBUTE12	PO_TBL_VARCHAR2000
CATTRIBUTE13	PO_TBL_VARCHAR2000
CATTRIBUTE14	PO_TBL_VARCHAR2000
CATTRIBUTE15	PO_TBL_VARCHAR2000
CATTRIBUTE16	PO_TBL_VARCHAR2000
CATTRIBUTE17	PO_TBL_VARCHAR2000
CATTRIBUTE18	PO_TBL_VARCHAR2000
CATTRIBUTE19	PO_TBL_VARCHAR2000
CATTRIBUTE20	PO_TBL_VARCHAR2000
DATTRIBUTE1	PO_TBL_DATE
DATTRIBUTE2	PO_TBL_DATE
DATTRIBUTE3	PO_TBL_DATE
DATTRIBUTE4	PO_TBL_DATE
DATTRIBUTE5	PO_TBL_DATE
DATTRIBUTE6	PO_TBL_DATE
DATTRIBUTE7	PO_TBL_DATE
DATTRIBUTE8	PO_TBL_DATE
DATTRIBUTE9	PO_TBL_DATE
DATTRIBUTE10	PO_TBL_DATE
NATTRIBUTE1	PO_TBL_NUMBER
NATTRIBUTE2	PO_TBL_NUMBER
NATTRIBUTE3	PO_TBL_NUMBER
NATTRIBUTE4	PO_TBL_NUMBER
NATTRIBUTE5	PO_TBL_NUMBER
NATTRIBUTE6	PO_TBL_NUMBER
NATTRIBUTE7	PO_TBL_NUMBER
NATTRIBUTE8	PO_TBL_NUMBER
NATTRIBUTE9	PO_TBL_NUMBER
NATTRIBUTE10	PO_TBL_NUMBER

Dependencies

[top of page]

APPS.POS_EXCELASN_LOT_TABLE references the following:

APPS: PO_TBL_DATE; PO_TBL_NUMBER; PO_TBL_VARCHAR2000; PO_TBL_VARCHAR60

APPS.POS_EXCELASN_LOT_TABLE is referenced by following:

APPS: POS_EXCELASN_GRP - show dependent code; POS_EXCELASN_GRP - show dependent code