VIEW: APPS.ASO_AK_QUOTE_LINE_V

Source

View Text - Preformatted

SELECT line.quote_header_id, line.quote_line_id, header.last_update_date, line.object_version_number, line.attribute_category, line.attribute1, line.attribute10, line.attribute11, line.attribute12, line.attribute13, line.attribute14, line.attribute15, line.attribute16, line.attribute17, line.attribute18, line.attribute19, line.attribute2, line.attribute20, line.attribute3, line.attribute4, line.attribute5, line.attribute6, line.attribute7, line.attribute8, line.attribute9, line.created_by, line.org_id, line.order_line_type_id, line.line_category_code, line.charge_periodicity_code, line.agreement_id, line.price_list_id, line.invoice_to_cust_account_id, line.invoice_to_cust_party_id, line.invoice_to_party_id, line.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, line.end_customer_cust_account_id, line.end_customer_cust_party_id, line.end_customer_party_id, line.end_customer_party_site_id, payment.credit_card_code, payment.credit_card_expiration_date, payment.credit_card_holder_name, payment.cust_po_number, payment.cust_po_line_number, payment.payment_ref_number, payment.payment_term_id, payment.payment_type_code, ship.request_date, ship.ship_method_code, ship.shipment_priority_code, ship.ship_from_org_id, ship.demand_class_code, ship.fob_code, ship.freight_terms_code, ship.packing_instructions, ship.shipping_instructions, DECODE ('X', 'X', 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX', 'X'), DECODE ('X', 'X', 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX', 'X'), inventory.segment1, line.inventory_item_id, line.organization_id FROM aso_quote_lines_all line, aso_quote_headers header, aso_shipments ship, aso_payments payment, mtl_system_items_vl inventory WHERE line.quote_header_id = header.quote_header_id AND ship.quote_line_id = line.quote_line_id AND line.quote_line_id = payment.quote_line_id(+) AND inventory.inventory_item_id = line.inventory_item_id AND inventory.organization_id = line.organization_id AND line.org_id = header.org_id

View Text - HTML Formatted

SELECT LINE.QUOTE_HEADER_ID
, LINE.QUOTE_LINE_ID
, HEADER.LAST_UPDATE_DATE
, LINE.OBJECT_VERSION_NUMBER
, LINE.ATTRIBUTE_CATEGORY
, LINE.ATTRIBUTE1
, LINE.ATTRIBUTE10
, LINE.ATTRIBUTE11
, LINE.ATTRIBUTE12
, LINE.ATTRIBUTE13
, LINE.ATTRIBUTE14
, LINE.ATTRIBUTE15
, LINE.ATTRIBUTE16
, LINE.ATTRIBUTE17
, LINE.ATTRIBUTE18
, LINE.ATTRIBUTE19
, LINE.ATTRIBUTE2
, LINE.ATTRIBUTE20
, LINE.ATTRIBUTE3
, LINE.ATTRIBUTE4
, LINE.ATTRIBUTE5
, LINE.ATTRIBUTE6
, LINE.ATTRIBUTE7
, LINE.ATTRIBUTE8
, LINE.ATTRIBUTE9
, LINE.CREATED_BY
, LINE.ORG_ID
, LINE.ORDER_LINE_TYPE_ID
, LINE.LINE_CATEGORY_CODE
, LINE.CHARGE_PERIODICITY_CODE
, LINE.AGREEMENT_ID
, LINE.PRICE_LIST_ID
, LINE.INVOICE_TO_CUST_ACCOUNT_ID
, LINE.INVOICE_TO_CUST_PARTY_ID
, LINE.INVOICE_TO_PARTY_ID
, LINE.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
, LINE.END_CUSTOMER_CUST_ACCOUNT_ID
, LINE.END_CUSTOMER_CUST_PARTY_ID
, LINE.END_CUSTOMER_PARTY_ID
, LINE.END_CUSTOMER_PARTY_SITE_ID
, PAYMENT.CREDIT_CARD_CODE
, PAYMENT.CREDIT_CARD_EXPIRATION_DATE
, PAYMENT.CREDIT_CARD_HOLDER_NAME
, PAYMENT.CUST_PO_NUMBER
, PAYMENT.CUST_PO_LINE_NUMBER
, PAYMENT.PAYMENT_REF_NUMBER
, PAYMENT.PAYMENT_TERM_ID
, PAYMENT.PAYMENT_TYPE_CODE
, SHIP.REQUEST_DATE
, SHIP.SHIP_METHOD_CODE
, SHIP.SHIPMENT_PRIORITY_CODE
, SHIP.SHIP_FROM_ORG_ID
, SHIP.DEMAND_CLASS_CODE
, SHIP.FOB_CODE
, SHIP.FREIGHT_TERMS_CODE
, SHIP.PACKING_INSTRUCTIONS
, SHIP.SHIPPING_INSTRUCTIONS
, DECODE ('X'
, 'X'
, 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
, 'X')
, DECODE ('X'
, 'X'
, 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
, 'X')
, INVENTORY.SEGMENT1
, LINE.INVENTORY_ITEM_ID
, LINE.ORGANIZATION_ID
FROM ASO_QUOTE_LINES_ALL LINE
, ASO_QUOTE_HEADERS HEADER
, ASO_SHIPMENTS SHIP
, ASO_PAYMENTS PAYMENT
, MTL_SYSTEM_ITEMS_VL INVENTORY
WHERE LINE.QUOTE_HEADER_ID = HEADER.QUOTE_HEADER_ID
AND SHIP.QUOTE_LINE_ID = LINE.QUOTE_LINE_ID
AND LINE.QUOTE_LINE_ID = PAYMENT.QUOTE_LINE_ID(+)
AND INVENTORY.INVENTORY_ITEM_ID = LINE.INVENTORY_ITEM_ID
AND INVENTORY.ORGANIZATION_ID = LINE.ORGANIZATION_ID
AND LINE.ORG_ID = HEADER.ORG_ID