DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKX_QUOTE_LINES_V

Object Details
Object Name: OKX_QUOTE_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_QUOTE_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 Comments
ID1 NUMBER
Yes Quote line identifier
ID2 CHAR (1)
(Multi-part) Primary Key
QUOTE_HEADER_ID NUMBER
Yes Quote header identifier to which the quote line is attached
ORG_ID NUMBER

Operating unit which performed this transaction
LINE_CATEGORY_CODE VARCHAR2 (30)
Category Code
ITEM_TYPE_CODE VARCHAR2 (30)
Type of item quoted on this line
LINE_NUMBER NUMBER

Line number
START_DATE_ACTIVE DATE

Effective start date
END_DATE_ACTIVE DATE

Effective end date
CURRENCY_CODE VARCHAR2 (15)
Currency code
ORDER_LINE_TYPE_ID NUMBER

Order line type identifier
ORGANIZATION_ID NUMBER
Yes Inventory organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
QUANTITY NUMBER
Yes Quantity quoted
UOM_CODE VARCHAR2 (3) Yes Unit of measure
STATUS VARCHAR2 (1)
NAME VARCHAR2 (0)
Quote line name
DESCRIPTION VARCHAR2 (0)
Description
LINE_LIST_PRICE NUMBER

Unit price for the item
AGREEMENT_ID NUMBER

LINE_QUOTE_PRICE NUMBER

Summation of line list price and line adjusted amount
PRICE_LIST_ID NUMBER

Price list identifier
PRICE_LIST_LINE_ID NUMBER

Price list line identifier
INVOICING_RULE_ID NUMBER

Invoicing rule identifier
INVOICE_TO_PARTY_SITE_ID NUMBER

Bill to site identifier
INVOICE_TO_PARTY_ID NUMBER

Bill to contact identifier
INVOICE_TO_CUST_ACCOUNT_ID NUMBER

Query Text

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


SELECT ID1
,      ID2
,      QUOTE_HEADER_ID
,      ORG_ID
,      LINE_CATEGORY_CODE
,      ITEM_TYPE_CODE
,      LINE_NUMBER
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CURRENCY_CODE
,      ORDER_LINE_TYPE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      QUANTITY
,      UOM_CODE
,      STATUS
,      NAME
,      DESCRIPTION
,      LINE_LIST_PRICE
,      AGREEMENT_ID
,      LINE_QUOTE_PRICE
,      PRICE_LIST_ID
,      PRICE_LIST_LINE_ID
,      INVOICING_RULE_ID
,      INVOICE_TO_PARTY_SITE_ID
,      INVOICE_TO_PARTY_ID
,      INVOICE_TO_CUST_ACCOUNT_ID
FROM APPS.OKX_QUOTE_LINES_V;

Dependencies

[top of page]

APPS.OKX_QUOTE_LINES_V references the following:

SchemaAPPS
SynonymASO_QUOTE_LINES_ALL
APPS.OKX_QUOTE_LINES_V is referenced by following:

SchemaAPPS
Package BodyOKC_OC_INT_CONFIG_PVT - show dependent code
PL/SQL PackageOKC_OC_INT_CONFIG_PVT - show dependent code
Package BodyOKC_OC_INT_KTQ_PVT - show dependent code
Package BodyOKC_OC_INT_PRICING_PVT - show dependent code
PL/SQL PackageOKC_OC_INT_PRICING_PVT - show dependent code
PL/SQL PackageOKC_OC_INT_PUB - show dependent code
PL/SQL PackageOKC_OC_INT_QTK_PVT - show dependent code
PL/SQL PackageOKC_OC_INT_SALESCDT_PVT - show dependent code
Package BodyOKC_OC_INT_SALESCDT_PVT - show dependent code
ViewOKC_REL_OBJ_QUOTE_LINES_V