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

VIEW: APPS.ASO_PVT_QTE_LINES_PRINT_NUM_V

Object Details
Object Name: ASO_PVT_QTE_LINES_PRINT_NUM_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
ROW_ID ROWID (10)
Row Identifier
QUOTE_LINE_ID NUMBER
Yes Quote Line Identifier
QUOTE_HEADER_ID NUMBER
Yes Quote Header Identifier
ORG_ID NUMBER

Organization Identifier
LINE_CATEGORY_CODE VARCHAR2 (30)
Category Code
ITEM_TYPE_CODE VARCHAR2 (30)
Type of item quoted on this line
INVENTORY_ITEM_TYPE VARCHAR2 (30)
Inventory Item Type
LINE_NUMBER NUMBER

Line Number
ORDER_LINE_TYPE_ID NUMBER

Order line type identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier
INVENTORY_ITEM VARCHAR2 (40)
Concatenated Segments from MTL_SYSTEM_ITEMS_VL
PADDED_CONCATENATED_SEGMENTS VARCHAR2 (40)
Padded Concatenated Segments from MTL_SYSTEM_ITEMS_VL
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory Item Description
INDENTED_ITEM_DESCRIPTION VARCHAR2 (4000)
Indented Product Description
QUANTITY NUMBER
Yes Quantity
UOM_CODE VARCHAR2 (3) Yes UOM Code
PRICE_LIST_ID NUMBER

Price List Id
PRICE_LIST_LINE_ID NUMBER

Price List Line Identifier
CURRENCY_CODE VARCHAR2 (15)
Currency Code
LINE_LIST_PRICE NUMBER

Line List Price
LINE_ADJUSTED_AMOUNT NUMBER

Line Adjusted Amount
LINE_ADJUSTED_PERCENT NUMBER

Line Adjusted percent
LINE_QUOTE_PRICE NUMBER

Line Selling Price
EXTENDED_LIST_PRICE NUMBER

Total price of the line
EXTENDED_ADJUSTED_AMOUNT NUMBER

Total adjusted amount of the line
EXTENDED_SELLING_PRICE NUMBER

Total Selling price of the line
START_DATE_ACTIVE DATE

Effective Start Date
END_DATE_ACTIVE DATE

Effective End Date
INVOICE_TO_PARTY_SITE_ID NUMBER

Invoice To Party Site Identifier
INVOICE_TO_PARTY_ID NUMBER

Invoice To Party Identifier
INVOICE_TO_CUST_PARTY_ID NUMBER

Invoice To Customer Party Identifier
MARKETING_SOURCE_CODE_ID NUMBER

Identifier for campaign used
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
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Used in hosted environments
INVOICE_TO_CUST_ACCOUNT_ID NUMBER

Invoice To Customer Account Identifier
MINISITE_ID NUMBER

Used to mimisite id for istore
SECTION_ID NUMBER

Section Identifier
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
LINE_TYPE_SOURCE_FLAG VARCHAR2 (1)
Line type source flag from CZ
SERVICE_ITEM_FLAG VARCHAR2 (1)
Flag to indicate if item is service item
SERVICEABLE_PRODUCT_FLAG VARCHAR2 (1)
Flag to Indicate if Item is Serviceable Item
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).
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
SELLING_PRICE_CHANGE VARCHAR2 (1)
Flag to indicate the change in the selling price.It will be used to handle Price Adjustment for quote line.
RECALCULATE_FLAG VARCHAR2 (1)
Flag to recalculate the Line level price adjustment
PRICING_LINE_TYPE_INDICATOR VARCHAR2 (3)
Populated with Value 'F' if Line is Promotional Line
END_CUSTOMER_PARTY_ID NUMBER

End Customer Party Identifier
END_CUSTOMER_CUST_PARTY_ID NUMBER

End Customer's Customer Party Id
END_CUSTOMER_PARTY_SITE_ID NUMBER

End Customer Party Site Identifier
END_CUSTOMER_CUST_ACCOUNT_ID NUMBER

End Customer Account Identifier
CHARGE_PERIODICITY_CODE VARCHAR2 (3)
Charge Periodicity Code for lines recurring Charges
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
Ship Model Complete Flag
LINE_PAYNOW_CHARGES NUMBER

