VIEW: APPS.OE_BLKT_LINES_HIST_V

Source

View Text - Preformatted

SELECT OBL.ROWID, 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, OBL.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, to_number(null), /*OBL.BLANKET_VERSION_NUMBER,*/ OBH.VERSION_NUMBER, OBLE.START_DATE_ACTIVE, OBLE.END_DATE_ACTIVE, OBLE.BLANKET_LINE_MAX_AMOUNT, OBLE.BLANKET_LINE_MIN_AMOUNT, OBLE.ENFORCE_PRICE_LIST_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, LKUP.meaning item_identifier, QGM.description, null unit_of_measure, QLL.operand UNIT_LIST_PRICE, QPA.product_uom_code, OBLE.order_number, 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.FULFILLED_AMOUNT, OBL.TRANSACTION_PHASE_CODE, OBL.SOURCE_DOCUMENT_VERSION_NUMBER, OBLE.MODIFIER_LIST_LINE_ID FROM oe_blanket_lines_all OBL, oe_blanket_headers OBH, 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, 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.ITEM_IDENTIFIER_TYPE = LKUP.LOOKUP_CODE(+) and LKUP.LOOKUP_TYPE(+) = 'ITEM_IDENTIFIER_TYPE' and OBL.SHIP_FROM_ORG_ID = MTLP.ORGANIZATION_ID(+) and OBL.SALES_DOCUMENT_TYPE_CODE = 'B' AND QPA.pricing_attribute_context(+) is null UNION ALL SELECT OBLH.ROWID, OBLH.LINE_ID, OBLH.ORG_ID, OBLH.HEADER_ID, OBLH.LINE_TYPE_ID, OBLH.LINE_NUMBER, OBLH.ORDERED_ITEM, OBLH.REQUEST_DATE, OBLH.PROMISE_DATE, OBLH.SCHEDULE_SHIP_DATE, OBLH.ORDER_QUANTITY_UOM, OBLH.PRICING_QUANTITY, OBLH.PRICING_QUANTITY_UOM, OBLH.CANCELLED_QUANTITY, OBLH.SHIPPED_QUANTITY, OBLH.ORDERED_QUANTITY, OBLH.SHIPPING_QUANTITY, OBLH.SHIPPING_QUANTITY_UOM, OBLH.DELIVERY_LEAD_TIME, OBLH.TAX_EXEMPT_FLAG, OBLH.TAX_EXEMPT_NUMBER, OBLH.TAX_EXEMPT_REASON_CODE, OBLH.SHIP_FROM_ORG_ID, OBLH.SHIP_TO_ORG_ID, OBLH.INVOICE_TO_ORG_ID, OBLH.DELIVER_TO_ORG_ID, OBLH.SHIP_TO_CONTACT_ID, OBLH.DELIVER_TO_CONTACT_ID, OBLH.INVOICE_TO_CONTACT_ID, OBLH.INTMED_SHIP_TO_ORG_ID, OBLH.INTMED_SHIP_TO_CONTACT_ID, OBLH.SOLD_FROM_ORG_ID, OBLH.SOLD_TO_ORG_ID, OBLH.CUST_PO_NUMBER, OBLH.SHIP_TOLERANCE_ABOVE, OBLH.SHIP_TOLERANCE_BELOW, OBLH.DEMAND_BUCKET_TYPE_CODE, OBLH.VEH_CUS_ITEM_CUM_KEY_ID, OBLH.RLA_SCHEDULE_TYPE_CODE, OBLH.CUSTOMER_DOCK_CODE, OBLH.CUSTOMER_JOB, OBLH.CUSTOMER_PRODUCTION_LINE, OBLH.CUST_MODEL_SERIAL_NUMBER, OBLH.PROJECT_ID, OBLH.TASK_ID, OBLH.INVENTORY_ITEM_ID, OBLH.TAX_DATE, OBLH.TAX_CODE, OBLH.TAX_RATE, OBLH.INVOICE_INTERFACE_STATUS_CODE, OBLH.DEMAND_CLASS_CODE, OBLH.PRICE_LIST_ID, OBLH.PRICING_DATE, OBLH.SHIPMENT_NUMBER, OBLH.AGREEMENT_ID, OBLH.SHIPMENT_PRIORITY_CODE, OBLH.SHIPPING_METHOD_CODE, OBLH.FREIGHT_CARRIER_CODE, OBLH.FREIGHT_TERMS_CODE, OBLH.FOB_POINT_CODE, OBLH.TAX_POINT_CODE, OBLH.PAYMENT_TERM_ID, OBLH.INVOICING_RULE_ID, OBLH.ACCOUNTING_RULE_ID, OBLH.SOURCE_DOCUMENT_TYPE_ID, OBLH.ORIG_SYS_DOCUMENT_REF, OBLH.SOURCE_DOCUMENT_ID, OBLH.ORIG_SYS_LINE_REF, OBLH.SOURCE_DOCUMENT_LINE_ID, OBLH.REFERENCE_LINE_ID, OBLH.REFERENCE_TYPE, OBLH.REFERENCE_HEADER_ID, OBLH.ITEM_REVISION, OBLH.UNIT_SELLING_PRICE, OBLH.TAX_VALUE, OBLH.CONTEXT, OBLH.ATTRIBUTE1, OBLH.ATTRIBUTE2, OBLH.ATTRIBUTE3, OBLH.ATTRIBUTE4, OBLH.ATTRIBUTE5, OBLH.ATTRIBUTE6, OBLH.ATTRIBUTE7, OBLH.ATTRIBUTE8, OBLH.ATTRIBUTE9, OBLH.ATTRIBUTE10, OBLH.ATTRIBUTE11, OBLH.ATTRIBUTE12, OBLH.ATTRIBUTE13, OBLH.ATTRIBUTE14, OBLH.ATTRIBUTE15, OBLH.ATTRIBUTE16, OBLH.ATTRIBUTE17, OBLH.ATTRIBUTE18, OBLH.ATTRIBUTE19, OBLH.ATTRIBUTE20, OBLH.GLOBAL_ATTRIBUTE_CATEGORY, OBLH.GLOBAL_ATTRIBUTE1, OBLH.GLOBAL_ATTRIBUTE2, OBLH.GLOBAL_ATTRIBUTE3, OBLH.GLOBAL_ATTRIBUTE4, OBLH.GLOBAL_ATTRIBUTE5, OBLH.GLOBAL_ATTRIBUTE6, OBLH.GLOBAL_ATTRIBUTE7, OBLH.GLOBAL_ATTRIBUTE8, OBLH.GLOBAL_ATTRIBUTE9, OBLH.GLOBAL_ATTRIBUTE10, OBLH.GLOBAL_ATTRIBUTE11, OBLH.GLOBAL_ATTRIBUTE12, OBLH.GLOBAL_ATTRIBUTE13, OBLH.GLOBAL_ATTRIBUTE14, OBLH.GLOBAL_ATTRIBUTE15, OBLH.GLOBAL_ATTRIBUTE16, OBLH.GLOBAL_ATTRIBUTE17, OBLH.GLOBAL_ATTRIBUTE18, OBLH.GLOBAL_ATTRIBUTE19, OBLH.GLOBAL_ATTRIBUTE20, OBLH.PRICING_CONTEXT, OBLH.PRICING_ATTRIBUTE1, OBLH.PRICING_ATTRIBUTE2, OBLH.PRICING_ATTRIBUTE3, OBLH.PRICING_ATTRIBUTE4, OBLH.PRICING_ATTRIBUTE5, OBLH.PRICING_ATTRIBUTE6, OBLH.PRICING_ATTRIBUTE7, OBLH.PRICING_ATTRIBUTE8, OBLH.PRICING_ATTRIBUTE9, OBLH.PRICING_ATTRIBUTE10, OBLH.INDUSTRY_CONTEXT, OBLH.INDUSTRY_ATTRIBUTE1, OBLH.INDUSTRY_ATTRIBUTE2, OBLH.INDUSTRY_ATTRIBUTE3, OBLH.INDUSTRY_ATTRIBUTE4, OBLH.INDUSTRY_ATTRIBUTE5, OBLH.INDUSTRY_ATTRIBUTE6, OBLH.INDUSTRY_ATTRIBUTE7, OBLH.INDUSTRY_ATTRIBUTE8, OBLH.INDUSTRY_ATTRIBUTE9, OBLH.INDUSTRY_ATTRIBUTE10, OBLH.INDUSTRY_ATTRIBUTE11, OBLH.INDUSTRY_ATTRIBUTE13, OBLH.INDUSTRY_ATTRIBUTE12, OBLH.INDUSTRY_ATTRIBUTE14, OBLH.INDUSTRY_ATTRIBUTE15, OBLH.INDUSTRY_ATTRIBUTE16, OBLH.INDUSTRY_ATTRIBUTE17, OBLH.INDUSTRY_ATTRIBUTE18, OBLH.INDUSTRY_ATTRIBUTE19, OBLH.INDUSTRY_ATTRIBUTE20, OBLH.INDUSTRY_ATTRIBUTE21, OBLH.INDUSTRY_ATTRIBUTE22, OBLH.INDUSTRY_ATTRIBUTE23, OBLH.INDUSTRY_ATTRIBUTE24, OBLH.INDUSTRY_ATTRIBUTE25, OBLH.INDUSTRY_ATTRIBUTE26, OBLH.INDUSTRY_ATTRIBUTE27, OBLH.INDUSTRY_ATTRIBUTE28, OBLH.INDUSTRY_ATTRIBUTE29, OBLH.INDUSTRY_ATTRIBUTE30, OBLH.CREATION_DATE, OBLH.CREATED_BY, OBLH.LAST_UPDATE_DATE, OBLH.LAST_UPDATED_BY, OBLH.LAST_UPDATE_LOGIN, OBLH.PROGRAM_APPLICATION_ID, OBLH.PROGRAM_ID, OBLH.PROGRAM_UPDATE_DATE, OBLH.REQUEST_ID, OBLH.TOP_MODEL_LINE_ID, OBLH.LINK_TO_LINE_ID, OBLH.COMPONENT_SEQUENCE_ID, OBLH.COMPONENT_CODE, OBLH.CONFIG_DISPLAY_SEQUENCE, OBLH.SORT_ORDER, OBLH.ITEM_TYPE_CODE, OBLH.OPTION_NUMBER, OBLH.OPTION_FLAG, OBLH.DEP_PLAN_REQUIRED_FLAG, OBLH.VISIBLE_DEMAND_FLAG, OBLH.LINE_CATEGORY_CODE, OBLH.ACTUAL_SHIPMENT_DATE, OBLH.CUSTOMER_TRX_LINE_ID, OBLH.RETURN_CONTEXT, OBLH.RETURN_ATTRIBUTE1, OBLH.RETURN_ATTRIBUTE2, OBLH.RETURN_ATTRIBUTE3, OBLH.RETURN_ATTRIBUTE4, OBLH.RETURN_ATTRIBUTE5, OBLH.RETURN_ATTRIBUTE6, OBLH.RETURN_ATTRIBUTE7, OBLH.RETURN_ATTRIBUTE8, OBLH.RETURN_ATTRIBUTE9, OBLH.RETURN_ATTRIBUTE10, OBLH.RETURN_ATTRIBUTE11, OBLH.RETURN_ATTRIBUTE12, OBLH.RETURN_ATTRIBUTE13, OBLH.RETURN_ATTRIBUTE14, OBLH.RETURN_ATTRIBUTE15, OBLH.ACTUAL_ARRIVAL_DATE, OBLH.ATO_LINE_ID, OBLH.AUTO_SELECTED_QUANTITY, OBLH.COMPONENT_NUMBER, OBLH.EARLIEST_ACCEPTABLE_DATE, OBLH.EXPLOSION_DATE, OBLH.LATEST_ACCEPTABLE_DATE, OBLH.MODEL_GROUP_NUMBER, OBLH.SCHEDULE_ARRIVAL_DATE, OBLH.SHIP_MODEL_COMPLETE_FLAG, OBLH.SCHEDULE_STATUS_CODE, OBLH.SOURCE_TYPE_CODE, OBLH.CANCELLED_FLAG, OBLH.OPEN_FLAG, OBLH.BOOKED_FLAG, OBLH.SALESREP_ID, OBLH.RETURN_REASON_CODE, OBLH.ARRIVAL_SET_ID, OBLH.SHIP_SET_ID, OBLH.SPLIT_FROM_LINE_ID, OBLH.CUST_PRODUCTION_SEQ_NUM, OBLH.AUTHORIZED_TO_SHIP_FLAG, OBLH.OVER_SHIP_REASON_CODE, OBLH.OVER_SHIP_RESOLVED_FLAG, OBLH.ORDERED_ITEM_ID, OBLH.ITEM_IDENTIFIER_TYPE, OBLH.CONFIGURATION_ID, OBLH.COMMITMENT_ID, OBLH.SHIPPING_INTERFACED_FLAG, OBLH.CREDIT_INVOICE_LINE_ID, OBLH.FIRST_ACK_CODE, OBLH.FIRST_ACK_DATE, OBLH.LAST_ACK_CODE, OBLH.LAST_ACK_DATE, OBLH.PLANNING_PRIORITY, OBLH.ORDER_SOURCE_ID, OBLH.ORIG_SYS_SHIPMENT_REF, OBLH.CHANGE_SEQUENCE, OBLH.DROP_SHIP_FLAG, OBLH.CUSTOMER_LINE_NUMBER, OBLH.CUSTOMER_SHIPMENT_NUMBER, OBLH.CUSTOMER_ITEM_NET_PRICE, OBLH.CUSTOMER_PAYMENT_TERM_ID, OBLH.FULFILLED_FLAG, OBLH.END_ITEM_UNIT_NUMBER, OBLH.CONFIG_HEADER_ID, OBLH.CONFIG_REV_NBR, OBLH.MFG_COMPONENT_SEQUENCE_ID, OBLH.SHIPPING_INSTRUCTIONS, OBLH.PACKING_INSTRUCTIONS, OBLH.INVOICED_QUANTITY, OBLH.REFERENCE_CUSTOMER_TRX_LINE_ID, OBLH.SPLIT_BY, OBLH.LINE_SET_ID, OBLH.SERVICE_TXN_REASON_CODE, OBLH.SERVICE_TXN_COMMENTS, OBLH.SERVICE_DURATION, OBLH.SERVICE_START_DATE, OBLH.SERVICE_END_DATE, OBLH.SERVICE_COTERMINATE_FLAG, OBLH.UNIT_LIST_PERCENT, OBLH.UNIT_SELLING_PERCENT, OBLH.UNIT_PERCENT_BASE_PRICE, OBLH.SERVICE_NUMBER, OBLH.SERVICE_PERIOD, OBLH.SHIPPABLE_FLAG, OBLH.MODEL_REMNANT_FLAG, OBLH.RE_SOURCE_FLAG, OBLH.FLOW_STATUS_CODE, OBLH.TP_CONTEXT, OBLH.TP_ATTRIBUTE1, OBLH.TP_ATTRIBUTE2, OBLH.TP_ATTRIBUTE3, OBLH.TP_ATTRIBUTE4, OBLH.TP_ATTRIBUTE5, OBLH.TP_ATTRIBUTE6, OBLH.TP_ATTRIBUTE7, OBLH.TP_ATTRIBUTE8, OBLH.TP_ATTRIBUTE9, OBLH.TP_ATTRIBUTE10, OBLH.TP_ATTRIBUTE11, OBLH.TP_ATTRIBUTE12, OBLH.TP_ATTRIBUTE13, OBLH.TP_ATTRIBUTE14, OBLH.TP_ATTRIBUTE15, OBLH.FULFILLMENT_METHOD_CODE, to_number(null), /*OBLH.MARKETING_SOURCE_CODE_ID,*/ OBLH.SERVICE_REFERENCE_TYPE_CODE, OBLH.SERVICE_REFERENCE_LINE_ID, OBLH.SERVICE_REFERENCE_SYSTEM_ID, OBLH.CALCULATE_PRICE_FLAG, to_char(null), /*OBLH.UPGRADED_FLAG,*/ OBLH.REVENUE_AMOUNT, OBLH.FULFILLMENT_DATE, OBLH.PREFERRED_GRADE, OBLH.ORDERED_QUANTITY2, OBLH.ORDERED_QUANTITY_UOM2, OBLH.SHIPPING_QUANTITY2, OBLH.CANCELLED_QUANTITY2, OBLH.SHIPPED_QUANTITY2, OBLH.SHIPPING_QUANTITY_UOM2, OBLH.FULFILLED_QUANTITY2, to_number(null), /*OBLH.MFG_LEAD_TIME,*/ to_number(null), /*OBLH.LOCK_CONTROL,*/ OBLH.SUBINVENTORY, OBLH.UNIT_LIST_PRICE_PER_PQTY, OBLH.UNIT_SELLING_PRICE_PER_PQTY, OBLH.PRICE_REQUEST_CODE, OBLH.ORIGINAL_INVENTORY_ITEM_ID, OBLH.ORIGINAL_ORDERED_ITEM_ID, OBLH.ORIGINAL_ORDERED_ITEM, OBLH.ORIGINAL_ITEM_IDENTIFIER_TYPE, OBLH.ITEM_SUBSTITUTION_TYPE_CODE, OBLH.OVERRIDE_ATP_DATE_CODE, OBLH.LATE_DEMAND_PENALTY_FACTOR, OBLH.BLANKET_VERSION_NUMBER, OBLH.VERSION_NUMBER, OBLH.START_DATE_ACTIVE, OBLH.END_DATE_ACTIVE, OBLH.BLANKET_LINE_MAX_AMOUNT, OBLH.BLANKET_LINE_MIN_AMOUNT, OBLH.ENFORCE_PRICE_LIST_FLAG, OBLH.RELEASED_AMOUNT, OBLH.RETURNED_AMOUNT, OBLH.MAX_RELEASE_AMOUNT, OBLH.MIN_RELEASE_AMOUNT, OBLH.BLANKET_MAX_QUANTITY, OBLH.BLANKET_MIN_QUANTITY, OBLH.MAX_RELEASE_QUANTITY, OBLH.MIN_RELEASE_QUANTITY, OBLH.OVERRIDE_RELEASE_CONTROLS_FLAG, OBLH.OVERRIDE_BLANKET_CONTROLS_FLAG, OBLH.FULFILLED_QUANTITY, OBLH.RETURNED_QUANTITY, OBLH.RELEASED_QUANTITY, OBLH.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, LKUP.meaning item_identifier, QGM.description, null unit_of_measure, QLL.operand UNIT_LIST_PRICE, QPA.product_uom_code, OBLH.order_number, OBLH.ENFORCE_SHIP_TO_FLAG, OBLH.ENFORCE_INVOICE_TO_FLAG, OBLH.ENFORCE_FREIGHT_TERM_FLAG, OBLH.ENFORCE_SHIPPING_METHOD_FLAG, OBLH.ENFORCE_PAYMENT_TERM_FLAG, OBLH.ENFORCE_ACCOUNTING_RULE_FLAG, OBLH.ENFORCE_INVOICING_RULE_FLAG, OBLH.FULFILLED_AMOUNT, OBLH.TRANSACTION_PHASE_CODE, OBLH.SOURCE_DOCUMENT_VERSION_NUMBER, OBLH.MODIFIER_LIST_LINE_ID FROM oe_blanket_lines_hist OBLH, 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, MTL_PARAMETERS MTLP, OE_LOOKUPS LKUP WHERE oe_blanket_form_control.include_all_revisions = 'Y' and OBLH.PRICE_LIST_ID = QLHTL.LIST_HEADER_ID(+) and OBLH.AGREEMENT_ID = OEAGR.AGREEMENT_ID(+) and OEAGR.LANGUAGE(+) = USERENV('LANG') and QLHTL.LANGUAGE(+) = USERENV('LANG') and OBLH.ACCOUNTING_RULE_ID = ACCRULE.RULE_ID(+) and OBLH.INVOICING_RULE_ID = INVRULE.RULE_ID(+) and OBLH.PAYMENT_TERM_ID = TERM.Term_Id(+) and TERM.LANGUAGE(+) = USERENV('LANG') and OBLH.PREFERRED_GRADE = QGM.grade_code(+) and OBLH.qp_list_line_id = QLL.list_line_id(+) and OBLH.qp_list_line_id = QPA.list_line_id(+) and OBLH.ITEM_IDENTIFIER_TYPE = LKUP.LOOKUP_CODE(+) and LKUP.LOOKUP_TYPE(+) = 'ITEM_IDENTIFIER_TYPE' and OBLH.SHIP_FROM_ORG_ID = MTLP.ORGANIZATION_ID(+) AND QPA.pricing_attribute_context(+) is null

View Text - HTML Formatted

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