CODEWITHSUNDEEP
oracle-databaseoracleapplicationsoracle-ebs
F0cus
F0cus

Reputation: 625

Get the Query for Line Numbers from the Sales Order Form in Oracle EBS

From the Front-end Application, we can see the line number like 1.1 , 2.1, 2.1.1 like this. I only have the value of the line_ids. I would like to get the query for the line numbers in Sales order Form with the use of their line_id values.

Upvotes: 1

Views: 5495

Answers (2)

Andy Haack
Andy Haack

Reputation: 484

The line number could actually include more than just the shipment. This should be complete (from the ONT Order Headers and Lines Blitz Report):

select
rtrim(oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'.'||oola.component_number||'.'||oola.service_number,'.') line_number
from
oe_order_lines_all oola
where
oola.line_id=:line_id

Upvotes: 3

user5713143
user5713143

Reputation: 26

Try this:

select t.LINE_NUMBER || '.' || t.shipment_number line_number 
from oe_order_lines_all t 
WHERE T.HEADER_ID = &header_id;

Upvotes: 1

Related Questions