VIEW: APPS.ASO_AK_QUOTE_HEADER_V

Source

View Text - Preformatted

SELECT header.quote_header_id, header.quote_name, header.cust_account_id, header.quote_expiration_date, header.quote_status_id, header.org_id, header.created_by, header.order_type_id, header.contract_id, header.price_list_id, header.currency_code, header.price_frozen_date, header.contract_template_id, header.resource_id, header.resource_grp_id, header.sales_channel_code, header.marketing_source_code_id mkt_source_code_id , header.party_id, header.phone_id, header.sold_to_party_site_id, header.invoice_to_cust_party_id, header.invoice_to_cust_account_id, header.invoice_to_party_site_id, header.invoice_to_party_id, header.cust_party_id, header.end_customer_cust_party_id, header.end_customer_cust_account_id, header.end_customer_party_site_id, header.end_customer_party_id, header.automatic_price_flag, header.automatic_tax_flag, header.last_update_date, header.object_version_number, header.attribute_category, header.attribute1, header.attribute2, header.attribute3, header.attribute4, header.attribute5, header.attribute6, header.attribute7, header.attribute8, header.attribute9, header.attribute10, header.attribute11, header.attribute12, header.attribute13, header.attribute14, header.attribute15, header.attribute16, header.attribute17, header.attribute18, header.attribute19, header.attribute20, ship.ship_to_cust_party_id, ship.ship_to_cust_account_id, ship.ship_to_party_site_id, ship.ship_to_party_id, payment.payment_term_id, payment.cust_po_number, payment.credit_card_code, payment.payment_ref_number, payment.credit_card_holder_name, payment.credit_card_expiration_date, payment.payment_type_code, ship.request_date_type, ship.request_date, ship.ship_method_code, ship.shipment_priority_code, ship.freight_terms_code, ship.fob_code, ship.shipping_instructions, ship.packing_instructions, ship.demand_class_code, DECODE ('X', 'X', 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX', 'X'), DECODE ('X', 'X', 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX', 'X') FROM aso_quote_headers header, aso_shipments ship, aso_payments payment WHERE ship.quote_header_id(+) = header.quote_header_id AND payment.quote_header_id(+) = header.quote_header_id and ship.quote_line_id(+) is null and payment.quote_line_id(+) is null

View Text - HTML Formatted

SELECT HEADER.QUOTE_HEADER_ID
, HEADER.QUOTE_NAME
, HEADER.CUST_ACCOUNT_ID
, HEADER.QUOTE_EXPIRATION_DATE
, HEADER.QUOTE_STATUS_ID
, HEADER.ORG_ID
, HEADER.CREATED_BY
, HEADER.ORDER_TYPE_ID
, HEADER.CONTRACT_ID
, HEADER.PRICE_LIST_ID
, HEADER.CURRENCY_CODE
, HEADER.PRICE_FROZEN_DATE
, HEADER.CONTRACT_TEMPLATE_ID
, HEADER.RESOURCE_ID
, HEADER.RESOURCE_GRP_ID
, HEADER.SALES_CHANNEL_CODE
, HEADER.MARKETING_SOURCE_CODE_ID MKT_SOURCE_CODE_ID
, HEADER.PARTY_ID
, HEADER.PHONE_ID
, HEADER.SOLD_TO_PARTY_SITE_ID
, HEADER.INVOICE_TO_CUST_PARTY_ID
, HEADER.INVOICE_TO_CUST_ACCOUNT_ID
, HEADER.INVOICE_TO_PARTY_SITE_ID
, HEADER.INVOICE_TO_PARTY_ID
, HEADER.CUST_PARTY_ID
, HEADER.END_CUSTOMER_CUST_PARTY_ID
, HEADER.END_CUSTOMER_CUST_ACCOUNT_ID
, HEADER.END_CUSTOMER_PARTY_SITE_ID
, HEADER.END_CUSTOMER_PARTY_ID
, HEADER.AUTOMATIC_PRICE_FLAG
, HEADER.AUTOMATIC_TAX_FLAG
, HEADER.LAST_UPDATE_DATE
, HEADER.OBJECT_VERSION_NUMBER
, HEADER.ATTRIBUTE_CATEGORY
, HEADER.ATTRIBUTE1
, HEADER.ATTRIBUTE2
, HEADER.ATTRIBUTE3
, HEADER.ATTRIBUTE4
, HEADER.ATTRIBUTE5
, HEADER.ATTRIBUTE6
, HEADER.ATTRIBUTE7
, HEADER.ATTRIBUTE8
, HEADER.ATTRIBUTE9
, HEADER.ATTRIBUTE10
, HEADER.ATTRIBUTE11
, HEADER.ATTRIBUTE12
, HEADER.ATTRIBUTE13
, HEADER.ATTRIBUTE14
, HEADER.ATTRIBUTE15
, HEADER.ATTRIBUTE16
, HEADER.ATTRIBUTE17
, HEADER.ATTRIBUTE18
, HEADER.ATTRIBUTE19
, HEADER.ATTRIBUTE20
, SHIP.SHIP_TO_CUST_PARTY_ID
, SHIP.SHIP_TO_CUST_ACCOUNT_ID
, SHIP.SHIP_TO_PARTY_SITE_ID
, SHIP.SHIP_TO_PARTY_ID
, PAYMENT.PAYMENT_TERM_ID
, PAYMENT.CUST_PO_NUMBER
, PAYMENT.CREDIT_CARD_CODE
, PAYMENT.PAYMENT_REF_NUMBER
, PAYMENT.CREDIT_CARD_HOLDER_NAME
, PAYMENT.CREDIT_CARD_EXPIRATION_DATE
, PAYMENT.PAYMENT_TYPE_CODE
, SHIP.REQUEST_DATE_TYPE
, SHIP.REQUEST_DATE
, SHIP.SHIP_METHOD_CODE
, SHIP.SHIPMENT_PRIORITY_CODE
, SHIP.FREIGHT_TERMS_CODE
, SHIP.FOB_CODE
, SHIP.SHIPPING_INSTRUCTIONS
, SHIP.PACKING_INSTRUCTIONS
, SHIP.DEMAND_CLASS_CODE
, DECODE ('X'
, 'X'
, 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
, 'X')
, DECODE ('X'
, 'X'
, 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
, 'X')
FROM ASO_QUOTE_HEADERS HEADER
, ASO_SHIPMENTS SHIP
, ASO_PAYMENTS PAYMENT
WHERE SHIP.QUOTE_HEADER_ID(+) = HEADER.QUOTE_HEADER_ID
AND PAYMENT.QUOTE_HEADER_ID(+) = HEADER.QUOTE_HEADER_ID
AND SHIP.QUOTE_LINE_ID(+) IS NULL
AND PAYMENT.QUOTE_LINE_ID(+) IS NULL