What's new in Customer Journeys?

Connect and learn more! ×
How to SQL Default for a EFF field in shipment line level using the order number ? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to SQL Default for a EFF field in shipment line level using the order number ?

Question
7
Views
0
Comments

Summary:

There is a requirement to default value in the shipment line level additional information. The value needs to be fetched from the sales order line level EFF. I have the below SQL query to fetch the data when i have the order number. How can i pass the respected order number in the particular shipment line:

SELECT dfleb.ATTRIBUTE_CHAR1 FROM DOO_FULFILL_LINES_EFF_B dfleb, DOO_FULFILL_LINES_ALL dfla ,DOO_HEADERS_ALL dha, doo_lines_all dla
where dfla.fulfill_line_id=dfleb.fulfill_line_id 
and dha.header_id=dla.header_id
and dla.line_id=dfla.line_id
and dha.order_number=****
and CONTEXT_CODE='xxxxxxxx'
and dla.line_number=1

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!