VIEW: APPS.OE_AK_BLANKET_HEADERS_V

Source

View Text - Preformatted

SELECT oebhdr.accounting_rule_id , oebhdr.conversion_type_code , oebhdr.created_by , oebhdr.creation_date , oebhdr.cust_po_number , oebhdr.deliver_to_org_id , oebhdr.freight_terms_code , oebhdr.header_id , oebhdr.invoice_to_org_id , oebhdr.invoicing_rule_id , oebhdr.last_updated_by , oebhdr.last_update_date , oebhdr.last_update_login , oebhdr.order_number , oebhdr.order_type_id , oebhdr.org_id , oebhdr.payment_term_id , oebhdr.price_list_id , oebhdr.program_application_id , oebhdr.program_id , oebhdr.program_update_date , oebhdr.salesrep_id , oebhdr.shipping_method_code , oebhdr.ship_from_org_id , oebhdr.ship_to_org_id , oebhdr.sold_to_contact_id , oebhdr.sold_to_org_id , oebhdr.transactional_curr_code , oebhdr.version_number , oebhdr.shipping_instructions , oebhdr.packing_instructions , oebhdrx.start_date_active , oebhdrx.end_date_active , oebhdrx.revision_change_date , oebhdrx.revision_change_reason_code , oebhdrx.revision_change_comments , oebhdrx.enforce_ship_to_flag , oebhdrx.enforce_freight_term_flag , oebhdrx.enforce_shipping_method_flag , oebhdrx.enforce_price_list_flag , oebhdrx.enforce_payment_term_flag , oebhdrx.enforce_invoice_to_flag , oebhdrx.enforce_invoicing_rule_flag , oebhdrx.enforce_accounting_rule_flag , oebhdrx.blanket_min_amount , oebhdrx.blanket_max_amount , oebhdrx.override_amount_flag , oebhdrx.on_hold_flag , oebhdr.sales_document_name , oebhdr.transaction_phase_code , oebhdr.user_status_code , oebhdr.supplier_signature , oebhdr.supplier_signature_date , oebhdr.customer_signature , oebhdr.customer_signature_date , oebhdr.sold_to_site_use_id , oebhdr.draft_submitted_flag , oebhdr.source_document_version_number , oebhdr.quote_number , oebhdr.quote_date , oebhdr.flow_status_code , oebhdr.source_document_type_id , oebhdrx.new_price_list_id , oebhdrx.new_modifier_list_id , oebhdrx.default_discount_percent , oebhdrx.default_discount_amount , 1 , oebhdr.open_flag , oebhdr.CONTEXT , oebhdr.ATTRIBUTE1 , oebhdr.ATTRIBUTE2 , oebhdr.ATTRIBUTE3 , oebhdr.ATTRIBUTE4 , oebhdr.ATTRIBUTE5 , oebhdr.ATTRIBUTE6 , oebhdr.ATTRIBUTE7 , oebhdr.ATTRIBUTE8 , oebhdr.ATTRIBUTE9 , oebhdr.ATTRIBUTE10 , oebhdr.ATTRIBUTE11 , oebhdr.ATTRIBUTE12 , oebhdr.ATTRIBUTE13 , oebhdr.ATTRIBUTE14 , oebhdr.ATTRIBUTE15 , oebhdr.ATTRIBUTE16 , oebhdr.ATTRIBUTE17 , oebhdr.ATTRIBUTE18 , oebhdr.ATTRIBUTE19 , oebhdr.ATTRIBUTE20 FROM OE_BLANKET_HEADERS_ALL oebhdr, OE_BLANKET_HEADERS_EXT oebhdrx WHERE oebhdr.order_number = oebhdrx.order_number and oebhdr.SALES_DOCUMENT_TYPE_CODE = 'B'

View Text - HTML Formatted

