eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OE_BLANKET_HDRS_HIST_V

Source

View Text - Preformatted


SELECT OBHH.ROWID, OBHH.HEADER_ID, OBHH.ORG_ID, OBHH.ORDER_TYPE_ID, OBHH.ORDER_NUMBER, OBHH.VERSION_NUMBER, OBHH.EXPIRATION_DATE, OBHH.ORDER_SOURCE_ID, OBHH.SOURCE_DOCUMENT_TYPE_ID, OBHH.ORIG_SYS_DOCUMENT_REF, OBHH.SOURCE_DOCUMENT_ID, OBHH.ORDERED_DATE, OBHH.REQUEST_DATE, OBHH.PRICING_DATE, OBHH.SHIPMENT_PRIORITY_CODE, OBHH.DEMAND_CLASS_CODE, OBHH.PRICE_LIST_ID, OBHH.TAX_EXEMPT_FLAG, OBHH.TAX_EXEMPT_NUMBER, OBHH.TAX_EXEMPT_REASON_CODE, OBHH.CONVERSION_RATE, OBHH.CONVERSION_TYPE_CODE, OBHH.CONVERSION_RATE_DATE, OBHH.PARTIAL_SHIPMENTS_ALLOWED, OBHH.SHIP_TOLERANCE_ABOVE, OBHH.SHIP_TOLERANCE_BELOW, OBHH.TRANSACTIONAL_CURR_CODE, OBHH.AGREEMENT_ID, OBHH.TAX_POINT_CODE, OBHH.CUST_PO_NUMBER, OBHH.INVOICING_RULE_ID, OBHH.ACCOUNTING_RULE_ID, OBHH.PAYMENT_TERM_ID, OBHH.SHIPPING_METHOD_CODE, OBHH.FREIGHT_CARRIER_CODE, OBHH.FOB_POINT_CODE, OBHH.FREIGHT_TERMS_CODE, OBHH.SOLD_FROM_ORG_ID, OBHH.SOLD_TO_ORG_ID, OBHH.SHIP_FROM_ORG_ID, OBHH.SHIP_TO_ORG_ID, OBHH.INVOICE_TO_ORG_ID, OBHH.DELIVER_TO_ORG_ID, OBHH.SOLD_TO_CONTACT_ID, OBHH.SHIP_TO_CONTACT_ID, OBHH.INVOICE_TO_CONTACT_ID, OBHH.DELIVER_TO_CONTACT_ID, OBHH.CREATION_DATE, OBHH.CREATED_BY, OBHH.LAST_UPDATED_BY, OBHH.LAST_UPDATE_DATE, OBHH.LAST_UPDATE_LOGIN, OBHH.PROGRAM_APPLICATION_ID, OBHH.PROGRAM_ID, OBHH.PROGRAM_UPDATE_DATE, OBHH.REQUEST_ID, OBHH.CONTEXT, OBHH.ATTRIBUTE1, OBHH.ATTRIBUTE2, OBHH.ATTRIBUTE3, OBHH.ATTRIBUTE4, OBHH.ATTRIBUTE5, OBHH.ATTRIBUTE6, OBHH.ATTRIBUTE7, OBHH.ATTRIBUTE8, OBHH.ATTRIBUTE9, OBHH.ATTRIBUTE10, OBHH.ATTRIBUTE11, OBHH.ATTRIBUTE12, OBHH.ATTRIBUTE13, OBHH.ATTRIBUTE14, OBHH.ATTRIBUTE15, OBHH.ATTRIBUTE16, OBHH.ATTRIBUTE17, OBHH.ATTRIBUTE18, OBHH.ATTRIBUTE19, OBHH.ATTRIBUTE20, OBHH.GLOBAL_ATTRIBUTE_CATEGORY, OBHH.GLOBAL_ATTRIBUTE1, OBHH.GLOBAL_ATTRIBUTE2, OBHH.GLOBAL_ATTRIBUTE3, OBHH.GLOBAL_ATTRIBUTE4, OBHH.GLOBAL_ATTRIBUTE5, OBHH.GLOBAL_ATTRIBUTE6, OBHH.GLOBAL_ATTRIBUTE7, OBHH.GLOBAL_ATTRIBUTE8, OBHH.GLOBAL_ATTRIBUTE9, OBHH.GLOBAL_ATTRIBUTE10, OBHH.GLOBAL_ATTRIBUTE11, OBHH.GLOBAL_ATTRIBUTE12, OBHH.GLOBAL_ATTRIBUTE13, OBHH.GLOBAL_ATTRIBUTE14, OBHH.GLOBAL_ATTRIBUTE15, OBHH.GLOBAL_ATTRIBUTE16, OBHH.GLOBAL_ATTRIBUTE17, OBHH.GLOBAL_ATTRIBUTE18, OBHH.GLOBAL_ATTRIBUTE19, OBHH.GLOBAL_ATTRIBUTE20, OBHH.CANCELLED_FLAG, OBHH.OPEN_FLAG, OBHH.BOOKED_FLAG, OBHH.SALESREP_ID, OBHH.RETURN_REASON_CODE, OBHH.ORDER_DATE_TYPE_CODE, OBHH.EARLIEST_SCHEDULE_LIMIT, OBHH.LATEST_SCHEDULE_LIMIT, OBHH.PAYMENT_TYPE_CODE, OBHH.PAYMENT_AMOUNT, OBHH.CHECK_NUMBER, OBHH.CREDIT_CARD_CODE, OBHH.CREDIT_CARD_HOLDER_NAME, OBHH.CREDIT_CARD_NUMBER, OBHH.CREDIT_CARD_EXPIRATION_DATE, OBHH.CREDIT_CARD_APPROVAL_CODE, OBHH.SALES_CHANNEL_CODE, OBHH.FIRST_ACK_CODE, OBHH.FIRST_ACK_DATE, OBHH.LAST_ACK_CODE, OBHH.LAST_ACK_DATE, OBHH.ORDER_CATEGORY_CODE, OBHH.CHANGE_SEQUENCE, null, /*OBHH.DROP_SHIP_FLAG,*/ to_number(null), /*OBHH.CUSTOMER_PAYMENT_TERM_ID, */ OBHH.SHIPPING_INSTRUCTIONS, OBHH.PACKING_INSTRUCTIONS, OBHH.TP_CONTEXT, OBHH.TP_ATTRIBUTE1, OBHH.TP_ATTRIBUTE2, OBHH.TP_ATTRIBUTE3, OBHH.TP_ATTRIBUTE4, OBHH.TP_ATTRIBUTE5, OBHH.TP_ATTRIBUTE6, OBHH.TP_ATTRIBUTE7, OBHH.TP_ATTRIBUTE8, OBHH.TP_ATTRIBUTE9, OBHH.TP_ATTRIBUTE10, OBHH.TP_ATTRIBUTE11, OBHH.TP_ATTRIBUTE12, OBHH.TP_ATTRIBUTE13, OBHH.TP_ATTRIBUTE14, OBHH.TP_ATTRIBUTE15, OBHH.FLOW_STATUS_CODE, OBHH.MARKETING_SOURCE_CODE_ID, OBHH.CREDIT_CARD_APPROVAL_DATE, OBHH.UPGRADED_FLAG, OBHH.CUSTOMER_PREFERENCE_SET_CODE, OBHH.BOOKED_DATE, OBHH.LOCK_CONTROL, OBHH.PRICE_REQUEST_CODE, to_number(NULL), /* batch_id */ to_number(NULL), /* xml_message_id */ OBHH.BLANKET_NUMBER, OBHH.START_DATE_ACTIVE, OBHH.END_DATE_ACTIVE, OBHH.ENFORCE_PRICE_LIST_FLAG, OBHH.RELEASED_AMOUNT, OBHH.REVISION_CHANGE_REASON_CODE, LKUP.meaning revision_reason_code, OBHH.REVISION_CHANGE_COMMENTS, OBHH.ON_HOLD_FLAG, OBHH.BLANKET_MIN_AMOUNT, OBHH.BLANKET_MAX_AMOUNT, OBHH.OVERRIDE_AMOUNT_FLAG, OBHH.RETURNED_AMOUNT, OBHH.REVISION_CHANGE_DATE, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER, ot.name ORDER_TYPE, NULL AGREEMENT, pl.name PRICE_LIST_NAME, accrule.name ACCOUNTING_RULE, invrule.name INVOICING_RULE, term.name TERMS, PARTY.PARTY_NAME SOLD_TO, ship_from_org.organization_code SHIP_FROM, NULL SHIP_FROM_LOCATION, NULL SHIP_FROM_ADDRESS1, NULL SHIP_FROM_ADDRESS2, NULL SHIP_FROM_ADDRESS3, NULL SHIP_FROM_ADDRESS4, sold_party.PERSON_LAST_NAME || DECODE(sold_party.PERSON_FIRST_NAME, NULL, NULL, ', ' || sold_party.PERSON_FIRST_NAME) || DECODE(sold_arl.meaning,NULL, NULL, ' '||sold_arl.meaning) SOLD_TO_CONTACT, OBHH.ENFORCE_SHIP_TO_FLAG, OBHH.ENFORCE_INVOICE_TO_FLAG, OBHH.ENFORCE_FREIGHT_TERM_FLAG, OBHH.ENFORCE_SHIPPING_METHOD_FLAG, OBHH.ENFORCE_PAYMENT_TERM_FLAG, OBHH.ENFORCE_ACCOUNTING_RULE_FLAG, OBHH.ENFORCE_INVOICING_RULE_FLAG, OBHH.FULFILLED_AMOUNT, OBHH.SALES_DOCUMENT_NAME, OBHH.TRANSACTION_PHASE_CODE, OBHH.USER_STATUS_CODE, OBHH.SUPPLIER_SIGNATURE, OBHH.SUPPLIER_SIGNATURE_DATE, OBHH.CUSTOMER_SIGNATURE, OBHH.CUSTOMER_SIGNATURE_DATE, OBHH.SOLD_TO_SITE_USE_ID, OBHH.DRAFT_SUBMITTED_FLAG, OBHH.SOURCE_DOCUMENT_VERSION_NUMBER, OBHH.QUOTE_NUMBER, OBHH.QUOTE_DATE, 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, 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, bill_su.location INVOICE_TO, bill_su.location INVOICE_TO_LOCATION, bill_loc.address1 INVOICE_TO_ADDRESS1, bill_loc.address2 INVOICE_TO_ADDRESS2, bill_loc.address3 INVOICE_TO_ADDRESS3, bill_loc.address4 INVOICE_TO_ADDRESS4, DECODE(bill_loc.city, NULL, NULL, bill_loc.city || ', ') || DECODE(bill_loc.state, NULL, NULL, bill_loc.state || ', ') || DECODE(bill_loc.postal_code, NULL, NULL, bill_loc.postal_code || ', ') || DECODE(bill_loc.country, NULL, NULL, bill_loc.country) INVOICE_TO_ADDRESS5, srep.name SALESREP, obhh.REASON_ID, obhh.AUDIT_FLAG, obhh.VERSION_FLAG, obhh.PHASE_CHANGE_FLAG, obhh.NEW_PRICE_LIST_ID, obhh.NEW_MODIFIER_LIST_ID, obhh.DEFAULT_DISCOUNT_PERCENT, obhh.DEFAULT_DISCOUNT_AMOUNT FROM oe_blanket_headers_hist obhh, mtl_parameters ship_from_org, hz_parties party, hz_cust_accounts cust_acct, ra_terms_tl term, hz_cust_account_roles sold_roles, hz_parties sold_party, hz_cust_accounts sold_acct, hz_relationships sold_rel, ar_lookups sold_arl, fnd_currencies fndcur, oe_transaction_types_tl ot, qp_list_headers_tl pl, ra_rules invrule, ra_rules accrule, OE_LOOKUPS LKUP, 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 bill_su, hz_party_sites bill_ps, hz_locations bill_loc, hz_cust_acct_sites_all bill_cas, ra_salesreps srep, HZ_CUST_SITE_USES_ALL DEL_SU, HZ_LOCATIONS DEL_LOC, HZ_CUST_ACCT_SITES_ALL DEL_CAS, HZ_PARTY_SITES DEL_PS WHERE OBHH.order_type_id = ot.transaction_type_id(+) AND ot.language(+) = userenv('LANG') AND OBHH.price_list_id = pl.list_header_id(+) AND pl.language(+) = userenv('LANG') AND OBHH.invoicing_rule_id = invrule.rule_id(+) AND OBHH.accounting_rule_id = accrule.rule_id(+) AND OBHH.payment_term_id = term.term_id(+) AND TERM.Language(+) = userenv('LANG') AND OBHH.transactional_curr_code = fndcur.currency_code (+) AND OBHH.sold_to_org_id = cust_acct.cust_account_id(+) AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+) AND OBHH.ship_from_org_id = ship_from_org.organization_id (+) AND OBHH.sold_to_contact_id = sold_roles.cust_account_role_id(+) AND sold_roles.party_id = sold_rel.party_id(+) AND sold_roles.role_type(+) = 'CONTACT' AND sold_roles.cust_account_id = sold_acct.cust_account_id(+) AND nvl(sold_rel.object_id,-1) = nvl(sold_acct.party_id,-1) AND sold_rel.subject_id = sold_party.party_id(+) AND sold_arl.lookup_type(+) = 'CONTACT_TITLE' AND sold_arl.lookup_code(+) = sold_party.person_pre_name_adjunct AND OBHH.REVISION_CHANGE_REASON_CODE = LKUP.LOOKUP_CODE(+) AND LKUP.LOOKUP_TYPE(+) = 'BLANKET_REV_REASON_CODE' AND OBHH.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 OBHH.invoice_to_org_id = bill_su.site_use_id(+) AND bill_su.cust_acct_site_id= bill_cas.cust_acct_site_id(+) AND bill_cas.party_site_id = bill_ps.party_site_id(+) AND bill_loc.location_id(+) = bill_ps.location_id AND OBHH.salesrep_id = srep.salesrep_id (+) AND obhh.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