Pay Now Charges for the line
LINE_PAYNOW_TAX NUMBER

Paynow charges for the line
LINE_PAYNOW_SUBTOTAL NUMBER

PayNow subtotal for line
CHARGE_PERIODICITY_MEANING VARCHAR2 (25)
Charge periodicity meaning from mtl_uom_conversions
QUOTE_LINE_DETAIL_ID NUMBER

Quote Line Detail Identifier
CONFIG_HEADER_ID NUMBER

Configuration header id
CONFIG_REVISION_NUM NUMBER

Configuration revision number
CONFIG_ITEM_ID NUMBER

Unique identifier for a configured item in CZ table.
COMPLETE_CONFIGURATION_FLAG VARCHAR2 (1)
Value is set to 'Y' if configuration is complete
VALID_CONFIGURATION_FLAG VARCHAR2 (1)
Value set to 'Y' if configuration is valid
COMPONENT_CODE VARCHAR2 (1200)
Concatenation of component item ids
SERVICE_COTERMINATE_FLAG VARCHAR2 (1)
Cotermination indicator for service order lines
SERVICE_DURATION NUMBER

Duration for which the product is serviced
SERVICE_UNIT_SELLING_PERCENT NUMBER

Percent actually charged to customer (percent based pricing only)
SERVICE_UNIT_LIST_PERCENT NUMBER

Price list percent of the item (percent based pricing only)
SERVICE_NUMBER NUMBER

service number
SERVICE_PERIOD VARCHAR2 (3)
Period for which the product is serviced
SERVICE_REF_TYPE_CODE VARCHAR2 (30)
type of object to which the service is linked
SERVICE_REF_ORDER_NUMBER NUMBER

order number if the service reference is ORDER
SERVICE_REF_LINE_NUMBER NUMBER

line number if the service reference is ORDER
SERVICE_REF_LINE_ID NUMBER

line id of the line to which the service is linked if the service reference is ORDER
SERVICE_REF_SYSTEM_ID NUMBER

system id
UNIT_PERCENT_BASE_PRICE NUMBER

Base price used for percent based pricing
SERVICE_REF_OPTION_NUMB NUMBER

option number
SERVICE_REF_SHIPMENT_NUMB NUMBER

shipment number
RETURN_REF_TYPE VARCHAR2 (30)
Reference information for returns. (e.g., Order, Invoice, PO etc)
RETURN_REF_HEADER_ID NUMBER

header id of the referenced object
RETURN_REF_LINE_ID NUMBER

Line id of the referenced object
RETURN_REASON_CODE VARCHAR2 (240)
reason for return
REF_TYPE_CODE VARCHAR2 (30)
Used for storing the reference for config item
REF_LINE_ID NUMBER

Used for storing the reference line id for config item
INSTANCE_ID NUMBER

Instance Id
BOM_SORT_ORDER VARCHAR2 (480)
Bom Sort Order from CZ
CONFIG_DELTA NUMBER

Config Delta from cz
CONFIG_INSTANCE_NAME VARCHAR2 (255)
Instance Name from CZ
TOP_MODEL_LINE_ID NUMBER

Line Identifier for Top level model item
ATO_LINE_ID NUMBER

Available To Promise item line Identifier
COMPONENT_SEQUENCE_ID NUMBER

Component Sequence
SHIP_QUOTE_PRICE NUMBER

unit shipment charges at shipment level
MODEL_STATUS VARCHAR2 (80)
Configuration status of a model item
CONFIG_MODEL_TYPE VARCHAR2 (30)
Configurable model type
Query Text

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