SELECT OEBHDR.ACCOUNTING_RULE_ID
, OEBHDR.CONVERSION_TYPE_CODE
, OEBHDR.CREATED_BY
, OEBHDR.CREATION_DATE
, OEBHDR.CUST_PO_NUMBER
, OEBHDR.DELIVER_TO_ORG_ID
, OEBHDR.FREIGHT_TERMS_CODE
, OEBHDR.HEADER_ID
, OEBHDR.INVOICE_TO_ORG_ID
, OEBHDR.INVOICING_RULE_ID
, OEBHDR.LAST_UPDATED_BY
, OEBHDR.LAST_UPDATE_DATE
, OEBHDR.LAST_UPDATE_LOGIN
, OEBHDR.ORDER_NUMBER
, OEBHDR.ORDER_TYPE_ID
, OEBHDR.ORG_ID
, OEBHDR.PAYMENT_TERM_ID
, OEBHDR.PRICE_LIST_ID
, OEBHDR.PROGRAM_APPLICATION_ID
, OEBHDR.PROGRAM_ID
, OEBHDR.PROGRAM_UPDATE_DATE
, OEBHDR.SALESREP_ID
, OEBHDR.SHIPPING_METHOD_CODE
, OEBHDR.SHIP_FROM_ORG_ID
, OEBHDR.SHIP_TO_ORG_ID
, OEBHDR.SOLD_TO_CONTACT_ID
, OEBHDR.SOLD_TO_ORG_ID
, OEBHDR.TRANSACTIONAL_CURR_CODE
, OEBHDR.VERSION_NUMBER
, OEBHDR.SHIPPING_INSTRUCTIONS
, OEBHDR.PACKING_INSTRUCTIONS
, OEBHDRX.START_DATE_ACTIVE
, OEBHDRX.END_DATE_ACTIVE
, OEBHDRX.REVISION_CHANGE_DATE
, OEBHDRX.REVISION_CHANGE_REASON_CODE
, OEBHDRX.REVISION_CHANGE_COMMENTS
, OEBHDRX.ENFORCE_SHIP_TO_FLAG
, OEBHDRX.ENFORCE_FREIGHT_TERM_FLAG
, OEBHDRX.ENFORCE_SHIPPING_METHOD_FLAG
, OEBHDRX.ENFORCE_PRICE_LIST_FLAG
, OEBHDRX.ENFORCE_PAYMENT_TERM_FLAG
, OEBHDRX.ENFORCE_INVOICE_TO_FLAG
, OEBHDRX.ENFORCE_INVOICING_RULE_FLAG
, OEBHDRX.ENFORCE_ACCOUNTING_RULE_FLAG
, OEBHDRX.BLANKET_MIN_AMOUNT
, OEBHDRX.BLANKET_MAX_AMOUNT
, OEBHDRX.OVERRIDE_AMOUNT_FLAG
, OEBHDRX.ON_HOLD_FLAG
, OEBHDR.SALES_DOCUMENT_NAME
, OEBHDR.TRANSACTION_PHASE_CODE
, OEBHDR.USER_STATUS_CODE
, OEBHDR.SUPPLIER_SIGNATURE
, OEBHDR.SUPPLIER_SIGNATURE_DATE
, OEBHDR.CUSTOMER_SIGNATURE
, OEBHDR.CUSTOMER_SIGNATURE_DATE
, OEBHDR.SOLD_TO_SITE_USE_ID
, OEBHDR.DRAFT_SUBMITTED_FLAG
, OEBHDR.SOURCE_DOCUMENT_VERSION_NUMBER
, OEBHDR.QUOTE_NUMBER
, OEBHDR.QUOTE_DATE
, OEBHDR.FLOW_STATUS_CODE
, OEBHDR.SOURCE_DOCUMENT_TYPE_ID
, OEBHDRX.NEW_PRICE_LIST_ID
, OEBHDRX.NEW_MODIFIER_LIST_ID
, OEBHDRX.DEFAULT_DISCOUNT_PERCENT
, OEBHDRX.DEFAULT_DISCOUNT_AMOUNT
, 1
, OEBHDR.OPEN_FLAG
, OEBHDR.CONTEXT
, OEBHDR.ATTRIBUTE1
, OEBHDR.ATTRIBUTE2
, OEBHDR.ATTRIBUTE3
, OEBHDR.ATTRIBUTE4
, OEBHDR.ATTRIBUTE5
, OEBHDR.ATTRIBUTE6
, OEBHDR.ATTRIBUTE7
, OEBHDR.ATTRIBUTE8
, OEBHDR.ATTRIBUTE9
, OEBHDR.ATTRIBUTE10
, OEBHDR.ATTRIBUTE11
, OEBHDR.ATTRIBUTE12
, OEBHDR.ATTRIBUTE13
, OEBHDR.ATTRIBUTE14
, OEBHDR.ATTRIBUTE15
, OEBHDR.ATTRIBUTE16
, OEBHDR.ATTRIBUTE17
, OEBHDR.ATTRIBUTE18
, OEBHDR.ATTRIBUTE19
, OEBHDR.ATTRIBUTE20
FROM OE_BLANKET_HEADERS_ALL OEBHDR
, OE_BLANKET_HEADERS_EXT OEBHDRX
WHERE OEBHDR.ORDER_NUMBER = OEBHDRX.ORDER_NUMBER
AND OEBHDR.SALES_DOCUMENT_TYPE_CODE = 'B'