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:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
ViewMTL_SYSTEM_ITEMS_VL
SynonymMTL_UOM_CONVERSIONS
SynonymOE_ORDER_LINES_ALL
ViewOE_TRANSACTION_TYPES_VL
ViewQP_LIST_HEADERS_VL
ViewRA_TERMS_VL
SynonymXNB_BILL_TO_PARTY_DETAILS

APPS.XNB_ORDER_LINES_V is not referenced by any database object