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

Object Details

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

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
ACCOUNTING_RULE	VARCHAR2	(240)
AGREEMENT	VARCHAR2	(240)
COMMITMENT	VARCHAR2	(240)
COMMITMENT_APPLIED_AMOUNT	NUMBER
DELIVER_TO_ADDRESS1	VARCHAR2	(240)
DELIVER_TO_ADDRESS2	VARCHAR2	(240)
DELIVER_TO_ADDRESS3	VARCHAR2	(240)
DELIVER_TO_ADDRESS4	VARCHAR2	(240)
DELIVER_TO_CONTACT	VARCHAR2	(360)
DELIVER_TO_LOCATION	VARCHAR2	(240)
DELIVER_TO_ORG	VARCHAR2	(240)
DELIVER_TO_STATE	VARCHAR2	(240)
DELIVER_TO_CITY	VARCHAR2	(240)
DELIVER_TO_ZIP	VARCHAR2	(240)
DELIVER_TO_COUNTRY	VARCHAR2	(240)
DELIVER_TO_COUNTY	VARCHAR2	(240)
DELIVER_TO_PROVINCE	VARCHAR2	(240)
DEMAND_CLASS	VARCHAR2	(240)
DEMAND_BUCKET_TYPE	VARCHAR2	(240)
FOB_POINT	VARCHAR2	(240)
FREIGHT_TERMS	VARCHAR2	(240)
INVENTORY_ITEM	VARCHAR2	(240)
INVOICE_TO_ADDRESS1	VARCHAR2	(240)
INVOICE_TO_ADDRESS2	VARCHAR2	(240)
INVOICE_TO_ADDRESS3	VARCHAR2	(240)
INVOICE_TO_ADDRESS4	VARCHAR2	(240)
INVOICE_TO_CONTACT	VARCHAR2	(360)
INVOICE_TO_LOCATION	VARCHAR2	(240)
INVOICE_TO_ORG	VARCHAR2	(240)
INVOICE_TO_STATE	VARCHAR2	(240)
INVOICE_TO_CITY	VARCHAR2	(240)
INVOICE_TO_ZIP	VARCHAR2	(240)
INVOICE_TO_COUNTRY	VARCHAR2	(240)
INVOICE_TO_COUNTY	VARCHAR2	(240)
INVOICE_TO_PROVINCE	VARCHAR2	(240)
INVOICING_RULE	VARCHAR2	(240)
ITEM_TYPE	VARCHAR2	(240)
LINE_TYPE	VARCHAR2	(240)
OVER_SHIP_REASON	VARCHAR2	(240)
PAYMENT_TERM	VARCHAR2	(240)
PRICE_LIST	VARCHAR2	(240)
PROJECT	VARCHAR2	(240)
RETURN_REASON	VARCHAR2	(240)
RLA_SCHEDULE_TYPE	VARCHAR2	(240)
SALESREP	VARCHAR2	(240)
SHIPMENT_PRIORITY	VARCHAR2	(240)
SHIP_FROM_ADDRESS1	VARCHAR2	(240)
SHIP_FROM_ADDRESS2	VARCHAR2	(240)
SHIP_FROM_ADDRESS3	VARCHAR2	(240)
SHIP_FROM_ADDRESS4	VARCHAR2	(240)
SHIP_FROM_LOCATION	VARCHAR2	(240)
SHIP_FROM_CITY	VARCHAR2	(60)
SHIP_FROM_POSTAL_CODE	VARCHAR2	(60)
SHIP_FROM_COUNTRY	VARCHAR2	(60)
SHIP_FROM_REGION1	VARCHAR2	(240)
SHIP_FROM_REGION2	VARCHAR2	(240)
SHIP_FROM_REGION3	VARCHAR2	(240)
SHIP_FROM_ORG	VARCHAR2	(240)
SHIP_TO_ADDRESS1	VARCHAR2	(240)
SHIP_TO_ADDRESS2	VARCHAR2	(240)
SHIP_TO_ADDRESS3	VARCHAR2	(240)
SHIP_TO_ADDRESS4	VARCHAR2	(240)
SHIP_TO_STATE	VARCHAR2	(240)
SHIP_TO_COUNTRY	VARCHAR2	(240)
SHIP_TO_ZIP	VARCHAR2	(240)
SHIP_TO_COUNTY	VARCHAR2	(240)
SHIP_TO_PROVINCE	VARCHAR2	(240)
SHIP_TO_CITY	VARCHAR2	(240)
SHIP_TO_CONTACT	VARCHAR2	(360)
SHIP_TO_CONTACT_LAST_NAME	VARCHAR2	(240)
SHIP_TO_CONTACT_FIRST_NAME	VARCHAR2	(240)
SHIP_TO_LOCATION	VARCHAR2	(240)
SHIP_TO_ORG	VARCHAR2	(240)
SOURCE_TYPE	VARCHAR2	(240)
INTERMED_SHIP_TO_ADDRESS1	VARCHAR2	(240)
INTERMED_SHIP_TO_ADDRESS2	VARCHAR2	(240)
INTERMED_SHIP_TO_ADDRESS3	VARCHAR2	(240)
INTERMED_SHIP_TO_ADDRESS4	VARCHAR2	(240)
INTERMED_SHIP_TO_CONTACT	VARCHAR2	(240)
INTERMED_SHIP_TO_LOCATION	VARCHAR2	(240)
INTERMED_SHIP_TO_ORG	VARCHAR2	(240)
INTERMED_SHIP_TO_STATE	VARCHAR2	(240)
INTERMED_SHIP_TO_CITY	VARCHAR2	(240)
INTERMED_SHIP_TO_ZIP	VARCHAR2	(240)
INTERMED_SHIP_TO_COUNTRY	VARCHAR2	(240)
INTERMED_SHIP_TO_COUNTY	VARCHAR2	(240)
INTERMED_SHIP_TO_PROVINCE	VARCHAR2	(240)
SOLD_TO_ORG	VARCHAR2	(360)
SOLD_FROM_ORG	VARCHAR2	(240)
TASK	VARCHAR2	(240)
TAX_EXEMPT	VARCHAR2	(240)
TAX_EXEMPT_REASON	VARCHAR2	(240)
TAX_POINT	VARCHAR2	(240)
VEH_CUS_ITEM_CUM_KEY	VARCHAR2	(240)
VISIBLE_DEMAND	VARCHAR2	(240)
CUSTOMER_PAYMENT_TERM	VARCHAR2	(240)
REF_ORDER_NUMBER	NUMBER
REF_LINE_NUMBER	NUMBER
REF_SHIPMENT_NUMBER	NUMBER
REF_OPTION_NUMBER	NUMBER
REF_COMPONENT_NUMBER	NUMBER
REF_INVOICE_NUMBER	VARCHAR2	(20)
REF_INVOICE_LINE_NUMBER	NUMBER
CREDIT_INVOICE_NUMBER	VARCHAR2	(20)
TAX_GROUP	VARCHAR2	(1)
STATUS	VARCHAR2	(240)
FREIGHT_CARRIER	VARCHAR2	(80)
SHIPPING_METHOD	VARCHAR2	(80)
CALCULATE_PRICE_DESCR	VARCHAR2	(240)
SHIP_TO_CUSTOMER_NAME	VARCHAR2	(360)
INVOICE_TO_CUSTOMER_NAME	VARCHAR2	(360)
SHIP_TO_CUSTOMER_NUMBER	VARCHAR2	(50)
INVOICE_TO_CUSTOMER_NUMBER	VARCHAR2	(50)
SHIP_TO_CUSTOMER_ID	NUMBER
INVOICE_TO_CUSTOMER_ID	NUMBER
DELIVER_TO_CUSTOMER_ID	NUMBER
DELIVER_TO_CUSTOMER_NUMBER	VARCHAR2	(50)
DELIVER_TO_CUSTOMER_NAME	VARCHAR2	(360)
ORIGINAL_ORDERED_ITEM	VARCHAR2	(2000)
ORIGINAL_INVENTORY_ITEM	VARCHAR2	(2000)
ORIGINAL_ITEM_IDENTIFIER_TYPE	VARCHAR2	(240)
DELIVER_TO_CUSTOMER_NUMBER_OI	VARCHAR2	(30)
DELIVER_TO_CUSTOMER_NAME_OI	VARCHAR2	(360)
SHIP_TO_CUSTOMER_NUMBER_OI	VARCHAR2	(30)
SHIP_TO_CUSTOMER_NAME_OI	VARCHAR2	(360)
INVOICE_TO_CUSTOMER_NUMBER_OI	VARCHAR2	(30)
INVOICE_TO_CUSTOMER_NAME_OI	VARCHAR2	(360)
ITEM_RELATIONSHIP_TYPE_DSP	VARCHAR2	(100)
TRANSACTION_PHASE	VARCHAR2	(240)
END_CUSTOMER_NAME	VARCHAR2	(360)
END_CUSTOMER_NUMBER	VARCHAR2	(50)
END_CUSTOMER_CONTACT	VARCHAR2	(360)
END_CUST_CONTACT_LAST_NAME	VARCHAR2	(240)
END_CUST_CONTACT_FIRST_NAME	VARCHAR2	(240)
END_CUSTOMER_SITE_ADDRESS1	VARCHAR2	(240)
END_CUSTOMER_SITE_ADDRESS2	VARCHAR2	(240)
END_CUSTOMER_SITE_ADDRESS3	VARCHAR2	(240)
END_CUSTOMER_SITE_ADDRESS4	VARCHAR2	(240)
END_CUSTOMER_SITE_LOCATION	VARCHAR2	(240)
END_CUSTOMER_SITE_STATE	VARCHAR2	(240)
END_CUSTOMER_SITE_COUNTRY	VARCHAR2	(240)
END_CUSTOMER_SITE_ZIP	VARCHAR2	(240)
END_CUSTOMER_SITE_COUNTY	VARCHAR2	(240)
END_CUSTOMER_SITE_PROVINCE	VARCHAR2	(240)
END_CUSTOMER_SITE_CITY	VARCHAR2	(240)
END_CUSTOMER_SITE_POSTAL_CODE	VARCHAR2	(240)
BLANKET_AGREEMENT_NAME	VARCHAR2	(360)
IB_OWNER_DSP	VARCHAR2	(60)
IB_CURRENT_LOCATION_DSP	VARCHAR2	(60)
IB_INSTALLED_AT_LOCATION_DSP	VARCHAR2	(60)
SERVICE_PERIOD_DSP	VARCHAR2	(240)
SERVICE_REFERENCE_TYPE	VARCHAR2	(240)

Dependencies

[top of page]

APPS.OE_ORDER_PUB_LINE_VAL_REC_TYP references the following:

SYS: STANDARD - show dependent code

APPS.OE_ORDER_PUB_LINE_VAL_REC_TYP is referenced by following:

APPS: OE_INBOUND_INT - show dependent code; OE_INBOUND_INT - show dependent code; OE_ORDER_PUB_LINE_VAL_TBL_TYP; XX_BPEL_CALLPROCESSORDEREBS11I - show dependent code; XX_BPEL_CALLPROCESSORDEREBS11I - show dependent code