VIEW: APPS.ASO_OA_QUOTE_LINES_ALL_V

Source

View Text - Preformatted

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 , 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 , 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 , INVOICE_TO_CUST_PARTY_ID , SELLING_PRICE_CHANGE , RECALCULATE_FLAG , PRICING_LINE_TYPE_INDICATOR , END_CUSTOMER_PARTY_ID , END_CUSTOMER_PARTY_SITE_ID , END_CUSTOMER_CUST_PARTY_ID , END_CUSTOMER_CUST_ACCOUNT_ID, ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE20 , SHIP_MODEL_COMPLETE_FLAG , CHARGE_PERIODICITY_CODE , LINE_PAYNOW_CHARGES , LINE_PAYNOW_TAX , LINE_PAYNOW_SUBTOTAL , PRICING_QUANTITY_UOM , PRICING_QUANTITY , 'S' , CONFIG_MODEL_TYPE from aso_quote_lines_all

View Text - HTML Formatted

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
, 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
, 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
, INVOICE_TO_CUST_PARTY_ID
, SELLING_PRICE_CHANGE
, RECALCULATE_FLAG
, PRICING_LINE_TYPE_INDICATOR
, END_CUSTOMER_PARTY_ID
, END_CUSTOMER_PARTY_SITE_ID
, END_CUSTOMER_CUST_PARTY_ID
, END_CUSTOMER_CUST_ACCOUNT_ID
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, SHIP_MODEL_COMPLETE_FLAG
, CHARGE_PERIODICITY_CODE
, LINE_PAYNOW_CHARGES
, LINE_PAYNOW_TAX
, LINE_PAYNOW_SUBTOTAL
, PRICING_QUANTITY_UOM
, PRICING_QUANTITY
, 'S'
, CONFIG_MODEL_TYPE
FROM ASO_QUOTE_LINES_ALL