select ooha.order_number,wdd.source_header_id, source_line_id,oe_flex_util.get_concat_value (oola.line_number,
oola.shipment_number,
oola.option_number,
oola.component_number,
oola.service_number)
line_num, wdd.released_status, wdd.delivery_detail_id, wda.delivery_id , oola.actual_shipment_date, wdd.date_scheduled--,wnd.*
from oe_order_headers_all ooha, oe_order_lines_all oola, wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd
where ooha.header_id = oola.header_id
and oola.line_id = wdd.source_line_id
and wdd.delivery_detail_id = wda.delivery_detail_id
and wda.delivery_id = wnd.delivery_id(+)
and ooha.order_number =52426574
oola.shipment_number,
oola.option_number,
oola.component_number,
oola.service_number)
line_num, wdd.released_status, wdd.delivery_detail_id, wda.delivery_id , oola.actual_shipment_date, wdd.date_scheduled--,wnd.*
from oe_order_headers_all ooha, oe_order_lines_all oola, wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd
where ooha.header_id = oola.header_id
and oola.line_id = wdd.source_line_id
and wdd.delivery_detail_id = wda.delivery_detail_id
and wda.delivery_id = wnd.delivery_id(+)
and ooha.order_number =52426574
and ooha.org_id = 123
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
ReplyDeletePretty section of content. I just stumbled upon your weblog and in accession capital to assert that I get actually enjoyed account your blog posts. Any way I will be subscribing to your augment and even I achievement you access consistently quickly. Slideshare downloader
ReplyDeleteI certainly did not realize that. Learnt something new right now! Thanks for that. this website
ReplyDeleteThere are a few interesting points at some point on this page but I don’t know if these people center to heart. There is certainly some validity but I most certainly will take hold opinion until I take a look at it further. Excellent post , thanks so we want far more! Combined with FeedBurner in addition courier bangalore to usa
ReplyDelete