SELECT ooh.order_number
,ool.line_number
,ool.ordered_item
,ool.ordered_quantity * ool.unit_selling_price
,rct.trx_number invoice_number
,rct.trx_date
,rcta.line_number
,rcta.unit_selling_price
,ooh.org_id
FROM oe_order_headers_all ooh
,oe_order_lines_all ool
,ra_customer_trx_all rct
,ra_customer_trx_lines_all rcta
WHERE ooh.header_id=ool.header_Id
AND rcta.interface_line_attribute1=to_char(ooh.order_number)
AND rcta.interface_line_attribute6=to_char(ool.line_id)
AND rcta.customer_trx_id=rct.customer_trx_id
AND ooh.order_number=nvl(:p_order_number,ooh.order_number)
AND ooh.org_id=nvl(:p_org_id,ooh.org_id)
,ool.line_number
,ool.ordered_item
,ool.ordered_quantity * ool.unit_selling_price
,rct.trx_number invoice_number
,rct.trx_date
,rcta.line_number
,rcta.unit_selling_price
,ooh.org_id
FROM oe_order_headers_all ooh
,oe_order_lines_all ool
,ra_customer_trx_all rct
,ra_customer_trx_lines_all rcta
WHERE ooh.header_id=ool.header_Id
AND rcta.interface_line_attribute1=to_char(ooh.order_number)
AND rcta.interface_line_attribute6=to_char(ool.line_id)
AND rcta.customer_trx_id=rct.customer_trx_id
AND ooh.order_number=nvl(:p_order_number,ooh.order_number)
AND ooh.org_id=nvl(:p_org_id,ooh.org_id)
The Le_Meridian Funding Service went above and beyond their requirements to assist me with my loan which i used expand my pharmacy business,They were friendly, professional, and absolute gems to work with.I will recommend anyone looking for loan to contact. Email..lfdsloans@lemeridianfds.com Or lfdsloans@outlook.com.WhatsApp ... + 19893943740.
ReplyDeleteHalo,I'm Helena Julio from Ecuador,I want to talk good about Le_Meridian Funding Service on this topic.Le_Meridian Funding Service gives me financial support when all bank in my city turned down my request to grant me a loan of 500,000.00 USD, I tried all i could to get a loan from my banks here in Ecuador but they all turned me down because my credit was low but with god grace I came to know about Le_Meridian so I decided to give a try to apply for the loan. with God willing they grant me loan of 500,000.00 USD the loan request that my banks here in Ecuador has turned me down for, it was really awesome doing business with them and my business is going well now. Here is Le_Meridian Funding Investment Email/WhatsApp Contact if you wish to apply loan from them.Email:lfdsloans@lemeridianfds.com / lfdsloans@outlook.comWhatsApp Contact:+1-989-394-3740.
ReplyDelete