OraFAQ Forum: Other Application Suites » per_qualifications and per_establishment

Home » Applications » Other Application Suites » per_qualifications and per_establishment_attendances

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

per_qualifications and per_establishment_attendances [message #280362]

Tue, 13 November 2007 05:57

archpatil
Messages: 2
Registered: November 2007

Junior Member

Hi,

Can anybody guide me how the two tables are joined
per_qualifications and per_establishment_attendances except attendance_id?

Can there be attendance_id in per_establishment_attendances table which is not associated with any qualification_id of per_qualifications table.

If yes , then what it signifies?

Report message to a moderator

Re: per_qualifications and per_establishment_attendances [message #280368 is a reply to message #280362]

Tue, 13 November 2007 06:04

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

I'm intrigued.

How do you expect us to know how your tables are joined?

If these tables are from one of the Oracle Apps products, do say so, and we'll shift your query over the the appropriate forum.

Otherwise, have a look in USER_CONSTRAINTS for constraints with types of R (Foreign Keys), and look at the constraint specified in R_CONSTRAINT_NAME

Report message to a moderator

Re: per_qualifications and per_establishment_attendances [message #280370 is a reply to message #280368]

Tue, 13 November 2007 06:10

archpatil
Messages: 2
Registered: November 2007

Junior Member

These are oracle standard tables

[Updated on: Tue, 13 November 2007 06:30]

Report message to a moderator

Re: per_qualifications and per_establishment_attendances [message #280379 is a reply to message #280370]

Tue, 13 November 2007 06:32

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Really?

I've never seen them in any database I've used.

They're not part of the Scott/Tiger demo tables, and they're not part of the replacement HR training tables.

Where do they come from?

Report message to a moderator

Re: per_qualifications and per_establishment_attendances [message #280380 is a reply to message #280379]

Tue, 13 November 2007 06:34

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Ahhhh.
Google to the rescue.

They're part of the Oracle Apss HRMS system.

Moving this one to the outer darkness that is the Apps forum.

Report message to a moderator

Re: per_qualifications and per_establishment_attendances [message #287140 is a reply to message #280380]

Tue, 11 December 2007 03:23

lethu
Messages: 2
Registered: December 2005
Location: johhanesburg

Junior Member

hi

you can use ATTENDANCE_ID to link the two table or
next time you can use this query.

select * from all_tab_columns where column_name = 'ATTENDANCE_ID' it's gonna give you the list of table that use the ATTENDANCE_ID.

hope this helps.

Report message to a moderator

Previous Topic:	Item Cross Reference/data base retention/report data
Next Topic:	Item Master File cleansing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 13 03:23:56 CST 2024