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

Object Details

Object Name:	XNB_ORDER_LINES_V
Object Type:	VIEW
Owner:	APPS
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	Comments
ATTRIBUTE1	VARCHAR2	(240)		Attribute1
ATTRIBUTE2	VARCHAR2	(240)		Attribute2
ATTRIBUTE3	VARCHAR2	(240)		Attribute3
ATTRIBUTE4	VARCHAR2	(240)		Attribute4
ATTRIBUTE5	VARCHAR2	(240)		Attribute5
ATTRIBUTE6	VARCHAR2	(240)		Attribute6
ATTRIBUTE7	VARCHAR2	(240)		Attribute7
ATTRIBUTE8	VARCHAR2	(240)		Attribute8
ATTRIBUTE9	VARCHAR2	(240)		Attribute9
ATTRIBUTE10	VARCHAR2	(240)		Attribute10
ATTRIBUTE11	VARCHAR2	(240)		Attribute11
ATTRIBUTE12	VARCHAR2	(240)		Attribute12
ATTRIBUTE13	VARCHAR2	(240)		Attribute13
ATTRIBUTE14	VARCHAR2	(240)		Attribute14
ATTRIBUTE15	VARCHAR2	(240)		Attribute15
LINE_ID	NUMBER		Yes	Line Id
TAX_CODE	VARCHAR2	(50)		Tax Code
TAX_RATE	NUMBER			Tax Rate
TAX_DATE	DATE			Tax date
TAX_VALUE	NUMBER			Tax Value
TOP_MODEL_LINE_ID	NUMBER			Top Model Line Id
LINK_TO_LINE_ID	NUMBER			Link To Line Id
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item Id
ORG_ID	NUMBER			Organization Id
PRICING_DATE	DATE			Pricing Date
UNIT_SELLING_PRICE	NUMBER			Unit Selling Price
UNIT_LIST_PRICE	NUMBER			Unit List Price
ORDERED_QUANTITY	NUMBER			Ordered quantity
ORDERED_QUANTITY_UOM	VARCHAR2	(3)		Ordered Quantity Unit of Measure
PRICING_QUANTITY	NUMBER			Pricing Quantity
PRICING_QUANTITY_UOM	VARCHAR2	(3)		Pricing Quantity Unit of Measure
SHIP_FROM_ORG_ID	NUMBER			Ship From Organization Id
SHIP_TO_ORG_ID	NUMBER			Ship to Organization Id
INVOICE_TO_ORG_ID	NUMBER			Invoice to Org Id
LINE_TYPE_ID	NUMBER		Yes	Line Type Id
SOLD_TO_ORG_ID	NUMBER			Sold to Organization Id
HEADER_ID	NUMBER		Yes	Header Id
PRICE_LIST_ID	NUMBER			Price List Id
CHARGE_PERIODICITY_CODE	VARCHAR2	(3)		Charge Periodicity Code
SHIP_TO_CONTACT_ID	NUMBER			Ship To Contact Id
PAYMENT_TERM_ID	NUMBER	(15)		Payment term Id
PAYMENT_TERM_NAME	VARCHAR2	(15)		Payment term name
PAYMENT_DESCRIPTION	VARCHAR2	(240)		Payment Description
CHARGE_PERIODICITY_DESCRIPTION	VARCHAR2	(25)		Charge periodicity description
ITEM_NAME	VARCHAR2	(40)		Item Name
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description
ACTION	VARCHAR2	(30)		Action
PRICE_LIST_DESCRIPTION	VARCHAR2	(2000)		Price List Description
CURRENCY_CODE	VARCHAR2	(30)		Currency Code
PRIMARY_BILL_TO_FLAG	VARCHAR2	(1)		Primary Bill To Flag
BILL_TO_OWNER_FLAG	VARCHAR2	(1)		Bill To Owner Flag
BILL_TO_ADDRESS	VARCHAR2	(500)		Bill To address
BILL_TO_COUNTRY	VARCHAR2	(60)		Bill to country
BILL_TO_STATE	VARCHAR2	(60)		Bill to State
BILL_TO_COUNTY	VARCHAR2	(60)		Bill to County
BILL_TO_CITY	VARCHAR2	(60)		Bill to City
BILL_TO_POSTAL_CODE	VARCHAR2	(60)		Bill to Postal Code
BILL_TO_ACCOUNT_NUMBER	VARCHAR2	(30)		Bill to Account Number
BILL_TO_ACCOUNT_NAME	VARCHAR2	(240)		Bill to Account Name
BILL_TO_PARTY_NUMBER	VARCHAR2	(30)		Bill to Party Number
BILL_TO_PARTY_NAME	VARCHAR2	(240)		Bill to party Name
PARTY_ATTRIBUTE1	VARCHAR2	(150)		Party Attribute 1
PARTY_ATTRIBUTE2	VARCHAR2	(150)		Party Attribute 2
PARTY_ATTRIBUTE3	VARCHAR2	(150)		Party Attribute 3
PARTY_ATTRIBUTE4	VARCHAR2	(150)		Party Attribute 4
PARTY_ATTRIBUTE5	VARCHAR2	(150)		Party Attribute 5
PARTY_ATTRIBUTE6	VARCHAR2	(150)		Party Attribute 6
PARTY_ATTRIBUTE7	VARCHAR2	(150)		Party Attribute 7
PARTY_ATTRIBUTE8	VARCHAR2	(150)		Party Attribute 8
PARTY_ATTRIBUTE9	VARCHAR2	(150)		Party Attribute 9
PARTY_ATTRIBUTE10	VARCHAR2	(150)		Party Attribute 10
PARTY_ATTRIBUTE11	VARCHAR2	(150)		Party Attribute 11
PARTY_ATTRIBUTE12	VARCHAR2	(150)		Party Attribute 12
PARTY_ATTRIBUTE13	VARCHAR2	(150)		Party Attribute 13
PARTY_ATTRIBUTE14	VARCHAR2	(150)		Party Attribute 14
PARTY_ATTRIBUTE15	VARCHAR2	(150)		Party Attribute 15
ACCT_ATTRIBUTE1	VARCHAR2	(150)		Account Attribute 1
ACCT_ATTRIBUTE2	VARCHAR2	(150)		Account Attribute 2
ACCT_ATTRIBUTE3	VARCHAR2	(150)		Account Attribute 3
ACCT_ATTRIBUTE4	VARCHAR2	(150)		Account Attribute 4
ACCT_ATTRIBUTE5	VARCHAR2	(150)		Account Attribute 5
ACCT_ATTRIBUTE6	VARCHAR2	(150)		Account Attribute 6
ACCT_ATTRIBUTE7	VARCHAR2	(150)		Account Attribute 7
ACCT_ATTRIBUTE8	VARCHAR2	(150)		Account Attribute 8
ACCT_ATTRIBUTE9	VARCHAR2	(150)		Account Attribute 9
ACCT_ATTRIBUTE10	VARCHAR2	(150)		Account Attribute 10
ACCT_ATTRIBUTE11	VARCHAR2	(150)		Account Attribute 11
ACCT_ATTRIBUTE12	VARCHAR2	(150)		Account Attribute 12
ACCT_ATTRIBUTE13	VARCHAR2	(150)		Account Attribute 13
ACCT_ATTRIBUTE14	VARCHAR2	(150)		Account Attribute 14
ACCT_ATTRIBUTE15	VARCHAR2	(150)		Account Attribute 15
INSTANCE_ID	NUMBER			Instance Id
INSTANCE_DESCRIPTION	VARCHAR2	(240)		Instance Description
INSTALL_DATE	DATE			Install Date
ACTIVE_START_DATE	DATE			Active Start Date
ACTIVE_END_DATE	DATE			Active End Date
INSTALL_BASE_QUANTITY	NUMBER			Install Base Quantity
INSTALL_BASE_UOM	VARCHAR2	(3)		Install Base Unit of Measure
INSTALL_LOCATION_ID	NUMBER			Install Location Id
LAST_OE_ORDER_LINE_ID	NUMBER			Last OE Order Line Id

