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

VIEW: APPS.ASO_QUOTE_LINES_ALL_V

Object Details
Object Name: ASO_QUOTE_LINES_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewASO.ASO_QUOTE_LINES_ALL_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


quote lines


[View Source]

Columns
Name Datatype Length Mandatory Comments
QUOTE_LINE_ID NUMBER
Yes Quote line identifier
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
QUOTE_HEADER_ID NUMBER
Yes Quote header identifier to which the quote line is attached
ORG_ID NUMBER

Organization identifier
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
ORDER_LINE_TYPE_ID NUMBER

Order line type 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

Bill to customer account identifer
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
MARKETING_SOURCE_CODE_ID NUMBER

Identifier for campaign used
PRICE_LIST_ID NUMBER

Price list identifier
PRICE_LIST_LINE_ID NUMBER

Price list line identifier
CURRENCY_CODE VARCHAR2 (15)
Currency code
LINE_LIST_PRICE NUMBER

Unit price for the item
LINE_ADJUSTED_AMOUNT NUMBER

Adjustment or discount amount applied at the line level. A negative column is stored if the amount is to be deducted from the list price.
LINE_ADJUSTED_PERCENT NUMBER

Adjustment or discount percent applied to this line
LINE_QUOTE_PRICE NUMBER

Summation of line list price and line adjusted amount
RELATED_ITEM_ID NUMBER

Related item identifier as a result of an substitute/up-sell/cross-sell effort
ITEM_RELATIONSHIP_TYPE VARCHAR2 (15)
Type of relationship between the related item and the quoted item (e.g. up-sell, cross-sell, substitute)
ACCOUNTING_RULE_ID NUMBER

Accounting rule identifier
INVOICING_RULE_ID NUMBER

Invoicing rule identifier
SPLIT_SHIPMENT_FLAG VARCHAR2 (1)
Flag to indicate whether the quote line is splitted into multiple shipments
BACKORDER_FLAG VARCHAR2 (1)
Flag to indicate whether the quote line is being backordered
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
MINISITE_ID NUMBER

minisite indentifier
SECTION_ID NUMBER

section indentifier
PRICED_PRICE_LIST_ID NUMBER

PRICE LIST ID returned by QP
AGREEMENT_ID NUMBER

AGREEMENT ID
COMMITMENT_ID NUMBER

COMMITMENT ID
DISPLAY_ARITHMETIC_OPERATOR VARCHAR2 (30)
DISPLAY ARITHMETIC OPERATOR
INVOICE_TO_CUST_PARTY_ID NUMBER

INVOICE TO CUST PARTY IDENTIFIER
LINE_TYPE_SOURCE_FLAG VARCHAR2 (1)
Line Type Source Flag used in MACD flows
SERVICE_ITEM_FLAG VARCHAR2 (1)
Service item Flag
SERVICEABLE_PRODUCT_FLAG VARCHAR2 (1)
Serviceable Product Flag
SELLING_PRICE_CHANGE VARCHAR2 (1)
Selling Price Change Flag
RECALCULATE_FLAG VARCHAR2 (1)
Recalculate Flag
PRICING_LINE_TYPE_INDICATOR VARCHAR2 (3)
Flag to indicate if the Line is a Promotional Good Line
END_CUSTOMER_PARTY_ID NUMBER

End Customer Party Id
END_CUSTOMER_CUST_PARTY_ID NUMBER

End Customer Cust Party Identifier
END_CUSTOMER_PARTY_SITE_ID NUMBER

End Customer Party Site Identifier
END_CUSTOMER_CUST_ACCOUNT_ID NUMBER

End Customer Cust Account Identifier
CONFIG_MODEL_TYPE VARCHAR2 (30)
Denormalized Inventory Attribute - Config Model Type - Used for Network Container
Query Text

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


SELECT QUOTE_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      QUOTE_HEADER_ID
,      ORG_ID
,      LINE_CATEGORY_CODE
,      ITEM_TYPE_CODE
,      LINE_NUMBER
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ORDER_LINE_TYPE_ID
,      INVOICE_TO_PARTY_SITE_ID
,      INVOICE_TO_PARTY_ID
,      INVOICE_TO_CUST_ACCOUNT_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      QUANTITY
,      UOM_CODE
,      MARKETING_SOURCE_CODE_ID
,      PRICE_LIST_ID
,      PRICE_LIST_LINE_ID
,      CURRENCY_CODE
,      LINE_LIST_PRICE
,      LINE_ADJUSTED_AMOUNT
,      LINE_ADJUSTED_PERCENT
,      LINE_QUOTE_PRICE
,      RELATED_ITEM_ID
,      ITEM_RELATIONSHIP_TYPE
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      SPLIT_SHIPMENT_FLAG
,      BACKORDER_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      MINISITE_ID
,      SECTION_ID
,      PRICED_PRICE_LIST_ID
,      AGREEMENT_ID
,      COMMITMENT_ID
,      DISPLAY_ARITHMETIC_OPERATOR
,      INVOICE_TO_CUST_PARTY_ID
,      LINE_TYPE_SOURCE_FLAG
,      SERVICE_ITEM_FLAG
,      SERVICEABLE_PRODUCT_FLAG
,      SELLING_PRICE_CHANGE
,      RECALCULATE_FLAG
,      PRICING_LINE_TYPE_INDICATOR
,      END_CUSTOMER_PARTY_ID
,      END_CUSTOMER_CUST_PARTY_ID
,      END_CUSTOMER_PARTY_SITE_ID
,      END_CUSTOMER_CUST_ACCOUNT_ID
,      CONFIG_MODEL_TYPE
FROM APPS.ASO_QUOTE_LINES_ALL_V;

Dependencies

[top of page]

APPS.ASO_QUOTE_LINES_ALL_V references the following:

SchemaAPPS
SynonymASO_QUOTE_LINES
APPS.ASO_QUOTE_LINES_ALL_V is referenced by following:

SchemaAPPS
Package BodyAMS_RUNTIME_CAMP_PVT - show dependent code
Package BodyAMS_RUNTIME_PROD_PVT - show dependent code