VIEW: APPS.OE_AK_BLANKET_LINES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'