OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Finding [Delivery #, Packing Slip #] for a given [Invoice #]

Home » Applications » Oracle Fusion Apps & E-Business Suite » Finding [Delivery #, Packing Slip #] for a given [Invoice #]

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Finding [Delivery #, Packing Slip #] for a given [Invoice #] [message #177634]

Thu, 15 June 2006 19:11

vsr_can
Messages: 3
Registered: June 2006

Junior Member

Hi,
I am trying to write a query to list the Packing Slip and Delivery Numbers for a given set of invoice #'s. What tables in AR and WSH do I join to get the results. Are there any views that I can use to get the results?

For a given Invoice #, I can navigate to different forms in Oracle Applications and find the Delivery # and using the D#, I can get the Packing Slip #. Is there a way to find out from the forms, what table / field names store the Delivery# and Packing Slip #'s ... to make the query writing easier? I am somewhat familiar with ==> Help > Diagnostics > Examine to drill down and get column values.

Thanks.
- Vijay

Report message to a moderator

Previous Topic:	FSG - Row Set
Next Topic:	Embeded Function in Notification Activity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 15 19:51:57 CDT 2024