VIEW: APPS.OE_AK_ORDER_HEADERS_V

Source

View Text - Preformatted

SELECT /* using this conversion so that accounting_rule_id on the view is of type number and not number(15) as in oe_order_headers_all*/ to_number(to_char(oehdr.accounting_rule_id)) , to_number(to_char(oehdr.accounting_rule_duration)) , oehdr.agreement_id , oehdr.attribute1 , oehdr.attribute10 , oehdr.attribute11 , oehdr.attribute12 , oehdr.attribute13 , oehdr.attribute14 , oehdr.attribute15 , oehdr.attribute16 , oehdr.attribute17 , oehdr.attribute18 , oehdr.attribute19 , oehdr.attribute2 , oehdr.attribute20 , oehdr.attribute3 , oehdr.attribute4 , oehdr.attribute5 , oehdr.attribute6 , oehdr.attribute7 , oehdr.attribute8 , oehdr.attribute9 , oehdr.Booked_flag , oehdr.booked_date , oehdr.cancelled_flag , oehdr.context , oehdr.conversion_rate , oehdr.conversion_rate_date , oehdr.conversion_type_code , oehdr.created_by , oehdr.creation_date , oehdr.cust_po_number , oehdr.deliver_to_contact_id , oehdr.deliver_to_org_id , oehdr.demand_class_code , oehdr.expiration_date , oehdr.earliest_schedule_limit , oehdr.fob_point_code , oehdr.freight_carrier_code , oehdr.freight_terms_code , oehdr.global_attribute1 , oehdr.global_attribute10 , oehdr.global_attribute11 , oehdr.global_attribute12 , oehdr.global_attribute13 , oehdr.global_attribute14 , oehdr.global_attribute15 , oehdr.global_attribute16 , oehdr.global_attribute17 , oehdr.global_attribute18 , oehdr.global_attribute19 , oehdr.global_attribute2 , oehdr.global_attribute20 , oehdr.global_attribute3 , oehdr.global_attribute4 , oehdr.global_attribute5 , oehdr.global_attribute6 , oehdr.global_attribute7 , oehdr.global_attribute8 , oehdr.global_attribute9 , oehdr.global_attribute_category , oehdr.header_id , oehdr.invoice_to_contact_id , oehdr.invoice_to_org_id /*using this conversion so that invoicing_rule_id on the view is of type number and not number(15) as in oe_order_headers_all*/ , to_number(to_char(oehdr.invoicing_rule_id)) , oehdr.last_updated_by , oehdr.last_update_date , oehdr.last_update_login , oehdr.latest_schedule_limit , oehdr.open_flag , oehdr.ordered_date , oehdr.order_date_type_code , oehdr.order_number , oehdr.order_source_id , oehdr.order_type_id , oehdr.org_id , oehdr.orig_sys_document_ref , oehdr.order_category_code , oehdr.partial_shipments_allowed /*using this conversion so that payment_term_id on the view is of type number and not number(15) as in oe_order_headers_all*/ , to_number(to_char(oehdr.payment_term_id)) , oehdr.price_list_id , oehdr.price_request_code , oehdr.pricing_date , oehdr.program_application_id , oehdr.program_id , oehdr.program_update_date , oehdr.request_date , oehdr.request_id , oehdr.return_reason_code /* using this conversion so that salesrep_id on the view is of type number and not number(15) as in oe_order_headers_all*/ , to_number(to_char(oehdr.salesrep_id)) , oehdr.sales_channel_code , oehdr.shipment_priority_code , oehdr.shipping_method_code , oehdr.ship_from_org_id , oehdr.ship_tolerance_above , oehdr.ship_tolerance_below , oehdr.ship_to_contact_id , oehdr.ship_to_org_id , oehdr.sold_from_org_id , oehdr.sold_to_contact_id , oehdr.sold_to_org_id , oehdr.sold_to_phone_id , oehdr.source_document_id , oehdr.source_document_type_id , oehdr.tax_exempt_flag , oehdr.tax_exempt_number , oehdr.tax_exempt_reason_code , oehdr.tax_point_code , oehdr.transactional_curr_code , oehdr.version_number , rpad('X',1,'-') , rpad('T',1,'-') , rpad('X',30,'-') , rpad('X',30,'-') , rpad('X',32000,'-') , oehdr.payment_type_code , oehdr.payment_amount , oehdr.check_number , oehdr.credit_card_code , oehdr.credit_card_holder_name , oehdr.credit_card_number , oehdr.credit_card_expiration_date , oehdr.credit_card_approval_date , oehdr.credit_card_approval_code , oehdr.shipping_instructions , oehdr.packing_instructions , oehdr.first_ack_code , oehdr.first_ack_date , oehdr.last_ack_code , oehdr.last_ack_date , ordtyp.default_inbound_line_type_id , ordtyp.default_outbound_line_type_id , oehdr.flow_status_code , oehdr.Customer_preference_set_code , oehdr.tp_attribute1 , oehdr.tp_attribute10 , oehdr.tp_attribute11 , oehdr.tp_attribute12 , oehdr.tp_attribute13 , oehdr.tp_attribute14 , oehdr.tp_attribute15 , oehdr.tp_attribute2 , oehdr.tp_attribute3 , oehdr.tp_attribute4 , oehdr.tp_attribute5 , oehdr.tp_attribute6 , oehdr.tp_attribute7 , oehdr.tp_attribute8 , oehdr.tp_attribute9 , oehdr.tp_context , oehdr.upgraded_flag , oehdr.blanket_number , oehdr.DEFAULT_FULFILLMENT_SET , oehdr.LINE_SET_NAME , oehdr.FULFILLMENT_SET_NAME , oehdr.quote_date , oehdr.quote_number , oehdr.sales_document_name , oehdr.transaction_phase_code , oehdr.user_status_code , oehdr.draft_submitted_flag , oehdr.source_document_version_number , oehdr.sold_to_site_use_id , oehdr.supplier_signature , oehdr.supplier_signature_date , oehdr.customer_signature , oehdr.customer_signature_date , oehdr.end_customer_id , oehdr.end_customer_contact_id , oehdr.end_customer_site_use_id , oehdr.ib_owner , oehdr.ib_current_location , oehdr.ib_installed_at_location , 1 ,oehdr.ORDER_FIRMED_DATE , party.party_type FROM OE_ORDER_HEADERS_ALL oehdr, oe_order_types_v ordtyp, hz_cust_accounts cust_acct, hz_parties party where oehdr.order_type_id = ordtyp.order_type_id and oehdr.sold_to_org_id = cust_acct.cust_account_id(+) and cust_acct.party_id = party.party_id(+)

