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


VIEW: APPS.ASO_AK_QUOTE_LINE_V

Object Details
Object Name: ASO_AK_QUOTE_LINE_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
L_QUOTE_HEADER_ID NUMBER
Yes Quote header identifier to which the quote line is attached
L_QUOTE_LINE_ID NUMBER
Yes Quote line identifier
L_LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
L_OBJECT_VERSION_NUMBER NUMBER

Used in hosted environments
L_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
L_ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
L_ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
L_CREATED_BY NUMBER

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

Organization identifier
L_ORDER_LINE_TYPE_ID NUMBER

Order line type identifier
L_LINE_CATEGORY_CODE VARCHAR2 (30)
Category Code
L_PERIODICITY_CODE VARCHAR2 (3)
Charge Periodicity Code
L_AGREEMENT_ID NUMBER

AGREEMENT ID
L_PRICE_LIST_ID NUMBER

Price list identifier
L_INV_TO_CUST_ACCT_ID NUMBER

Bill to customer account identifer
L_INV_TO_CUST_PTY_ID NUMBER

INVOICE TO CUST PARTY IDENTIFIER
L_INV_TO_PTY_ID NUMBER

Bill to contact identifier
L_INV_TO_PTY_SITE_ID NUMBER

Bill to site identifier
L_SHIP_TO_CUST_ACCT_ID NUMBER

Ship tp customer account identier
L_SHIP_TO_CUST_PARTY_ID NUMBER

SHIP TO CUST PARTY IDENTIFIER
L_SHIP_TO_PARTY_ID NUMBER

Ship to contact identifier
L_SHIP_TO_PARTY_SITE_ID NUMBER

Ship to site use identifier
L_END_CUST_CUST_ACCT_ID NUMBER

End Customer cust account Id Identifier
L_END_CUST_CUST_PTY_ID NUMBER

End Customer cust party id Identifier
L_END_CUST_PTY_ID NUMBER

End Customer Party Id Identifier
L_END_CUST_PTY_SITE_ID NUMBER

End Customer Party Site Id Identifier
L_CREDIT_CARD_CODE VARCHAR2 (30)
Credit card code
L_CREDIT_CARD_EXP_DATE DATE

Credit card expiration date
L_CREDIT_CARD_HLD_NAME VARCHAR2 (80)
Name of credit card holder
L_CUST_PO_NUMBER VARCHAR2 (50)
Customer PO number
L_CUST_PO_LINE_NUMBER VARCHAR2 (50)
Cust PO Line Number
L_PAYMENT_REF_NUMBER VARCHAR2 (240)
Stores the reference number for the selected payment_type_code. For example, if payment type is Credit Card, this column stores the credit card number.
L_PAYMENT_TERM_ID NUMBER

Payment term identifier
L_PAYMENT_TYPE_CODE VARCHAR2 (30)
Payment type code from ASO_I_PAYMENT_TYPES_V
L_REQUEST_DATE DATE

Need by date
L_SHIP_METHOD_CODE VARCHAR2 (30)
Freight Carrier and method. Foreign key to table Org_Freight
L_SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
SHIPMENT PRIORITY CODE
L_SHIP_FROM_ORG_ID NUMBER

SHIP FROM ORG IDENTIFIER
L_DEMAND_CLASS_CODE VARCHAR2 (30)
Demand Class Code
L_FOB_CODE VARCHAR2 (30)
Point of ownership transfer
L_FREIGHT_TERMS_CODE VARCHAR2 (30)
Freight term. Applicable only at header level
L_PACKING_INSTRUCTIONS VARCHAR2 (2000)
Special packing instructions
L_SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
Special shipping instructions
L_QUOTE_CUSTOMER_TYPE VARCHAR2 (30)
L_APPLICATION_TYPE_CODE VARCHAR2 (30)
L_PRODUCT VARCHAR2 (40)
L_INVENTORY_ITEM_ID NUMBER
Yes
L_ORGANIZATION_ID NUMBER
Yes
Query Text

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