Query Text

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


SELECT ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LINE_ID
,      TAX_CODE
,      TAX_RATE
,      TAX_DATE
,      TAX_VALUE
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      INVENTORY_ITEM_ID
,      ORG_ID
,      PRICING_DATE
,      UNIT_SELLING_PRICE
,      UNIT_LIST_PRICE
,      ORDERED_QUANTITY
,      ORDERED_QUANTITY_UOM
,      PRICING_QUANTITY
,      PRICING_QUANTITY_UOM
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      LINE_TYPE_ID
,      SOLD_TO_ORG_ID
,      HEADER_ID
,      PRICE_LIST_ID
,      CHARGE_PERIODICITY_CODE
,      SHIP_TO_CONTACT_ID
,      PAYMENT_TERM_ID
,      PAYMENT_TERM_NAME
,      PAYMENT_DESCRIPTION
,      CHARGE_PERIODICITY_DESCRIPTION
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      ACTION
,      PRICE_LIST_DESCRIPTION
,      CURRENCY_CODE
,      PRIMARY_BILL_TO_FLAG
,      BILL_TO_OWNER_FLAG
,      BILL_TO_ADDRESS
,      BILL_TO_COUNTRY
,      BILL_TO_STATE
,      BILL_TO_COUNTY
,      BILL_TO_CITY
,      BILL_TO_POSTAL_CODE
,      BILL_TO_ACCOUNT_NUMBER
,      BILL_TO_ACCOUNT_NAME
,      BILL_TO_PARTY_NUMBER
,      BILL_TO_PARTY_NAME
,      PARTY_ATTRIBUTE1
,      PARTY_ATTRIBUTE2
,      PARTY_ATTRIBUTE3
,      PARTY_ATTRIBUTE4
,      PARTY_ATTRIBUTE5
,      PARTY_ATTRIBUTE6
,      PARTY_ATTRIBUTE7
,      PARTY_ATTRIBUTE8
,      PARTY_ATTRIBUTE9
,      PARTY_ATTRIBUTE10
,      PARTY_ATTRIBUTE11
,      PARTY_ATTRIBUTE12
,      PARTY_ATTRIBUTE13
,      PARTY_ATTRIBUTE14
,      PARTY_ATTRIBUTE15
,      ACCT_ATTRIBUTE1
,      ACCT_ATTRIBUTE2
,      ACCT_ATTRIBUTE3
,      ACCT_ATTRIBUTE4
,      ACCT_ATTRIBUTE5
,      ACCT_ATTRIBUTE6
,      ACCT_ATTRIBUTE7
,      ACCT_ATTRIBUTE8
,      ACCT_ATTRIBUTE9
,      ACCT_ATTRIBUTE10
,      ACCT_ATTRIBUTE11
,      ACCT_ATTRIBUTE12
,      ACCT_ATTRIBUTE13
,      ACCT_ATTRIBUTE14
,      ACCT_ATTRIBUTE15
,      INSTANCE_ID
,      INSTANCE_DESCRIPTION
,      INSTALL_DATE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      INSTALL_BASE_QUANTITY
,      INSTALL_BASE_UOM
,      INSTALL_LOCATION_ID
,      LAST_OE_ORDER_LINE_ID
FROM APPS.XNB_ORDER_LINES_V;

Dependencies

[top of page]

APPS.XNB_ORDER_LINES_V references the following:

APPS: CSI_ITEM_INSTANCES; MTL_SYSTEM_ITEMS_VL; MTL_UOM_CONVERSIONS; OE_ORDER_LINES_ALL; OE_TRANSACTION_TYPES_VL; QP_LIST_HEADERS_VL; RA_TERMS_VL; XNB_BILL_TO_PARTY_DETAILS

APPS.XNB_ORDER_LINES_V is not referenced by any database object