below is what another person said to me, but it is not logical....please help
where award_number in ('602265','602261','602208')
here are the 'real award_id's
Invoice # 330-436845's invoice_id = 1679270
select award_id from apps.ap_invoice_distributions_v
where invoice_id = 1679270
The award_id stored on the ap_invoice_distributions table isn't the same award_id on the gms_awards_all table.
Remember than report that Belinda wanted updated? And I mentioned in wasn't possible…. And then I tried to explain that maybe it was the 'alloca' thing because in that instant it did look like you could add the award #?...... well… here is really what I wanted to say… and explain.
There are several tables in oracle that will have 'award_id' but the values in some of the tables aren't the 'real award_id.'
I researched it a million years ago and I even think I raised an SR. You can probably get to the bottom of it.
The Oracle Applications & Technology Users Group (OATUG), formerly the Oracle Applications Users Group (OAUG), is the world’s largest education, networking and advocacy forum for Oracle Applications & Technology users.
email@example.com Oracle Applications & Technology Users Group 3525 Piedmont Rd NE Bldg 5, Ste 300 Atlanta, GA 30305-1509 USA (404) 240-0897
Copyright 2020 Oracle Applications & Technology Users Group. | All Rights Reserved. | OATUG PoliciesAll material, files, logos, and trademarks within this site are properties of their respective organizations.