SELECT ROW_ID
,      QUOTE_LINE_ID
,      QUOTE_HEADER_ID
,      ORG_ID
,      LINE_CATEGORY_CODE
,      ITEM_TYPE_CODE
,      INVENTORY_ITEM_TYPE
,      LINE_NUMBER
,      ORDER_LINE_TYPE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM
,      PADDED_CONCATENATED_SEGMENTS
,      ITEM_DESCRIPTION
,      INDENTED_ITEM_DESCRIPTION
,      QUANTITY
,      UOM_CODE
,      PRICE_LIST_ID
,      PRICE_LIST_LINE_ID
,      CURRENCY_CODE
,      LINE_LIST_PRICE
,      LINE_ADJUSTED_AMOUNT
,      LINE_ADJUSTED_PERCENT
,      LINE_QUOTE_PRICE
,      EXTENDED_LIST_PRICE
,      EXTENDED_ADJUSTED_AMOUNT
,      EXTENDED_SELLING_PRICE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      INVOICE_TO_PARTY_SITE_ID
,      INVOICE_TO_PARTY_ID
,      INVOICE_TO_CUST_PARTY_ID
,      MARKETING_SOURCE_CODE_ID
,      RELATED_ITEM_ID
,      ITEM_RELATIONSHIP_TYPE
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      SPLIT_SHIPMENT_FLAG
,      BACKORDER_FLAG
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      INVOICE_TO_CUST_ACCOUNT_ID
,      MINISITE_ID
,      SECTION_ID
,      PRICED_PRICE_LIST_ID
,      AGREEMENT_ID
,      COMMITMENT_ID
,      DISPLAY_ARITHMETIC_OPERATOR
,      LINE_TYPE_SOURCE_FLAG
,      SERVICE_ITEM_FLAG
,      SERVICEABLE_PRODUCT_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      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
,      CHARGE_PERIODICITY_CODE
,      SHIP_MODEL_COMPLETE_FLAG
,      LINE_PAYNOW_CHARGES
,      LINE_PAYNOW_TAX
,      LINE_PAYNOW_SUBTOTAL
,      CHARGE_PERIODICITY_MEANING
,      QUOTE_LINE_DETAIL_ID
,      CONFIG_HEADER_ID
,      CONFIG_REVISION_NUM
,      CONFIG_ITEM_ID
,      COMPLETE_CONFIGURATION_FLAG
,      VALID_CONFIGURATION_FLAG
,      COMPONENT_CODE
,      SERVICE_COTERMINATE_FLAG
,      SERVICE_DURATION
,      SERVICE_UNIT_SELLING_PERCENT
,      SERVICE_UNIT_LIST_PERCENT
,      SERVICE_NUMBER
,      SERVICE_PERIOD
,      SERVICE_REF_TYPE_CODE
,      SERVICE_REF_ORDER_NUMBER
,      SERVICE_REF_LINE_NUMBER
,      SERVICE_REF_LINE_ID
,      SERVICE_REF_SYSTEM_ID
,      UNIT_PERCENT_BASE_PRICE
,      SERVICE_REF_OPTION_NUMB
,      SERVICE_REF_SHIPMENT_NUMB
,      RETURN_REF_TYPE
,      RETURN_REF_HEADER_ID
,      RETURN_REF_LINE_ID
,      RETURN_REASON_CODE
,      REF_TYPE_CODE
,      REF_LINE_ID
,      INSTANCE_ID
,      BOM_SORT_ORDER
,      CONFIG_DELTA
,      CONFIG_INSTANCE_NAME
,      TOP_MODEL_LINE_ID
,      ATO_LINE_ID
,      COMPONENT_SEQUENCE_ID
,      SHIP_QUOTE_PRICE
,      MODEL_STATUS
,      CONFIG_MODEL_TYPE
FROM APPS.ASO_PVT_QTE_LINES_PRINT_NUM_V;

Dependencies

[top of page]

APPS.ASO_PVT_QTE_LINES_PRINT_NUM_V references the following:

SchemaAPPS
ViewASO_LOOKUPS
SynonymASO_QUOTE_LINES_ALL
SynonymASO_QUOTE_LINE_DETAILS
SynonymASO_SHIPMENTS
PL/SQL PackageFND_PROFILE - show dependent code
ViewMTL_SYSTEM_ITEMS_VL
SynonymMTL_UOM_CONVERSIONS
APPS.ASO_PVT_QTE_LINES_PRINT_NUM_V is referenced by following:

SchemaAPPS
ViewASO_PVT_QTE_LINES_PRNT_BALI_V