SELECT dha.order_number, dla.line_number, dfl.fulfill_line_id, dfl.status_code FROM doo_headers_all dha JOIN doo_lines_all dla ON dha.header_id = dla.header_id JOIN doo_fulfill_lines_all dfl ON dfl.line_id = dla.line_id WHERE dha.order_number = 'YOUR_ORDER_NUMBER' -- Replace with order number from UI AND dla.line_number = 1 -- Replace with line number from UI ORDER BY dha.order_number, dla.line_number;

In this Post I will outline the steps to call a webservice using SOAP UI. you need below components to get start with . A report Created...

The below Query will be handy while fetching Business unit name in r13 instance. SELECT FUBU.BU_NAME, FUBU.SHORT_CODE, FUBU.STATUS,...

Imported Query : select hp.party_name "Bank Name", cba.bank_account_name, cba.bank_account_num, csh.statement_number, csl.trx_type,...

SELECT psv.vendor_name supplier_name, psv.vendor_id supplier_id, psv.segment1 supplier_number, psv.enabled_flag,...

SELECT i.LOAD_REQUEST_ID, i.INVOICE_ID, i.INVOICE_NUM, i.INVOICE_DATE, i.STATUS, i.SOURCE, i.REQUEST_ID, r.LOAD_REQUEST_ID...

SELECT emp.person_number employee_number, mgr.person_number supervisor_emp_num, --mgr.effective_start_date supervisor_Start_dt...