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_BLKTPRT_LINES_V

Object Details

Object Name:	OE_BLKTPRT_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_BLKTPRT_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
HEADER_ID	NUMBER		Yes
LINE_NUMBER	NUMBER		Yes
LINE_ID	NUMBER		Yes
CUSTOMER_PO_NUMBER	VARCHAR2	(50)
SHIP_TO_ORG_ID	NUMBER
DELIVER_TO_ORG_ID	NUMBER
INVOICE_TO_ORG_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
SOLD_TO_ORG_ID	NUMBER
ORDERED_ITEM	VARCHAR2	(2000)
ORDERED_ITEM_ID	NUMBER
ITEM_IDENTIFIER_TYPE	VARCHAR2	(30)
ITEM_IDENTIFIER	VARCHAR2	(80)
ITEM	VARCHAR2	(4000)
ITEM_DESCRIPTION	VARCHAR2	(4000)
UOM	VARCHAR2	(3)
ACTIVATION_DATE	DATE
EXPIRATION_DATE	DATE
FREIGHT_TERMS	VARCHAR2	(80)
SHIPPING_METHOD	VARCHAR2	(80)
PAYMENT_TERM	VARCHAR2	(15)
INVOICING_RULE	VARCHAR2	(30)
BLANKET_LINE_MIN_AMOUNT	VARCHAR2	(4000)
BLANKET_LINE_MAX_AMOUNT	VARCHAR2	(4000)
BLANKET_MIN_QUANTITY	NUMBER
BLANKET_MAX_QUANTITY	NUMBER
PRICE_LIST_ID	NUMBER
QP_LIST_LINE_ID	NUMBER
MODIFIER_LIST_LINE_ID	NUMBER

Query Text

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


SELECT HEADER_ID
,      LINE_NUMBER
,      LINE_ID
,      CUSTOMER_PO_NUMBER
,      SHIP_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      INVENTORY_ITEM_ID
,      SOLD_TO_ORG_ID
,      ORDERED_ITEM
,      ORDERED_ITEM_ID
,      ITEM_IDENTIFIER_TYPE
,      ITEM_IDENTIFIER
,      ITEM
,      ITEM_DESCRIPTION
,      UOM
,      ACTIVATION_DATE
,      EXPIRATION_DATE
,      FREIGHT_TERMS
,      SHIPPING_METHOD
,      PAYMENT_TERM
,      INVOICING_RULE
,      BLANKET_LINE_MIN_AMOUNT
,      BLANKET_LINE_MAX_AMOUNT
,      BLANKET_MIN_QUANTITY
,      BLANKET_MAX_QUANTITY
,      PRICE_LIST_ID
,      QP_LIST_LINE_ID
,      MODIFIER_LIST_LINE_ID
FROM APPS.OE_BLKTPRT_LINES_V;

Dependencies

[top of page]

APPS.OE_BLKTPRT_LINES_V references the following:

APPS: FND_CURRENCY - show dependent code; FND_LOOKUP_VALUES; OE_BLANKET_HEADERS_ALL; OE_BLANKET_LINES_ALL; OE_BLANKET_LINES_EXT; OE_CONTRACTS_UTIL - show dependent code; OE_LOOKUPS; RA_RULES; RA_TERMS_TL

APPS.OE_BLKTPRT_LINES_V is not referenced by any database object