[Home] [Help] [Dependency Information]
Object Name: | ASO_AK_QUOTE_LINE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|