View: OE_BLANKET_LINES_V

Product:	ONT - Order Management
Description:	This view is used to get the BSA lines information, used in BSA entry UI.
Implementation/DBA Data:	APPS.OE_BLANKET_LINES_V

View Text

SELECT OBL.ROWID
, OBLE.ORDER_NUMBER
, OBH.VERSION_NUMBER
, OBL.LINE_ID
, OBL.ORG_ID
, OBL.HEADER_ID
, OBL.LINE_TYPE_ID
, OBL.LINE_NUMBER
, OBL.ORDERED_ITEM
, OBL.REQUEST_DATE
, OBL.PROMISE_DATE
, OBL.SCHEDULE_SHIP_DATE
, OBL.ORDER_QUANTITY_UOM
, OBL.PRICING_QUANTITY
, OBL.PRICING_QUANTITY_UOM
, OBL.CANCELLED_QUANTITY
, OBL.SHIPPED_QUANTITY
, OBL.ORDERED_QUANTITY
, OBL.SHIPPING_QUANTITY
, OBL.SHIPPING_QUANTITY_UOM
, OBL.DELIVERY_LEAD_TIME
, OBL.TAX_EXEMPT_FLAG
, OBL.TAX_EXEMPT_NUMBER
, OBL.TAX_EXEMPT_REASON_CODE
, OBL.SHIP_FROM_ORG_ID
, OBL.SHIP_TO_ORG_ID
, OBL.INVOICE_TO_ORG_ID
, OBL.DELIVER_TO_ORG_ID
, OBL.SHIP_TO_CONTACT_ID
, OBL.DELIVER_TO_CONTACT_ID
, OBL.INVOICE_TO_CONTACT_ID
, OBL.INTMED_SHIP_TO_ORG_ID
, OBL.INTMED_SHIP_TO_CONTACT_ID
, OBL.SOLD_FROM_ORG_ID
, OBL.SOLD_TO_ORG_ID
, OBL.CUST_PO_NUMBER
, OBL.SHIP_TOLERANCE_ABOVE
, OBL.SHIP_TOLERANCE_BELOW
, OBL.DEMAND_BUCKET_TYPE_CODE
, OBL.VEH_CUS_ITEM_CUM_KEY_ID
, OBL.RLA_SCHEDULE_TYPE_CODE
, OBL.CUSTOMER_DOCK_CODE
, OBL.CUSTOMER_JOB
, OBL.CUSTOMER_PRODUCTION_LINE
, OBL.CUST_MODEL_SERIAL_NUMBER
, OBL.PROJECT_ID
, OBL.TASK_ID
, OBL.INVENTORY_ITEM_ID
, OBL.TAX_DATE
, OBL.TAX_CODE
, OBL.TAX_RATE
, OBL.INVOICE_INTERFACE_STATUS_CODE
, OBL.DEMAND_CLASS_CODE
, OBL.PRICE_LIST_ID
, OBL.PRICING_DATE
, OBL.SHIPMENT_NUMBER
, OBL.AGREEMENT_ID
, OBL.SHIPMENT_PRIORITY_CODE
, OBL.SHIPPING_METHOD_CODE
, OBL.FREIGHT_CARRIER_CODE
, OBL.FREIGHT_TERMS_CODE
, OBL.FOB_POINT_CODE
, OBL.TAX_POINT_CODE
, OBL.PAYMENT_TERM_ID
, OBL.INVOICING_RULE_ID
, OBL.ACCOUNTING_RULE_ID
, OBL.SOURCE_DOCUMENT_TYPE_ID
, OBL.ORIG_SYS_DOCUMENT_REF
, OBL.SOURCE_DOCUMENT_ID
, OBL.ORIG_SYS_LINE_REF
, OBL.SOURCE_DOCUMENT_LINE_ID
, OBL.REFERENCE_LINE_ID
, OBL.REFERENCE_TYPE
, OBL.REFERENCE_HEADER_ID
, OBL.ITEM_REVISION
, OBL.UNIT_SELLING_PRICE
, OBL.TAX_VALUE
, OBL.CONTEXT
, OBL.ATTRIBUTE1
, OBL.ATTRIBUTE2
, OBL.ATTRIBUTE3
, OBL.ATTRIBUTE4
, OBL.ATTRIBUTE5
, OBL.ATTRIBUTE6
, OBL.ATTRIBUTE7
, OBL.ATTRIBUTE8
, OBL.ATTRIBUTE9
, OBL.ATTRIBUTE10
, OBL.ATTRIBUTE11
, OBL.ATTRIBUTE12
, OBL.ATTRIBUTE13
, OBL.ATTRIBUTE14
, OBL.ATTRIBUTE15
, OBL.ATTRIBUTE16
, OBL.ATTRIBUTE17
, OBL.ATTRIBUTE18
, OBL.ATTRIBUTE19
, OBL.ATTRIBUTE20
, OBL.GLOBAL_ATTRIBUTE_CATEGORY
, OBL.GLOBAL_ATTRIBUTE1
, OBL.GLOBAL_ATTRIBUTE2
, OBL.GLOBAL_ATTRIBUTE3
, OBL.GLOBAL_ATTRIBUTE4
, OBL.GLOBAL_ATTRIBUTE5
, OBL.GLOBAL_ATTRIBUTE6
, OBL.GLOBAL_ATTRIBUTE7
, OBL.GLOBAL_ATTRIBUTE8
, OBL.GLOBAL_ATTRIBUTE9
, OBL.GLOBAL_ATTRIBUTE10
, OBL.GLOBAL_ATTRIBUTE11
, OBL.GLOBAL_ATTRIBUTE12
, OBL.GLOBAL_ATTRIBUTE13
, OBL.GLOBAL_ATTRIBUTE14
, OBL.GLOBAL_ATTRIBUTE15
, OBL.GLOBAL_ATTRIBUTE16
, OBL.GLOBAL_ATTRIBUTE17
, OBL.GLOBAL_ATTRIBUTE18
, OBL.GLOBAL_ATTRIBUTE19
, OBL.GLOBAL_ATTRIBUTE20
, OBL.PRICING_CONTEXT
, OBL.PRICING_ATTRIBUTE1
, OBL.PRICING_ATTRIBUTE2
, OBL.PRICING_ATTRIBUTE3
, OBL.PRICING_ATTRIBUTE4
, OBL.PRICING_ATTRIBUTE5
, OBL.PRICING_ATTRIBUTE6
, OBL.PRICING_ATTRIBUTE7
, OBL.PRICING_ATTRIBUTE8
, OBL.PRICING_ATTRIBUTE9
, OBL.PRICING_ATTRIBUTE10
, OBL.INDUSTRY_CONTEXT
, OBL.INDUSTRY_ATTRIBUTE1
, OBL.INDUSTRY_ATTRIBUTE2
, OBL.INDUSTRY_ATTRIBUTE3
, OBL.INDUSTRY_ATTRIBUTE4
, OBL.INDUSTRY_ATTRIBUTE5
, OBL.INDUSTRY_ATTRIBUTE6
, OBL.INDUSTRY_ATTRIBUTE7
, OBL.INDUSTRY_ATTRIBUTE8
, OBL.INDUSTRY_ATTRIBUTE9
, OBL.INDUSTRY_ATTRIBUTE10
, OBL.INDUSTRY_ATTRIBUTE11
, OBL.INDUSTRY_ATTRIBUTE13
, OBL.INDUSTRY_ATTRIBUTE12
, OBL.INDUSTRY_ATTRIBUTE14
, OBL.INDUSTRY_ATTRIBUTE15
, OBL.INDUSTRY_ATTRIBUTE16
, OBL.INDUSTRY_ATTRIBUTE17
, OBL.INDUSTRY_ATTRIBUTE18
, OBL.INDUSTRY_ATTRIBUTE19
, OBL.INDUSTRY_ATTRIBUTE20
, OBL.INDUSTRY_ATTRIBUTE21
, OBL.INDUSTRY_ATTRIBUTE22
, OBL.INDUSTRY_ATTRIBUTE23
, OBL.INDUSTRY_ATTRIBUTE24
, OBL.INDUSTRY_ATTRIBUTE25
, OBL.INDUSTRY_ATTRIBUTE26
, OBL.INDUSTRY_ATTRIBUTE27
, OBL.INDUSTRY_ATTRIBUTE28
, OBL.INDUSTRY_ATTRIBUTE29
, OBL.INDUSTRY_ATTRIBUTE30
, OBL.CREATION_DATE
, OBL.CREATED_BY
, OBL.LAST_UPDATE_DATE
, OBL.LAST_UPDATED_BY
, OBL.LAST_UPDATE_LOGIN
, OBL.PROGRAM_APPLICATION_ID
, OBL.PROGRAM_ID
, OBL.PROGRAM_UPDATE_DATE
, OBL.REQUEST_ID
, OBL.TOP_MODEL_LINE_ID
, OBL.LINK_TO_LINE_ID
, OBL.COMPONENT_SEQUENCE_ID
, OBL.COMPONENT_CODE
, OBL.CONFIG_DISPLAY_SEQUENCE
, OBL.SORT_ORDER
, OBL.ITEM_TYPE_CODE
, OBL.OPTION_NUMBER
, OBL.OPTION_FLAG
, OBL.DEP_PLAN_REQUIRED_FLAG
, OBL.VISIBLE_DEMAND_FLAG
, OBL.LINE_CATEGORY_CODE
, OBL.ACTUAL_SHIPMENT_DATE
, OBL.CUSTOMER_TRX_LINE_ID
, OBL.RETURN_CONTEXT
, OBL.RETURN_ATTRIBUTE1
, OBL.RETURN_ATTRIBUTE2
, OBL.RETURN_ATTRIBUTE3
, OBL.RETURN_ATTRIBUTE4
, OBL.RETURN_ATTRIBUTE5
, OBL.RETURN_ATTRIBUTE6
, OBL.RETURN_ATTRIBUTE7
, OBL.RETURN_ATTRIBUTE8
, OBL.RETURN_ATTRIBUTE9
, OBL.RETURN_ATTRIBUTE10
, OBL.RETURN_ATTRIBUTE11
, OBL.RETURN_ATTRIBUTE12
, OBL.RETURN_ATTRIBUTE13
, OBL.RETURN_ATTRIBUTE14
, OBL.RETURN_ATTRIBUTE15
, OBL.ACTUAL_ARRIVAL_DATE
, OBL.ATO_LINE_ID
, OBL.AUTO_SELECTED_QUANTITY
, OBL.COMPONENT_NUMBER
, OBL.EARLIEST_ACCEPTABLE_DATE
, OBL.EXPLOSION_DATE
, OBL.LATEST_ACCEPTABLE_DATE
, OBL.MODEL_GROUP_NUMBER
, OBL.SCHEDULE_ARRIVAL_DATE
, OBL.SHIP_MODEL_COMPLETE_FLAG
, OBL.SCHEDULE_STATUS_CODE
, OBL.SOURCE_TYPE_CODE
, OBL.CANCELLED_FLAG
, OBL.OPEN_FLAG
, OBL.BOOKED_FLAG
, OBL.SALESREP_ID
, OBL.RETURN_REASON_CODE
, OBL.ARRIVAL_SET_ID
, OBL.SHIP_SET_ID
, OBL.SPLIT_FROM_LINE_ID
, OBL.CUST_PRODUCTION_SEQ_NUM
, OBL.AUTHORIZED_TO_SHIP_FLAG
, OBL.OVER_SHIP_REASON_CODE
, OBL.OVER_SHIP_RESOLVED_FLAG
, OBL.ORDERED_ITEM_ID
, OBL.ITEM_IDENTIFIER_TYPE
, OBL.CONFIGURATION_ID
, OBL.COMMITMENT_ID
, OBL.SHIPPING_INTERFACED_FLAG
, OBL.CREDIT_INVOICE_LINE_ID
, OBL.FIRST_ACK_CODE
, OBL.FIRST_ACK_DATE
, OBL.LAST_ACK_CODE
, OBL.LAST_ACK_DATE
, OBL.PLANNING_PRIORITY
, OBL.ORDER_SOURCE_ID
, OBL.ORIG_SYS_SHIPMENT_REF
, OBL.CHANGE_SEQUENCE
, OBL.DROP_SHIP_FLAG
, OBL.CUSTOMER_LINE_NUMBER
, OBL.CUSTOMER_SHIPMENT_NUMBER
, OBL.CUSTOMER_ITEM_NET_PRICE
, OBL.CUSTOMER_PAYMENT_TERM_ID
, OBL.FULFILLED_FLAG
, OBL.END_ITEM_UNIT_NUMBER
, OBL.CONFIG_HEADER_ID
, OBL.CONFIG_REV_NBR
, OBL.MFG_COMPONENT_SEQUENCE_ID
, OBL.SHIPPING_INSTRUCTIONS
, OBL.PACKING_INSTRUCTIONS
, OBL.INVOICED_QUANTITY
, OBL.REFERENCE_CUSTOMER_TRX_LINE_ID
, OBL.SPLIT_BY
, OBL.LINE_SET_ID
, OBL.SERVICE_TXN_REASON_CODE
, OBL.SERVICE_TXN_COMMENTS
, OBL.SERVICE_DURATION
, OBL.SERVICE_START_DATE
, OBL.SERVICE_END_DATE
, OBL.SERVICE_COTERMINATE_FLAG
, OBL.UNIT_LIST_PERCENT
, OBL.UNIT_SELLING_PERCENT
, OBL.UNIT_PERCENT_BASE_PRICE
, OBL.SERVICE_NUMBER
, OBL.SERVICE_PERIOD
, OBL.SHIPPABLE_FLAG
, OBL.MODEL_REMNANT_FLAG
, OBL.RE_SOURCE_FLAG
, OBH.FLOW_STATUS_CODE
, OBL.TP_CONTEXT
, OBL.TP_ATTRIBUTE1
, OBL.TP_ATTRIBUTE2
, OBL.TP_ATTRIBUTE3
, OBL.TP_ATTRIBUTE4
, OBL.TP_ATTRIBUTE5
, OBL.TP_ATTRIBUTE6
, OBL.TP_ATTRIBUTE7
, OBL.TP_ATTRIBUTE8
, OBL.TP_ATTRIBUTE9
, OBL.TP_ATTRIBUTE10
, OBL.TP_ATTRIBUTE11
, OBL.TP_ATTRIBUTE12
, OBL.TP_ATTRIBUTE13
, OBL.TP_ATTRIBUTE14
, OBL.TP_ATTRIBUTE15
, OBL.FULFILLMENT_METHOD_CODE
, OBL.MARKETING_SOURCE_CODE_ID
, OBL.SERVICE_REFERENCE_TYPE_CODE
, OBL.SERVICE_REFERENCE_LINE_ID
, OBL.SERVICE_REFERENCE_SYSTEM_ID
, OBL.CALCULATE_PRICE_FLAG
, OBL.UPGRADED_FLAG
, OBL.REVENUE_AMOUNT
, OBL.FULFILLMENT_DATE
, OBL.PREFERRED_GRADE
, OBL.ORDERED_QUANTITY2
, OBL.ORDERED_QUANTITY_UOM2
, OBL.SHIPPING_QUANTITY2
, OBL.CANCELLED_QUANTITY2
, OBL.SHIPPED_QUANTITY2
, OBL.SHIPPING_QUANTITY_UOM2
, OBL.FULFILLED_QUANTITY2
, OBL.MFG_LEAD_TIME
, OBL.LOCK_CONTROL
, OBL.SUBINVENTORY
, OBL.UNIT_LIST_PRICE_PER_PQTY
, OBL.UNIT_SELLING_PRICE_PER_PQTY
, OBL.PRICE_REQUEST_CODE
, OBL.ORIGINAL_INVENTORY_ITEM_ID
, OBL.ORIGINAL_ORDERED_ITEM_ID
, OBL.ORIGINAL_ORDERED_ITEM
, OBL.ORIGINAL_ITEM_IDENTIFIER_TYPE
, OBL.ITEM_SUBSTITUTION_TYPE_CODE
, OBL.OVERRIDE_ATP_DATE_CODE
, OBL.LATE_DEMAND_PENALTY_FACTOR
, OBLE.START_DATE_ACTIVE
, OBLE.END_DATE_ACTIVE
, OBLE.BLANKET_LINE_MAX_AMOUNT
, OBLE.BLANKET_LINE_MIN_AMOUNT
, OBLE.ENFORCE_PRICE_LIST_FLAG
, OBLE.ENFORCE_SHIP_TO_FLAG
, OBLE.ENFORCE_INVOICE_TO_FLAG
, OBLE.ENFORCE_FREIGHT_TERM_FLAG
, OBLE.ENFORCE_SHIPPING_METHOD_FLAG
, OBLE.ENFORCE_PAYMENT_TERM_FLAG
, OBLE.ENFORCE_ACCOUNTING_RULE_FLAG
, OBLE.ENFORCE_INVOICING_RULE_FLAG
, OBLE.RELEASED_AMOUNT
, OBLE.RETURNED_AMOUNT
, OBLE.MAX_RELEASE_AMOUNT
, OBLE.MIN_RELEASE_AMOUNT
, OBLE.BLANKET_MAX_QUANTITY
, OBLE.BLANKET_MIN_QUANTITY
, OBLE.MAX_RELEASE_QUANTITY
, OBLE.MIN_RELEASE_QUANTITY
, OBLE.OVERRIDE_RELEASE_CONTROLS_FLAG
, OBLE.OVERRIDE_BLANKET_CONTROLS_FLAG
, OBLE.FULFILLED_QUANTITY
, OBLE.RETURNED_QUANTITY
, OBLE.RELEASED_QUANTITY
, OBLE.QP_LIST_LINE_ID
, OEAGR.NAME AGREEMENT
, QLHTL.NAME PRICE_LIST
, ACCRULE.NAME ACCOUNTING_RULE
, INVRULE.NAME INVOICING_RULE
, TERM.NAME TERMS
, MTLP.ORGANIZATION_CODE SHIP_FROM
, MTLP.ORGANIZATION_CODE SHIP_FROM_LOCATION
, SHIP_SU.LOCATION SHIP_TO
, SHIP_SU.LOCATION SHIP_TO_LOCATION
, SHIP_LOC.ADDRESS1 SHIP_TO_ADDRESS1
, SHIP_LOC.ADDRESS2 SHIP_TO_ADDRESS2
, SHIP_LOC.ADDRESS3 SHIP_TO_ADDRESS3
, SHIP_LOC.ADDRESS4 SHIP_TO_ADDRESS4
, DECODE(SHIP_LOC.CITY
, NULL
, NULL
, SHIP_LOC.CITY || '
, ') || DECODE(SHIP_LOC.STATE
, NULL
, NULL
, SHIP_LOC.STATE || '
, ') || DECODE(SHIP_LOC.POSTAL_CODE
, NULL
, NULL
, SHIP_LOC.POSTAL_CODE || '
, ') || DECODE(SHIP_LOC.COUNTRY
, NULL
, NULL
, SHIP_LOC.COUNTRY) SHIP_TO_ADDRESS5
, INV_SU.LOCATION INVOICE_TO
, INV_SU.LOCATION INVOICE_TO_LOCATION
, INV_LOC.ADDRESS1 INVOICE_TO_ADDRESS1
, INV_LOC.ADDRESS2 INVOICE_TO_ADDRESS2
, INV_LOC.ADDRESS3 INVOICE_TO_ADDRESS3
, INV_LOC.ADDRESS4 INVOICE_TO_ADDRESS4
, DECODE(INV_LOC.CITY
, NULL
, NULL
, INV_LOC.CITY || '
, ') || DECODE(INV_LOC.STATE
, NULL
, NULL
, INV_LOC.STATE || '
, ') || DECODE(INV_LOC.POSTAL_CODE
, NULL
, NULL
, INV_LOC.POSTAL_CODE || '
, ') || DECODE(INV_LOC.COUNTRY
, NULL
, NULL
, INV_LOC.COUNTRY) INVOICE_TO_ADDRESS5
, DEL_SU.LOCATION DELIVER_TO
, DEL_SU.LOCATION DELIVER_TO_LOCATION
, DEL_LOC.ADDRESS1 DELIVER_TO_ADDRESS1
, DEL_LOC.ADDRESS2 DELIVER_TO_ADDRESS2
, DEL_LOC.ADDRESS3 DELIVER_TO_ADDRESS3
, DEL_LOC.ADDRESS4 DELIVER_TO_ADDRESS4
, DECODE(DEL_LOC.CITY
, NULL
, NULL
, DEL_LOC.CITY || '
, ') || DECODE(DEL_LOC.STATE
, NULL
, NULL
, DEL_LOC.STATE || '
, ') || DECODE(DEL_LOC.POSTAL_CODE
, NULL
, NULL
, DEL_LOC.POSTAL_CODE || '
, ') || DECODE(DEL_LOC.COUNTRY
, NULL
, NULL
, DEL_LOC.COUNTRY) DELIVER_TO_ADDRESS5
, LKUP.MEANING ITEM_IDENTIFIER
, QGM.DESCRIPTION
, NULL UNIT_OF_MEASURE
, QLL.OPERAND UNIT_LIST_PRICE
, QPA.PRODUCT_UOM_CODE
, OBLE.FULFILLED_AMOUNT
, OBL.TRANSACTION_PHASE_CODE
, OBL.SOURCE_DOCUMENT_VERSION_NUMBER
, OBLE.MODIFIER_LIST_LINE_ID
, OBHE.ON_HOLD_FLAG
, OBH.DRAFT_SUBMITTED_FLAG
FROM OE_BLANKET_LINES_ALL OBL
, OE_BLANKET_HEADERS OBH
, OE_BLANKET_HEADERS_EXT OBHE
, OE_BLANKET_LINES_EXT OBLE
, QP_LIST_HEADERS_TL QLHTL
, OE_AGREEMENTS_TL OEAGR
, RA_RULES ACCRULE
, RA_RULES INVRULE
, RA_TERMS_TL TERM
, MTL_GRADES QGM
, QP_LIST_LINES QLL
, QP_PRICING_ATTRIBUTES QPA
, HZ_CUST_SITE_USES_ALL SHIP_SU
, HZ_PARTY_SITES SHIP_PS
, HZ_LOCATIONS SHIP_LOC
, HZ_CUST_ACCT_SITES_ALL SHIP_CAS
, HZ_CUST_SITE_USES_ALL INV_SU
, HZ_PARTY_SITES INV_PS
, HZ_LOCATIONS INV_LOC
, HZ_CUST_ACCT_SITES_ALL INV_CAS
, HZ_CUST_SITE_USES_ALL DEL_SU
, HZ_PARTY_SITES DEL_PS
, HZ_LOCATIONS DEL_LOC
, HZ_CUST_ACCT_SITES_ALL DEL_CAS
, MTL_PARAMETERS MTLP
, OE_LOOKUPS LKUP
WHERE OBL.LINE_ID = OBLE.LINE_ID
AND OBL.HEADER_ID = OBH.HEADER_ID
AND OBL.PRICE_LIST_ID = QLHTL.LIST_HEADER_ID(+)
AND OBL.AGREEMENT_ID = OEAGR.AGREEMENT_ID(+)
AND OEAGR.LANGUAGE(+) = USERENV('LANG')
AND QLHTL.LANGUAGE(+) = USERENV('LANG')
AND OBL.ACCOUNTING_RULE_ID = ACCRULE.RULE_ID(+)
AND OBL.INVOICING_RULE_ID = INVRULE.RULE_ID(+)
AND OBL.PAYMENT_TERM_ID = TERM.TERM_ID(+)
AND TERM.LANGUAGE(+) = USERENV('LANG')
AND OBL.PREFERRED_GRADE = QGM.GRADE_CODE(+)
AND OBLE.QP_LIST_LINE_ID = QLL.LIST_LINE_ID(+)
AND OBLE.QP_LIST_LINE_ID = QPA.LIST_LINE_ID(+)
AND OBL.SHIP_TO_ORG_ID = SHIP_SU.SITE_USE_ID (+)
AND SHIP_SU.CUST_ACCT_SITE_ID = SHIP_CAS.CUST_ACCT_SITE_ID (+)
AND SHIP_CAS.PARTY_SITE_ID = SHIP_PS.PARTY_SITE_ID (+)
AND SHIP_LOC.LOCATION_ID(+) = SHIP_PS.LOCATION_ID
AND OBL.INVOICE_TO_ORG_ID = INV_SU.SITE_USE_ID (+)
AND INV_SU.CUST_ACCT_SITE_ID = INV_CAS.CUST_ACCT_SITE_ID (+)
AND INV_CAS.PARTY_SITE_ID = INV_PS.PARTY_SITE_ID (+)
AND INV_LOC.LOCATION_ID(+) = INV_PS.LOCATION_ID
AND OBL.DELIVER_TO_ORG_ID = DEL_SU.SITE_USE_ID (+)
AND DEL_SU.CUST_ACCT_SITE_ID = DEL_CAS.CUST_ACCT_SITE_ID (+)
AND DEL_CAS.PARTY_SITE_ID = DEL_PS.PARTY_SITE_ID (+)
AND DEL_LOC.LOCATION_ID(+) = DEL_PS.LOCATION_ID
AND OBL.ITEM_IDENTIFIER_TYPE = LKUP.LOOKUP_CODE(+)
AND LKUP.LOOKUP_TYPE(+) = 'BLANKET_ITEM_IDENTIFIER_TYPE'
AND OBL.SHIP_FROM_ORG_ID = MTLP.ORGANIZATION_ID(+)
AND OBL.SALES_DOCUMENT_TYPE_CODE = 'B'
AND OBH.ORDER_NUMBER = OBHE.ORDER_NUMBER
AND QPA.PRICING_ATTRIBUTE_CONTEXT(+) IS NULL

Columns