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]

VIEW: APPS.OE_PRN_ORDER_LINES_V

Object Details

Object Name:	OE_PRN_ORDER_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_PRN_ORDER_LINES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
LINE_ID	NUMBER		Yes
ORG_ID	NUMBER
HEADER_ID	NUMBER		Yes
LINE_TYPE_ID	NUMBER		Yes
LINE	VARCHAR2	(4000)
LINE_NUMBER	NUMBER		Yes
ITEM_NUMBER	VARCHAR2	(2000)
ITEM_DESCRIPTION	VARCHAR2	(240)
REQUEST_DATE	DATE
PROMISE_DATE	DATE
SCHEDULE_ARRIVAL_DATE	DATE
SCHEDULE_SHIP_DATE	DATE
ORDER_QUANTITY_UOM	VARCHAR2	(25)
ORDERED_QUANTITY	NUMBER
TAX_EXEMPT_NUMBER	VARCHAR2	(80)
CUST_PO_NUMBER	VARCHAR2	(50)
SOLD_TO_ORG_ID	NUMBER
SHIP_FROM_ORG_ID	NUMBER
SHIP_TO_ORG_ID	NUMBER
DELIVER_TO_ORG_ID	NUMBER
INTMED_SHIP_TO_ORG_ID	NUMBER
INVOICE_TO_ORG_ID	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
DELIVER_TO_CONTACT_ID	NUMBER
INTMED_SHIP_TO_CONTACT_ID	NUMBER
INVOICE_TO_CONTACT_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER		Yes
TAX_CODE	VARCHAR2	(50)
TAX_RATE	NUMBER
UNIT_LIST_PRICE	VARCHAR2	(4000)
UNIT_SELLING_PRICE	VARCHAR2	(4000)
DISCOUNT	VARCHAR2	(4000)
TAX_VALUE	NUMBER
ATO_LINE_ID	NUMBER
CONFIGURATION_ID	NUMBER
TOP_MODEL_LINE_ID	NUMBER
LINK_TO_LINE_ID	NUMBER
COMPONENT_SEQUENCE_ID	NUMBER
COMPONENT_CODE	VARCHAR2	(1000)
ITEM_TYPE_CODE	VARCHAR2	(30)
SHIPMENT_NUMBER	NUMBER		Yes
OPTION_NUMBER	NUMBER
COMPONENT_NUMBER	NUMBER
OPTION_FLAG	VARCHAR2	(1)
SALESREP_ID	NUMBER	(15)
ORDERED_ITEM_ID	NUMBER
ITEM_IDENTIFIER_TYPE	VARCHAR2	(30)
CONFIG_HEADER_ID	NUMBER
CONFIG_REV_NBR	NUMBER
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)
PACKING_INSTRUCTIONS	VARCHAR2	(2000)
INVOICED_QUANTITY	NUMBER
SERVICE_TXN_REASON_CODE	VARCHAR2	(30)
SERVICE_TXN_COMMENTS	VARCHAR2	(2000)
SERVICE_DURATION	NUMBER
SERVICE_PERIOD	VARCHAR2	(3)
SERVICE_START_DATE	DATE
SERVICE_END_DATE	DATE
SERVICE_COTERMINATE_FLAG	VARCHAR2	(1)
SERVICE_NUMBER	NUMBER
SERVICE_REFERENCE_TYPE_CODE	VARCHAR2	(30)
SERVICE_REFERENCE_LINE_ID	NUMBER
SERVICE_REFERENCE_SYSTEM_ID	NUMBER
AGREEMENT_NAME	VARCHAR2	(240)
AGREEMENT_VERSION	VARCHAR2	(50)
BLANKET_NUMBER	NUMBER
BLANKET_LINE_NUMBER	NUMBER
BLANKET_VERSION_NUMBER	NUMBER
INVOICING_RULE_NAME	VARCHAR2	(30)
PAYMENT_TERMS	VARCHAR2	(15)
LINE_TOTAL	VARCHAR2	(4000)
LINE_PRICE	VARCHAR2	(4000)
LINE_CHARGES	VARCHAR2	(4000)
LINE_TAXES	VARCHAR2	(4000)
END_CUSTOMER_ID	NUMBER
END_CUSTOMER_CONTACT_ID	NUMBER
END_CUSTOMER_SITE_USE_ID	NUMBER
IB_OWNER	VARCHAR2	(60)
IB_INSTALLED_AT_LOCATION	VARCHAR2	(60)
IB_CURRENT_LOCATION	VARCHAR2	(60)
CHARGE_PERIODICITY_CODE	VARCHAR2	(3)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LINE_ID
,      ORG_ID
,      HEADER_ID
,      LINE_TYPE_ID
,      LINE
,      LINE_NUMBER
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      REQUEST_DATE
,      PROMISE_DATE
,      SCHEDULE_ARRIVAL_DATE
,      SCHEDULE_SHIP_DATE
,      ORDER_QUANTITY_UOM
,      ORDERED_QUANTITY
,      TAX_EXEMPT_NUMBER
,      CUST_PO_NUMBER
,      SOLD_TO_ORG_ID
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      INTMED_SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      SHIP_TO_CONTACT_ID
,      DELIVER_TO_CONTACT_ID
,      INTMED_SHIP_TO_CONTACT_ID
,      INVOICE_TO_CONTACT_ID
,      INVENTORY_ITEM_ID
,      TAX_CODE
,      TAX_RATE
,      UNIT_LIST_PRICE
,      UNIT_SELLING_PRICE
,      DISCOUNT
,      TAX_VALUE
,      ATO_LINE_ID
,      CONFIGURATION_ID
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_CODE
,      ITEM_TYPE_CODE
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      COMPONENT_NUMBER
,      OPTION_FLAG
,      SALESREP_ID
,      ORDERED_ITEM_ID
,      ITEM_IDENTIFIER_TYPE
,      CONFIG_HEADER_ID
,      CONFIG_REV_NBR
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      INVOICED_QUANTITY
,      SERVICE_TXN_REASON_CODE
,      SERVICE_TXN_COMMENTS
,      SERVICE_DURATION
,      SERVICE_PERIOD
,      SERVICE_START_DATE
,      SERVICE_END_DATE
,      SERVICE_COTERMINATE_FLAG
,      SERVICE_NUMBER
,      SERVICE_REFERENCE_TYPE_CODE
,      SERVICE_REFERENCE_LINE_ID
,      SERVICE_REFERENCE_SYSTEM_ID
,      AGREEMENT_NAME
,      AGREEMENT_VERSION
,      BLANKET_NUMBER
,      BLANKET_LINE_NUMBER
,      BLANKET_VERSION_NUMBER
,      INVOICING_RULE_NAME
,      PAYMENT_TERMS
,      LINE_TOTAL
,      LINE_PRICE
,      LINE_CHARGES
,      LINE_TAXES
,      END_CUSTOMER_ID
,      END_CUSTOMER_CONTACT_ID
,      END_CUSTOMER_SITE_USE_ID
,      IB_OWNER
,      IB_INSTALLED_AT_LOCATION
,      IB_CURRENT_LOCATION
,      CHARGE_PERIODICITY_CODE
FROM APPS.OE_PRN_ORDER_LINES_V;

Dependencies

[top of page]

APPS.OE_PRN_ORDER_LINES_V references the following:

APPS: FND_CURRENCY - show dependent code; MTL_CROSS_REFERENCES; MTL_CUSTOMER_ITEMS; MTL_SYSTEM_ITEMS_KFV; MTL_SYSTEM_ITEMS_TL; MTL_UNITS_OF_MEASURE_TL; OE_AGREEMENTS_TL; OE_BLANKET_HEADERS_ALL; OE_OE_TOTALS_SUMMARY - show dependent code; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_ORDER_MISC_PUB - show dependent code; OE_SYS_PARAMETERS - show dependent code; OE_TOTALS_GRP - show dependent code; OE_TRANSACTION_TYPES_ALL; RA_RULES; RA_TERMS_TL

APPS.OE_PRN_ORDER_LINES_V is not referenced by any database object