View: OE_AK_BLANKET_LINES_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_AK_BLANKET_LINES_V

View Text

SELECT BLE.ORDER_NUMBER
, BLE.LINE_NUMBER
, BLE.LINE_ID
, BL.SHIP_TO_ORG_ID
, BL.INVOICE_TO_ORG_ID
, BL.DELIVER_TO_ORG_ID
, BL.SHIP_FROM_ORG_ID
, BL.PRICE_LIST_ID
, BL.CUST_PO_NUMBER
, BL.INVOICING_RULE_ID
, BL.ACCOUNTING_RULE_ID
, BL.PAYMENT_TERM_ID
, BL.SHIPPING_METHOD_CODE
, BL.FREIGHT_TERMS_CODE
, BL.SALESREP_ID
, BL.SHIPPING_INSTRUCTIONS
, BL.PACKING_INSTRUCTIONS
, BL.PREFERRED_GRADE
, BL.ITEM_IDENTIFIER_TYPE
, BL.INVENTORY_ITEM_ID
, BL.ORDER_QUANTITY_UOM
, BLE.START_DATE_ACTIVE
, BLE.END_DATE_ACTIVE
, BLE.ENFORCE_SHIP_TO_FLAG
, BLE.ENFORCE_SHIPPING_METHOD_FLAG
, BLE.ENFORCE_FREIGHT_TERM_FLAG
, BLE.ENFORCE_INVOICE_TO_FLAG
, 1
, BLE.ENFORCE_PRICE_LIST_FLAG
, BLE.ENFORCE_PAYMENT_TERM_FLAG
, BLE.ENFORCE_INVOICING_RULE_FLAG
, BLE.BLANKET_LINE_MIN_AMOUNT
, BLE.BLANKET_LINE_MAX_AMOUNT
, BLE.BLANKET_MIN_QUANTITY
, BLE.BLANKET_MAX_QUANTITY
, BLE.MIN_RELEASE_AMOUNT
, BLE.MAX_RELEASE_AMOUNT
, BLE.MIN_RELEASE_QUANTITY
, BLE.MAX_RELEASE_QUANTITY
, BLE.OVERRIDE_BLANKET_CONTROLS_FLAG
, BLE.OVERRIDE_RELEASE_CONTROLS_FLAG
, BL.TRANSACTION_PHASE_CODE
, BL.SOURCE_DOCUMENT_VERSION_NUMBER
, BL.SOURCE_DOCUMENT_TYPE_ID
, BLE.ENFORCE_ACCOUNTING_RULE_FLAG
, BLE.MODIFIER_LIST_LINE_ID
, 1
, 1
, RPAD('X'
, 30
, '-')
, BL.CONTEXT
, BL.ATTRIBUTE1
, BL.ATTRIBUTE2
, BL.ATTRIBUTE3
, BL.ATTRIBUTE4
, BL.ATTRIBUTE5
, BL.ATTRIBUTE6
, BL.ATTRIBUTE7
, BL.ATTRIBUTE8
, BL.ATTRIBUTE9
, BL.ATTRIBUTE10
, BL.ATTRIBUTE11
, BL.ATTRIBUTE12
, BL.ATTRIBUTE13
, BL.ATTRIBUTE14
, BL.ATTRIBUTE15
, BL.ATTRIBUTE16
, BL.ATTRIBUTE17
, BL.ATTRIBUTE18
, BL.ATTRIBUTE19
, BL.ATTRIBUTE20
FROM OE_BLANKET_LINES BL
, OE_BLANKET_LINES_EXT BLE
WHERE BL.LINE_ID = BLE.LINE_ID
AND BL.SALES_DOCUMENT_TYPE_CODE = 'B'

Columns