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.PO_OTM_SCHEDULE_LINE_TYPE

Object Details

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

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
PO_LINE_ID	NUMBER
LINE_LOCATION_ID	NUMBER
LINE_NUM	NUMBER
SHIPMENT_NUM	NUMBER
QUANTITY	NUMBER
QUANTITY_CANCELED	NUMBER
PRICE_OVERRIDE	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
ITEM	VARCHAR2	(40)
UNIT_VOLUME	NUMBER
UNIT_WEIGHT	NUMBER
ITEM_REVISION	VARCHAR2	(3)
SUPPLIER_ITEM_ID	VARCHAR2	(25)
SUPPLIER_REF_NUM	VARCHAR2	(150)
UOM	VARCHAR2	(150)
CURRENCY_CODE	VARCHAR2	(40)
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)
NEED_BY_DATE	DATE
PROMISED_DATE	DATE
DAYS_EARLY_RECEIPT_ALLOWED	NUMBER
DAYS_LATE_RECEIPT_ALLOWED	NUMBER
DROP_SHIP_FLAG	VARCHAR2	(1)
SHIP_TO_ORGANIZATION_ID	NUMBER
SHIP_TO_ORG_NAME	VARCHAR2	(240)
SHIP_TO_LOCATION_ID	NUMBER
SHIP_TO_LOCATION_CODE	VARCHAR2	(60)
SHIP_TO_LOC_ADDR_LINE_1	VARCHAR2	(240)
SHIP_TO_LOC_ADDR_LINE_2	VARCHAR2	(240)
SHIP_TO_LOC_ADDR_LINE_3	VARCHAR2	(240)
SHIP_TO_LOC_CITY	VARCHAR2	(30)
SHIP_TO_LOC_COUNTRY	VARCHAR2	(60)
SHIP_TO_LOC_ZIP	VARCHAR2	(30)
SHIP_TO_LOC_STATE_PROVINCE	VARCHAR2	(120)
SHIP_TO_CONTACT_NAME	VARCHAR2	(400)
SHIP_TO_CONTACT_EMAIL	VARCHAR2	(2000)
SHIP_TO_CONTACT_PHONE	VARCHAR2	(200)
SHIP_TO_CONTACT_FAX	VARCHAR2	(200)
RECOVERY_ACTION	VARCHAR2	(50)

Methods

Name	Parameters	Result
NEW_INSTANCE		PO_OTM_SCHEDULE_LINE_TYPE

Dependencies

[top of page]

APPS.PO_OTM_SCHEDULE_LINE_TYPE references the following:

SYS: STANDARD - show dependent code

APPS.PO_OTM_SCHEDULE_LINE_TYPE is referenced by following:

APPS: PO_OTM_INTEGRATION_PVT - show dependent code; PO_OTM_SCHEDULE_LINE_TBL; PO_OTM_SCHEDULE_LINE_TYPE