APPS.OE_AK_BLANKET_HEADERS_V
[Home] [Help]
| Product: | ONT - Order Management |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.OE_AK_BLANKET_HEADERS_V
|
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'