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_ORDER_TYPE

Object Details

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

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
OTM_DOMAIN	VARCHAR2	(50)
OTM_USER	VARCHAR2	(50)
OTM_PASSWORD	VARCHAR2	(50)
SERVER_TIMEZONE_CODE	VARCHAR2	(50)
ACTION	VARCHAR2	(50)
PO_HEADER_ID	NUMBER
PO_RELEASE_ID	NUMBER
PO_NUMBER	VARCHAR2	(20)
RELEASE_NUMBER	NUMBER
FREIGHT_TERMS_LOOKUP_CODE	VARCHAR2	(25)
SHIPPING_CONTROL	VARCHAR2	(30)
SUPPLIER_ID	NUMBER
SUPPLIER_SITE_ID	NUMBER
SUPPLIER_NAME	VARCHAR2	(240)
SUPPLIER_ADDR_LINE_1	VARCHAR2	(240)
SUPPLIER_ADDR_LINE_2	VARCHAR2	(240)
SUPPLIER_ADDR_LINE_3	VARCHAR2	(240)
SUPPLIER_ADDR_CITY	VARCHAR2	(25)
SUPPLIER_ADDR_COUNTRY	VARCHAR2	(25)
SUPPLIER_SITE_CODE	VARCHAR2	(15)
SUPPLIER_ADDR_ZIP	VARCHAR2	(20)
SUPPLIER_ADDR_STATE_PROVINCE	VARCHAR2	(150)
SUPPLIER_CONTACT_PREFIX	VARCHAR2	(5)
SUPPLIER_CONTACT_FIRST_NAME	VARCHAR2	(15)
SUPPLIER_CONTACT_MIDDLE_NAME	VARCHAR2	(15)
SUPPLIER_CONTACT_LAST_NAME	VARCHAR2	(20)
SUPPLIER_CONTACT_PHONE	VARCHAR2	(15)
SUPPLIER_CONTACT_EMAIL	VARCHAR2	(2000)
SUPPLIER_CONTACT_FAX	VARCHAR2	(60)
ORG_ID	NUMBER
ORG_NAME	VARCHAR2	(240)
ORG_LOCATION_ID	NUMBER
ORG_LOCATION_CODE	VARCHAR2	(60)
ORG_LOC_ADDR_LINE_1	VARCHAR2	(240)
ORG_LOC_ADDR_LINE_2	VARCHAR2	(240)
ORG_LOC_ADDR_LINE_3	VARCHAR2	(240)
ORG_LOC_ADDR_CITY	VARCHAR2	(30)
ORG_LOC_ADDR_COUNTRY	VARCHAR2	(60)
ORG_LOC_ADDR_ZIP	VARCHAR2	(30)
ORG_LOC_ADDR_STATE_PROVINCE	VARCHAR2	(120)
BUYER_FIRST_NAME	VARCHAR2	(150)
BUYER_LAST_NAME	VARCHAR2	(150)
BUYER_PHONE	VARCHAR2	(60)
BUYER_EMAIL	VARCHAR2	(240)
BUYER_FAX	VARCHAR2	(60)
BILL_TO_LOCATION_ID	NUMBER
BILL_TO_LOCATION_CODE	VARCHAR2	(60)
BILL_TO_ADDR_LINE_1	VARCHAR2	(240)
BILL_TO_ADDR_LINE_2	VARCHAR2	(240)
BILL_TO_ADDR_LINE_3	VARCHAR2	(240)
BILL_TO_ADDR_CITY	VARCHAR2	(30)
BILL_TO_ADDR_COUNTRY	VARCHAR2	(60)
BILL_TO_ADDR_ZIP	VARCHAR2	(30)
BILL_TO_ADDR_STATE_PROVINCE	VARCHAR2	(120)
TERMS	VARCHAR2	(50)
SCHEDULE_LINES	PO_OTM_SCHEDULE_LINE_TBL
RECOVERY_ACTION	VARCHAR2	(50)

Methods

Name	Parameters	Result
NEW_INSTANCE		PO_OTM_ORDER_TYPE

Dependencies

[top of page]

APPS.PO_OTM_ORDER_TYPE references the following:

APPS: PO_OTM_SCHEDULE_LINE_TBL
SYS: STANDARD - show dependent code

APPS.PO_OTM_ORDER_TYPE is referenced by following:

APPS: PO_OTM_INTEGRATION_PVT - show dependent code; PO_OTM_INTEGRATION_PVT - show dependent code; PO_OTM_ORDER_TYPE