SELECT L_QUOTE_HEADER_ID
,      L_QUOTE_LINE_ID
,      L_LAST_UPDATE_DATE
,      L_OBJECT_VERSION_NUMBER
,      L_ATTRIBUTE_CATEGORY
,      L_ATTRIBUTE1
,      L_ATTRIBUTE10
,      L_ATTRIBUTE11
,      L_ATTRIBUTE12
,      L_ATTRIBUTE13
,      L_ATTRIBUTE14
,      L_ATTRIBUTE15
,      L_ATTRIBUTE16
,      L_ATTRIBUTE17
,      L_ATTRIBUTE18
,      L_ATTRIBUTE19
,      L_ATTRIBUTE2
,      L_ATTRIBUTE20
,      L_ATTRIBUTE3
,      L_ATTRIBUTE4
,      L_ATTRIBUTE5
,      L_ATTRIBUTE6
,      L_ATTRIBUTE7
,      L_ATTRIBUTE8
,      L_ATTRIBUTE9
,      L_CREATED_BY
,      L_ORG_ID
,      L_ORDER_LINE_TYPE_ID
,      L_LINE_CATEGORY_CODE
,      L_PERIODICITY_CODE
,      L_AGREEMENT_ID
,      L_PRICE_LIST_ID
,      L_INV_TO_CUST_ACCT_ID
,      L_INV_TO_CUST_PTY_ID
,      L_INV_TO_PTY_ID
,      L_INV_TO_PTY_SITE_ID
,      L_SHIP_TO_CUST_ACCT_ID
,      L_SHIP_TO_CUST_PARTY_ID
,      L_SHIP_TO_PARTY_ID
,      L_SHIP_TO_PARTY_SITE_ID
,      L_END_CUST_CUST_ACCT_ID
,      L_END_CUST_CUST_PTY_ID
,      L_END_CUST_PTY_ID
,      L_END_CUST_PTY_SITE_ID
,      L_CREDIT_CARD_CODE
,      L_CREDIT_CARD_EXP_DATE
,      L_CREDIT_CARD_HLD_NAME
,      L_CUST_PO_NUMBER
,      L_CUST_PO_LINE_NUMBER
,      L_PAYMENT_REF_NUMBER
,      L_PAYMENT_TERM_ID
,      L_PAYMENT_TYPE_CODE
,      L_REQUEST_DATE
,      L_SHIP_METHOD_CODE
,      L_SHIPMENT_PRIORITY_CODE
,      L_SHIP_FROM_ORG_ID
,      L_DEMAND_CLASS_CODE
,      L_FOB_CODE
,      L_FREIGHT_TERMS_CODE
,      L_PACKING_INSTRUCTIONS
,      L_SHIPPING_INSTRUCTIONS
,      L_QUOTE_CUSTOMER_TYPE
,      L_APPLICATION_TYPE_CODE
,      L_PRODUCT
,      L_INVENTORY_ITEM_ID
,      L_ORGANIZATION_ID
FROM APPS.ASO_AK_QUOTE_LINE_V;

Dependencies

[top of page]

APPS.ASO_AK_QUOTE_LINE_V references the following:

SchemaAPPS
SynonymASO_PAYMENTS
SynonymASO_QUOTE_HEADERS
SynonymASO_QUOTE_LINES_ALL
SynonymASO_SHIPMENTS
ViewMTL_SYSTEM_ITEMS_VL
APPS.ASO_AK_QUOTE_LINE_V is referenced by following:

SchemaAPPS
Package BodyASO_DEFAULTING_INT - show dependent code
PL/SQL PackageASO_DEFAULTING_UTIL - show dependent code
Package BodyASO_DEFAULTING_UTIL - show dependent code
PL/SQL PackageASO_QUOTE_LINE_DEF_HDLR - show dependent code
PL/SQL PackageASO_QUOTE_LINE_DEP_HDLR - show dependent code
PL/SQL PackageOE_QUOTE_LINE_SECURITY - show dependent code
Package BodyQOT_DEFAULT_PVT - show dependent code