Oracle R12 AP

Non PO Based Invoice Count-R12 ap

The below Query will be helpful in fetching NON po based invoices. SELECT HOU.NAME "OU NAME" ,count(DECODE(trim(to_char(AIA.creation_date...

Supplier Contact Query -R12 AP

The below query will be handy to fetch the supplier contact information in Oracle apps R12 -AP SELECT DISTINCT asu.party_id, asu.segment1...