OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » New to BI....Pl Help

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

New to BI....Pl Help [message #142624]

Sun, 16 October 2005 23:40

AndreaDRich
Messages: 17
Registered: September 2005

Junior Member

I am new to BI Can anyone help .....How toVerify who paid checks in AP versus system user(s) related to invoicing distribution. what i am trying to find is:
To Analyze the timing of payments in relation to Purchase Orders (PO) for one particular vendor, linking a specific payment/series of payments to a specific PO.

Report message to a moderator

Re: New to BI....Pl Help [message #142632 is a reply to message #142624]

Mon, 17 October 2005 00:31

manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC

Senior Member

I think you are looking for who created checks.

select user_name from fnd_user where user_id in
(select distinct created_by from ap_checks_all)

Report message to a moderator

Re: New to BI....Pl Help [message #147968 is a reply to message #142632]

Mon, 21 November 2005 23:41

AndreaDRich
Messages: 17
Registered: September 2005

Junior Member

Hi thanks for the reply.what i wanted to query is for a particular PO for a vendor get the payment details like which payment batch had the po details etc.
example: po no:22
vandor:xxx
payment batch:xxx20-50

if i enter po no 22 i need to get the vendor and payment batch details.

hope its clear now,
Thanks,
Andrea.

Report message to a moderator

Previous Topic:	Oracle time and labor with Projects
Next Topic:	Records Stuck in rcv_headers_interface during ASN creation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 19:14:23 CDT 2024