Oracle eBS經驗分享

/* Formatted on 2010/04/21 11:55 (Formatter Plus v4.8.8) */
SELECT interface_line_id
     , agreement_id
     , comments
     , conversion_date
     , conversion_rate
     , conversion_type
     , credit_method_for_acct_rule
     , credit_method_for_installments
     , currency_code
     , customer_bank_account_id
     , cust_trx_type_id
     , document_number
     , document_number_sequence_id
     , gl_date
     , header_attribute1
     , header_attribute2
     , header_attribute3
     , header_attribute4
     , header_attribute5
     , header_attribute6
     , header_attribute7
     , header_attribute8
     , header_attribute9
     , header_attribute10
     , header_attribute11
     , header_attribute12
     , header_attribute13
     , header_attribute14
     , header_attribute15
     , header_attribute_category
     , initial_customer_trx_id
     , internal_notes
     , invoicing_rule_id
     , orig_system_bill_address_id
     , orig_system_bill_contact_id
     , orig_system_bill_customer_id
     , orig_system_ship_address_id
     , orig_system_ship_contact_id
     , orig_system_ship_customer_id
     , orig_system_sold_customer_id
     , orig_system_batch_name
     , previous_customer_trx_id
     , primary_salesrep_id
     , printing_option
     , purchase_order
     , purchase_order_date
     , purchase_order_revision
     , reason_code
     , receipt_method_id
     , related_customer_trx_id
     , set_of_books_id
     , term_id
     , territory_id
     , trx_date
     , trx_number
     , interface_line_attribute3   -- optional rule
  FROM ra_interface_lines_all
WHERE trx_number = '1828481'