View Text - HTML Formatted

SELECT OBHH.ROWID
, OBHH.HEADER_ID
, OBHH.ORG_ID
, OBHH.ORDER_TYPE_ID
, OBHH.ORDER_NUMBER
, OBHH.VERSION_NUMBER
, OBHH.EXPIRATION_DATE
, OBHH.ORDER_SOURCE_ID
, OBHH.SOURCE_DOCUMENT_TYPE_ID
, OBHH.ORIG_SYS_DOCUMENT_REF
, OBHH.SOURCE_DOCUMENT_ID
, OBHH.ORDERED_DATE
, OBHH.REQUEST_DATE
, OBHH.PRICING_DATE
, OBHH.SHIPMENT_PRIORITY_CODE
, OBHH.DEMAND_CLASS_CODE
, OBHH.PRICE_LIST_ID
, OBHH.TAX_EXEMPT_FLAG
, OBHH.TAX_EXEMPT_NUMBER
, OBHH.TAX_EXEMPT_REASON_CODE
, OBHH.CONVERSION_RATE
, OBHH.CONVERSION_TYPE_CODE
, OBHH.CONVERSION_RATE_DATE
, OBHH.PARTIAL_SHIPMENTS_ALLOWED
, OBHH.SHIP_TOLERANCE_ABOVE
, OBHH.SHIP_TOLERANCE_BELOW
, OBHH.TRANSACTIONAL_CURR_CODE
, OBHH.AGREEMENT_ID
, OBHH.TAX_POINT_CODE
, OBHH.CUST_PO_NUMBER
, OBHH.INVOICING_RULE_ID
, OBHH.ACCOUNTING_RULE_ID
, OBHH.PAYMENT_TERM_ID
, OBHH.SHIPPING_METHOD_CODE
, OBHH.FREIGHT_CARRIER_CODE
, OBHH.FOB_POINT_CODE
, OBHH.FREIGHT_TERMS_CODE
, OBHH.SOLD_FROM_ORG_ID
, OBHH.SOLD_TO_ORG_ID
, OBHH.SHIP_FROM_ORG_ID
, OBHH.SHIP_TO_ORG_ID
, OBHH.INVOICE_TO_ORG_ID
, OBHH.DELIVER_TO_ORG_ID
, OBHH.SOLD_TO_CONTACT_ID
, OBHH.SHIP_TO_CONTACT_ID
, OBHH.INVOICE_TO_CONTACT_ID
, OBHH.DELIVER_TO_CONTACT_ID
, OBHH.CREATION_DATE
, OBHH.CREATED_BY
, OBHH.LAST_UPDATED_BY
, OBHH.LAST_UPDATE_DATE
, OBHH.LAST_UPDATE_LOGIN
, OBHH.PROGRAM_APPLICATION_ID
, OBHH.PROGRAM_ID
, OBHH.PROGRAM_UPDATE_DATE
, OBHH.REQUEST_ID
, OBHH.CONTEXT
, OBHH.ATTRIBUTE1
, OBHH.ATTRIBUTE2
, OBHH.ATTRIBUTE3
, OBHH.ATTRIBUTE4
, OBHH.ATTRIBUTE5
, OBHH.ATTRIBUTE6
, OBHH.ATTRIBUTE7
, OBHH.ATTRIBUTE8
, OBHH.ATTRIBUTE9
, OBHH.ATTRIBUTE10
, OBHH.ATTRIBUTE11
, OBHH.ATTRIBUTE12
, OBHH.ATTRIBUTE13
, OBHH.ATTRIBUTE14
, OBHH.ATTRIBUTE15
, OBHH.ATTRIBUTE16
, OBHH.ATTRIBUTE17
, OBHH.ATTRIBUTE18
, OBHH.ATTRIBUTE19
, OBHH.ATTRIBUTE20
, OBHH.GLOBAL_ATTRIBUTE_CATEGORY
, OBHH.GLOBAL_ATTRIBUTE1
, OBHH.GLOBAL_ATTRIBUTE2
, OBHH.GLOBAL_ATTRIBUTE3
, OBHH.GLOBAL_ATTRIBUTE4
, OBHH.GLOBAL_ATTRIBUTE5
, OBHH.GLOBAL_ATTRIBUTE6
, OBHH.GLOBAL_ATTRIBUTE7
, OBHH.GLOBAL_ATTRIBUTE8
, OBHH.GLOBAL_ATTRIBUTE9
, OBHH.GLOBAL_ATTRIBUTE10
, OBHH.GLOBAL_ATTRIBUTE11
, OBHH.GLOBAL_ATTRIBUTE12
, OBHH.GLOBAL_ATTRIBUTE13
, OBHH.GLOBAL_ATTRIBUTE14
, OBHH.GLOBAL_ATTRIBUTE15
, OBHH.GLOBAL_ATTRIBUTE16
, OBHH.GLOBAL_ATTRIBUTE17
, OBHH.GLOBAL_ATTRIBUTE18
, OBHH.GLOBAL_ATTRIBUTE19
, OBHH.GLOBAL_ATTRIBUTE20
, OBHH.CANCELLED_FLAG
, OBHH.OPEN_FLAG
, OBHH.BOOKED_FLAG
, OBHH.SALESREP_ID
, OBHH.RETURN_REASON_CODE
, OBHH.ORDER_DATE_TYPE_CODE
, OBHH.EARLIEST_SCHEDULE_LIMIT
, OBHH.LATEST_SCHEDULE_LIMIT
, OBHH.PAYMENT_TYPE_CODE
, OBHH.PAYMENT_AMOUNT
, OBHH.CHECK_NUMBER
, OBHH.CREDIT_CARD_CODE
, OBHH.CREDIT_CARD_HOLDER_NAME
, OBHH.CREDIT_CARD_NUMBER
, OBHH.CREDIT_CARD_EXPIRATION_DATE
, OBHH.CREDIT_CARD_APPROVAL_CODE
, OBHH.SALES_CHANNEL_CODE
, OBHH.FIRST_ACK_CODE
, OBHH.FIRST_ACK_DATE
, OBHH.LAST_ACK_CODE
, OBHH.LAST_ACK_DATE
, OBHH.ORDER_CATEGORY_CODE
, OBHH.CHANGE_SEQUENCE
, NULL
, /*OBHH.DROP_SHIP_FLAG
, */ TO_NUMBER(NULL)
, /*OBHH.CUSTOMER_PAYMENT_TERM_ID
, */ OBHH.SHIPPING_INSTRUCTIONS
, OBHH.PACKING_INSTRUCTIONS
, OBHH.TP_CONTEXT
, OBHH.TP_ATTRIBUTE1
, OBHH.TP_ATTRIBUTE2
, OBHH.TP_ATTRIBUTE3
, OBHH.TP_ATTRIBUTE4
, OBHH.TP_ATTRIBUTE5
, OBHH.TP_ATTRIBUTE6
, OBHH.TP_ATTRIBUTE7
, OBHH.TP_ATTRIBUTE8
, OBHH.TP_ATTRIBUTE9
, OBHH.TP_ATTRIBUTE10
, OBHH.TP_ATTRIBUTE11
, OBHH.TP_ATTRIBUTE12
, OBHH.TP_ATTRIBUTE13
, OBHH.TP_ATTRIBUTE14
, OBHH.TP_ATTRIBUTE15
, OBHH.FLOW_STATUS_CODE
, OBHH.MARKETING_SOURCE_CODE_ID
, OBHH.CREDIT_CARD_APPROVAL_DATE
, OBHH.UPGRADED_FLAG
, OBHH.CUSTOMER_PREFERENCE_SET_CODE
, OBHH.BOOKED_DATE
, OBHH.LOCK_CONTROL
, OBHH.PRICE_REQUEST_CODE
, TO_NUMBER(NULL)
, /* BATCH_ID */ TO_NUMBER(NULL)
, /* XML_MESSAGE_ID */ OBHH.BLANKET_NUMBER
, OBHH.START_DATE_ACTIVE
, OBHH.END_DATE_ACTIVE
, OBHH.ENFORCE_PRICE_LIST_FLAG
, OBHH.RELEASED_AMOUNT
, OBHH.REVISION_CHANGE_REASON_CODE
, LKUP.MEANING REVISION_REASON_CODE
, OBHH.REVISION_CHANGE_COMMENTS
, OBHH.ON_HOLD_FLAG
, OBHH.BLANKET_MIN_AMOUNT
, OBHH.BLANKET_MAX_AMOUNT
, OBHH.OVERRIDE_AMOUNT_FLAG
, OBHH.RETURNED_AMOUNT
, OBHH.REVISION_CHANGE_DATE
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
, OT.NAME ORDER_TYPE
, NULL AGREEMENT
, PL.NAME PRICE_LIST_NAME
, ACCRULE.NAME ACCOUNTING_RULE
, INVRULE.NAME INVOICING_RULE
, TERM.NAME TERMS
, PARTY.PARTY_NAME SOLD_TO
, SHIP_FROM_ORG.ORGANIZATION_CODE SHIP_FROM
, NULL SHIP_FROM_LOCATION
, NULL SHIP_FROM_ADDRESS1
, NULL SHIP_FROM_ADDRESS2
, NULL SHIP_FROM_ADDRESS3
, NULL SHIP_FROM_ADDRESS4
, SOLD_PARTY.PERSON_LAST_NAME || DECODE(SOLD_PARTY.PERSON_FIRST_NAME
, NULL
, NULL
, '
, ' || SOLD_PARTY.PERSON_FIRST_NAME) || DECODE(SOLD_ARL.MEANING
, NULL
, NULL
, ' '||SOLD_ARL.MEANING) SOLD_TO_CONTACT
, OBHH.ENFORCE_SHIP_TO_FLAG
, OBHH.ENFORCE_INVOICE_TO_FLAG
, OBHH.ENFORCE_FREIGHT_TERM_FLAG
, OBHH.ENFORCE_SHIPPING_METHOD_FLAG
, OBHH.ENFORCE_PAYMENT_TERM_FLAG
, OBHH.ENFORCE_ACCOUNTING_RULE_FLAG
, OBHH.ENFORCE_INVOICING_RULE_FLAG
, OBHH.FULFILLED_AMOUNT
, OBHH.SALES_DOCUMENT_NAME
, OBHH.TRANSACTION_PHASE_CODE
, OBHH.USER_STATUS_CODE
, OBHH.SUPPLIER_SIGNATURE
, OBHH.SUPPLIER_SIGNATURE_DATE
, OBHH.CUSTOMER_SIGNATURE
, OBHH.CUSTOMER_SIGNATURE_DATE
, OBHH.SOLD_TO_SITE_USE_ID
, OBHH.DRAFT_SUBMITTED_FLAG
, OBHH.SOURCE_DOCUMENT_VERSION_NUMBER
, OBHH.QUOTE_NUMBER
, OBHH.QUOTE_DATE
, 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
, 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
, BILL_SU.LOCATION INVOICE_TO
, BILL_SU.LOCATION INVOICE_TO_LOCATION
, BILL_LOC.ADDRESS1 INVOICE_TO_ADDRESS1
, BILL_LOC.ADDRESS2 INVOICE_TO_ADDRESS2
, BILL_LOC.ADDRESS3 INVOICE_TO_ADDRESS3
, BILL_LOC.ADDRESS4 INVOICE_TO_ADDRESS4
, DECODE(BILL_LOC.CITY
, NULL
, NULL
, BILL_LOC.CITY || '
, ') || DECODE(BILL_LOC.STATE
, NULL
, NULL
, BILL_LOC.STATE || '
, ') || DECODE(BILL_LOC.POSTAL_CODE
, NULL
, NULL
, BILL_LOC.POSTAL_CODE || '
, ') || DECODE(BILL_LOC.COUNTRY
, NULL
, NULL
, BILL_LOC.COUNTRY) INVOICE_TO_ADDRESS5
, SREP.NAME SALESREP
, OBHH.REASON_ID
, OBHH.AUDIT_FLAG
, OBHH.VERSION_FLAG
, OBHH.PHASE_CHANGE_FLAG
, OBHH.NEW_PRICE_LIST_ID
, OBHH.NEW_MODIFIER_LIST_ID
, OBHH.DEFAULT_DISCOUNT_PERCENT
, OBHH.DEFAULT_DISCOUNT_AMOUNT
FROM OE_BLANKET_HEADERS_HIST OBHH
, MTL_PARAMETERS SHIP_FROM_ORG
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, RA_TERMS_TL TERM
, HZ_CUST_ACCOUNT_ROLES SOLD_ROLES
, HZ_PARTIES SOLD_PARTY
, HZ_CUST_ACCOUNTS SOLD_ACCT
, HZ_RELATIONSHIPS SOLD_REL
, AR_LOOKUPS SOLD_ARL
, FND_CURRENCIES FNDCUR
, OE_TRANSACTION_TYPES_TL OT
, QP_LIST_HEADERS_TL PL
, RA_RULES INVRULE
, RA_RULES ACCRULE
, OE_LOOKUPS LKUP
, 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 BILL_SU
, HZ_PARTY_SITES BILL_PS
, HZ_LOCATIONS BILL_LOC
, HZ_CUST_ACCT_SITES_ALL BILL_CAS
, RA_SALESREPS SREP
, HZ_CUST_SITE_USES_ALL DEL_SU
, HZ_LOCATIONS DEL_LOC
, HZ_CUST_ACCT_SITES_ALL DEL_CAS
, HZ_PARTY_SITES DEL_PS
WHERE OBHH.ORDER_TYPE_ID = OT.TRANSACTION_TYPE_ID(+)
AND OT.LANGUAGE(+) = USERENV('LANG')
AND OBHH.PRICE_LIST_ID = PL.LIST_HEADER_ID(+)
AND PL.LANGUAGE(+) = USERENV('LANG')
AND OBHH.INVOICING_RULE_ID = INVRULE.RULE_ID(+)
AND OBHH.ACCOUNTING_RULE_ID = ACCRULE.RULE_ID(+)
AND OBHH.PAYMENT_TERM_ID = TERM.TERM_ID(+)
AND TERM.LANGUAGE(+) = USERENV('LANG')
AND OBHH.TRANSACTIONAL_CURR_CODE = FNDCUR.CURRENCY_CODE (+)
AND OBHH.SOLD_TO_ORG_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND OBHH.SHIP_FROM_ORG_ID = SHIP_FROM_ORG.ORGANIZATION_ID (+)
AND OBHH.SOLD_TO_CONTACT_ID = SOLD_ROLES.CUST_ACCOUNT_ROLE_ID(+)
AND SOLD_ROLES.PARTY_ID = SOLD_REL.PARTY_ID(+)
AND SOLD_ROLES.ROLE_TYPE(+) = 'CONTACT'
AND SOLD_ROLES.CUST_ACCOUNT_ID = SOLD_ACCT.CUST_ACCOUNT_ID(+)
AND NVL(SOLD_REL.OBJECT_ID
, -1) = NVL(SOLD_ACCT.PARTY_ID
, -1)
AND SOLD_REL.SUBJECT_ID = SOLD_PARTY.PARTY_ID(+)
AND SOLD_ARL.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND SOLD_ARL.LOOKUP_CODE(+) = SOLD_PARTY.PERSON_PRE_NAME_ADJUNCT
AND OBHH.REVISION_CHANGE_REASON_CODE = LKUP.LOOKUP_CODE(+)
AND LKUP.LOOKUP_TYPE(+) = 'BLANKET_REV_REASON_CODE'
AND OBHH.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 OBHH.INVOICE_TO_ORG_ID = BILL_SU.SITE_USE_ID(+)
AND BILL_SU.CUST_ACCT_SITE_ID= BILL_CAS.CUST_ACCT_SITE_ID(+)
AND BILL_CAS.PARTY_SITE_ID = BILL_PS.PARTY_SITE_ID(+)
AND BILL_LOC.LOCATION_ID(+) = BILL_PS.LOCATION_ID
AND OBHH.SALESREP_ID = SREP.SALESREP_ID (+)
AND OBHH.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