VIEW: APPS.ASO_AK_QUOTE_RELATED_RECORDS_V

Source

View Text - Preformatted

SELECT header.contract_id, header.price_list_id, header.invoice_to_cust_account_id, header.invoice_to_cust_party_id, header.invoice_to_party_id, header.invoice_to_party_site_id, ship.ship_to_cust_account_id, ship.ship_to_cust_party_id, ship.ship_to_party_id, ship.ship_to_party_site_id, header.end_customer_cust_account_id, header.end_customer_cust_party_id, header.end_customer_party_id, header.end_customer_party_site_id, payment.payment_term_id, payment.cust_po_number, payment.payment_type_code, payment.credit_card_code, payment.credit_card_expiration_date, payment.credit_card_holder_name, payment.payment_ref_number, ship.request_date, ship.ship_method_code, ship.shipment_priority_code, ship.freight_terms_code, ship.fob_code, ship.demand_class_code, ship.shipping_instructions, ship.packing_instructions FROM aso_quote_headers_all header, aso_shipments ship, aso_payments payment WHERE ship.quote_header_id = header.quote_header_id AND header.quote_header_id = payment.quote_header_id(+)

View Text - HTML Formatted

SELECT HEADER.CONTRACT_ID
, HEADER.PRICE_LIST_ID
, HEADER.INVOICE_TO_CUST_ACCOUNT_ID
, HEADER.INVOICE_TO_CUST_PARTY_ID
, HEADER.INVOICE_TO_PARTY_ID
, HEADER.INVOICE_TO_PARTY_SITE_ID
, SHIP.SHIP_TO_CUST_ACCOUNT_ID
, SHIP.SHIP_TO_CUST_PARTY_ID
, SHIP.SHIP_TO_PARTY_ID
, SHIP.SHIP_TO_PARTY_SITE_ID
, HEADER.END_CUSTOMER_CUST_ACCOUNT_ID
, HEADER.END_CUSTOMER_CUST_PARTY_ID
, HEADER.END_CUSTOMER_PARTY_ID
, HEADER.END_CUSTOMER_PARTY_SITE_ID
, PAYMENT.PAYMENT_TERM_ID
, PAYMENT.CUST_PO_NUMBER
, PAYMENT.PAYMENT_TYPE_CODE
, PAYMENT.CREDIT_CARD_CODE
, PAYMENT.CREDIT_CARD_EXPIRATION_DATE
, PAYMENT.CREDIT_CARD_HOLDER_NAME
, PAYMENT.PAYMENT_REF_NUMBER
, SHIP.REQUEST_DATE
, SHIP.SHIP_METHOD_CODE
, SHIP.SHIPMENT_PRIORITY_CODE
, SHIP.FREIGHT_TERMS_CODE
, SHIP.FOB_CODE
, SHIP.DEMAND_CLASS_CODE
, SHIP.SHIPPING_INSTRUCTIONS
, SHIP.PACKING_INSTRUCTIONS
FROM ASO_QUOTE_HEADERS_ALL HEADER
, ASO_SHIPMENTS SHIP
, ASO_PAYMENTS PAYMENT
WHERE SHIP.QUOTE_HEADER_ID = HEADER.QUOTE_HEADER_ID
AND HEADER.QUOTE_HEADER_ID = PAYMENT.QUOTE_HEADER_ID(+)