View Text - HTML Formatted

SELECT /* USING THIS CONVERSION SO THAT ACCOUNTING_RULE_ID ON THE VIEW IS OF TYPE NUMBER
AND NOT NUMBER(15) AS IN OE_ORDER_HEADERS_ALL*/ TO_NUMBER(TO_CHAR(OEHDR.ACCOUNTING_RULE_ID))
, TO_NUMBER(TO_CHAR(OEHDR.ACCOUNTING_RULE_DURATION))
, OEHDR.AGREEMENT_ID
, OEHDR.ATTRIBUTE1
, OEHDR.ATTRIBUTE10
, OEHDR.ATTRIBUTE11
, OEHDR.ATTRIBUTE12
, OEHDR.ATTRIBUTE13
, OEHDR.ATTRIBUTE14
, OEHDR.ATTRIBUTE15
, OEHDR.ATTRIBUTE16
, OEHDR.ATTRIBUTE17
, OEHDR.ATTRIBUTE18
, OEHDR.ATTRIBUTE19
, OEHDR.ATTRIBUTE2
, OEHDR.ATTRIBUTE20
, OEHDR.ATTRIBUTE3
, OEHDR.ATTRIBUTE4
, OEHDR.ATTRIBUTE5
, OEHDR.ATTRIBUTE6
, OEHDR.ATTRIBUTE7
, OEHDR.ATTRIBUTE8
, OEHDR.ATTRIBUTE9
, OEHDR.BOOKED_FLAG
, OEHDR.BOOKED_DATE
, OEHDR.CANCELLED_FLAG
, OEHDR.CONTEXT
, OEHDR.CONVERSION_RATE
, OEHDR.CONVERSION_RATE_DATE
, OEHDR.CONVERSION_TYPE_CODE
, OEHDR.CREATED_BY
, OEHDR.CREATION_DATE
, OEHDR.CUST_PO_NUMBER
, OEHDR.DELIVER_TO_CONTACT_ID
, OEHDR.DELIVER_TO_ORG_ID
, OEHDR.DEMAND_CLASS_CODE
, OEHDR.EXPIRATION_DATE
, OEHDR.EARLIEST_SCHEDULE_LIMIT
, OEHDR.FOB_POINT_CODE
, OEHDR.FREIGHT_CARRIER_CODE
, OEHDR.FREIGHT_TERMS_CODE
, OEHDR.GLOBAL_ATTRIBUTE1
, OEHDR.GLOBAL_ATTRIBUTE10
, OEHDR.GLOBAL_ATTRIBUTE11
, OEHDR.GLOBAL_ATTRIBUTE12
, OEHDR.GLOBAL_ATTRIBUTE13
, OEHDR.GLOBAL_ATTRIBUTE14
, OEHDR.GLOBAL_ATTRIBUTE15
, OEHDR.GLOBAL_ATTRIBUTE16
, OEHDR.GLOBAL_ATTRIBUTE17
, OEHDR.GLOBAL_ATTRIBUTE18
, OEHDR.GLOBAL_ATTRIBUTE19
, OEHDR.GLOBAL_ATTRIBUTE2
, OEHDR.GLOBAL_ATTRIBUTE20
, OEHDR.GLOBAL_ATTRIBUTE3
, OEHDR.GLOBAL_ATTRIBUTE4
, OEHDR.GLOBAL_ATTRIBUTE5
, OEHDR.GLOBAL_ATTRIBUTE6
, OEHDR.GLOBAL_ATTRIBUTE7
, OEHDR.GLOBAL_ATTRIBUTE8
, OEHDR.GLOBAL_ATTRIBUTE9
, OEHDR.GLOBAL_ATTRIBUTE_CATEGORY
, OEHDR.HEADER_ID
, OEHDR.INVOICE_TO_CONTACT_ID
, OEHDR.INVOICE_TO_ORG_ID /*USING THIS CONVERSION SO THAT INVOICING_RULE_ID ON THE VIEW IS OF TYPE NUMBER
AND NOT NUMBER(15) AS IN OE_ORDER_HEADERS_ALL*/
, TO_NUMBER(TO_CHAR(OEHDR.INVOICING_RULE_ID))
, OEHDR.LAST_UPDATED_BY
, OEHDR.LAST_UPDATE_DATE
, OEHDR.LAST_UPDATE_LOGIN
, OEHDR.LATEST_SCHEDULE_LIMIT
, OEHDR.OPEN_FLAG
, OEHDR.ORDERED_DATE
, OEHDR.ORDER_DATE_TYPE_CODE
, OEHDR.ORDER_NUMBER
, OEHDR.ORDER_SOURCE_ID
, OEHDR.ORDER_TYPE_ID
, OEHDR.ORG_ID
, OEHDR.ORIG_SYS_DOCUMENT_REF
, OEHDR.ORDER_CATEGORY_CODE
, OEHDR.PARTIAL_SHIPMENTS_ALLOWED /*USING THIS CONVERSION SO THAT PAYMENT_TERM_ID ON THE VIEW IS OF TYPE NUMBER
AND NOT NUMBER(15) AS IN OE_ORDER_HEADERS_ALL*/
, TO_NUMBER(TO_CHAR(OEHDR.PAYMENT_TERM_ID))
, OEHDR.PRICE_LIST_ID
, OEHDR.PRICE_REQUEST_CODE
, OEHDR.PRICING_DATE
, OEHDR.PROGRAM_APPLICATION_ID
, OEHDR.PROGRAM_ID
, OEHDR.PROGRAM_UPDATE_DATE
, OEHDR.REQUEST_DATE
, OEHDR.REQUEST_ID
, OEHDR.RETURN_REASON_CODE /* USING THIS CONVERSION SO THAT SALESREP_ID ON THE VIEW IS OF TYPE NUMBER
AND NOT NUMBER(15) AS IN OE_ORDER_HEADERS_ALL*/
, TO_NUMBER(TO_CHAR(OEHDR.SALESREP_ID))
, OEHDR.SALES_CHANNEL_CODE
, OEHDR.SHIPMENT_PRIORITY_CODE
, OEHDR.SHIPPING_METHOD_CODE
, OEHDR.SHIP_FROM_ORG_ID
, OEHDR.SHIP_TOLERANCE_ABOVE
, OEHDR.SHIP_TOLERANCE_BELOW
, OEHDR.SHIP_TO_CONTACT_ID
, OEHDR.SHIP_TO_ORG_ID
, OEHDR.SOLD_FROM_ORG_ID
, OEHDR.SOLD_TO_CONTACT_ID
, OEHDR.SOLD_TO_ORG_ID
, OEHDR.SOLD_TO_PHONE_ID
, OEHDR.SOURCE_DOCUMENT_ID
, OEHDR.SOURCE_DOCUMENT_TYPE_ID
, OEHDR.TAX_EXEMPT_FLAG
, OEHDR.TAX_EXEMPT_NUMBER
, OEHDR.TAX_EXEMPT_REASON_CODE
, OEHDR.TAX_POINT_CODE
, OEHDR.TRANSACTIONAL_CURR_CODE
, OEHDR.VERSION_NUMBER
, RPAD('X'
, 1
, '-')
, RPAD('T'
, 1
, '-')
, RPAD('X'
, 30
, '-')
, RPAD('X'
, 30
, '-')
, RPAD('X'
, 32000
, '-')
, OEHDR.PAYMENT_TYPE_CODE
, OEHDR.PAYMENT_AMOUNT
, OEHDR.CHECK_NUMBER
, OEHDR.CREDIT_CARD_CODE
, OEHDR.CREDIT_CARD_HOLDER_NAME
, OEHDR.CREDIT_CARD_NUMBER
, OEHDR.CREDIT_CARD_EXPIRATION_DATE
, OEHDR.CREDIT_CARD_APPROVAL_DATE
, OEHDR.CREDIT_CARD_APPROVAL_CODE
, OEHDR.SHIPPING_INSTRUCTIONS
, OEHDR.PACKING_INSTRUCTIONS
, OEHDR.FIRST_ACK_CODE
, OEHDR.FIRST_ACK_DATE
, OEHDR.LAST_ACK_CODE
, OEHDR.LAST_ACK_DATE
, ORDTYP.DEFAULT_INBOUND_LINE_TYPE_ID
, ORDTYP.DEFAULT_OUTBOUND_LINE_TYPE_ID
, OEHDR.FLOW_STATUS_CODE
, OEHDR.CUSTOMER_PREFERENCE_SET_CODE
, OEHDR.TP_ATTRIBUTE1
, OEHDR.TP_ATTRIBUTE10
, OEHDR.TP_ATTRIBUTE11
, OEHDR.TP_ATTRIBUTE12
, OEHDR.TP_ATTRIBUTE13
, OEHDR.TP_ATTRIBUTE14
, OEHDR.TP_ATTRIBUTE15
, OEHDR.TP_ATTRIBUTE2
, OEHDR.TP_ATTRIBUTE3
, OEHDR.TP_ATTRIBUTE4
, OEHDR.TP_ATTRIBUTE5
, OEHDR.TP_ATTRIBUTE6
, OEHDR.TP_ATTRIBUTE7
, OEHDR.TP_ATTRIBUTE8
, OEHDR.TP_ATTRIBUTE9
, OEHDR.TP_CONTEXT
, OEHDR.UPGRADED_FLAG
, OEHDR.BLANKET_NUMBER
, OEHDR.DEFAULT_FULFILLMENT_SET
, OEHDR.LINE_SET_NAME
, OEHDR.FULFILLMENT_SET_NAME
, OEHDR.QUOTE_DATE
, OEHDR.QUOTE_NUMBER
, OEHDR.SALES_DOCUMENT_NAME
, OEHDR.TRANSACTION_PHASE_CODE
, OEHDR.USER_STATUS_CODE
, OEHDR.DRAFT_SUBMITTED_FLAG
, OEHDR.SOURCE_DOCUMENT_VERSION_NUMBER
, OEHDR.SOLD_TO_SITE_USE_ID
, OEHDR.SUPPLIER_SIGNATURE
, OEHDR.SUPPLIER_SIGNATURE_DATE
, OEHDR.CUSTOMER_SIGNATURE
, OEHDR.CUSTOMER_SIGNATURE_DATE
, OEHDR.END_CUSTOMER_ID
, OEHDR.END_CUSTOMER_CONTACT_ID
, OEHDR.END_CUSTOMER_SITE_USE_ID
, OEHDR.IB_OWNER
, OEHDR.IB_CURRENT_LOCATION
, OEHDR.IB_INSTALLED_AT_LOCATION
, 1
, OEHDR.ORDER_FIRMED_DATE
, PARTY.PARTY_TYPE
FROM OE_ORDER_HEADERS_ALL OEHDR
, OE_ORDER_TYPES_V ORDTYP
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
WHERE OEHDR.ORDER_TYPE_ID = ORDTYP.ORDER_TYPE_ID
AND OEHDR.SOLD_TO_ORG_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)