SELECT oha.header_id
, oha.order_number
, ola.line_Id
, ola.ship_from_org_id organization_id
, ola.inventory_item_id
, ola.ordered_quantity
, ola.order_quantity_uom
, ola.line_type_id xx_line_type_id
, aql.order_line_type_id
, ola.request_date
, ola.creation_date
, ola.ship_to_org_id
, ola.sold_to_org_id
,ola.subinventory
FROM aso_quote_headers_all aqh
, aso_quote_lines_all aql
, aso_shipments shp
, oe_order_headers_all oha
, ont.oe_order_lines_all ola
WHERE aqh.quote_header_Id = '"e_header_id'
AND aql.quote_header_id = aqh.quote_header_id
AND shp.quote_header_id = aql.quote_header_id
AND shp.quote_line_id = aql.quote_line_id
AND oha.source_document_id = aqh.quote_header_id
AND ola.header_id = oha.header_id
AND ola.source_document_line_Id = shp.shipment_id ;
, oha.order_number
, ola.line_Id
, ola.ship_from_org_id organization_id
, ola.inventory_item_id
, ola.ordered_quantity
, ola.order_quantity_uom
, ola.line_type_id xx_line_type_id
, aql.order_line_type_id
, ola.request_date
, ola.creation_date
, ola.ship_to_org_id
, ola.sold_to_org_id
,ola.subinventory
FROM aso_quote_headers_all aqh
, aso_quote_lines_all aql
, aso_shipments shp
, oe_order_headers_all oha
, ont.oe_order_lines_all ola
WHERE aqh.quote_header_Id = '"e_header_id'
AND aql.quote_header_id = aqh.quote_header_id
AND shp.quote_header_id = aql.quote_header_id
AND shp.quote_line_id = aql.quote_line_id
AND oha.source_document_id = aqh.quote_header_id
AND ola.header_id = oha.header_id
AND ola.source_document_line_Id = shp.shipment_id ;
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
ReplyDeleteThanks Jennifer
ReplyDeleteI wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post. ordering system
ReplyDeleteThanks for your response my friend.
Delete