VIEW: APPS.PER_COLLECTIVE_AGREEMENTS_V

Source

View Text - Preformatted

SELECT PCA.ROWID, PCA.COLLECTIVE_AGREEMENT_ID, PCA.BUSINESS_GROUP_ID, PCA.OBJECT_VERSION_NUMBER, PCA.NAME, PCA.CAG_NUMBER, PCA.DESCRIPTION, PCA.START_DATE, PCA.END_DATE, PCA.EMPLOYER_ORGANIZATION_ID, HR1.NAME, PCA.EMPLOYER_SIGNATORY, PCA.BARGAINING_ORGANIZATION_ID, HR2.NAME, PCA.BARGAINING_UNIT_SIGNATORY, PCA.JURISDICTION, PCA.AUTHORIZING_BODY, PCA.AUTHORIZED_DATE, PCA.STATUS, PCA.CAG_INFORMATION_CATEGORY, PCA.CAG_INFORMATION1, PCA.CAG_INFORMATION2, PCA.CAG_INFORMATION3, PCA.CAG_INFORMATION4, PCA.CAG_INFORMATION5, PCA.CAG_INFORMATION6, PCA.CAG_INFORMATION7, PCA.CAG_INFORMATION8, PCA.CAG_INFORMATION9, PCA.CAG_INFORMATION10, PCA.CAG_INFORMATION11, PCA.CAG_INFORMATION12, PCA.CAG_INFORMATION13, PCA.CAG_INFORMATION14, PCA.CAG_INFORMATION15, PCA.CAG_INFORMATION16, PCA.CAG_INFORMATION17, PCA.CAG_INFORMATION18, PCA.CAG_INFORMATION19, PCA.CAG_INFORMATION20, PCA.ATTRIBUTE_CATEGORY, PCA.ATTRIBUTE1, PCA.ATTRIBUTE2, PCA.ATTRIBUTE3, PCA.ATTRIBUTE4, PCA.ATTRIBUTE5, PCA.ATTRIBUTE6, PCA.ATTRIBUTE7, PCA.ATTRIBUTE8, PCA.ATTRIBUTE9, PCA.ATTRIBUTE10, PCA.ATTRIBUTE11, PCA.ATTRIBUTE12, PCA.ATTRIBUTE13, PCA.ATTRIBUTE14, PCA.ATTRIBUTE15, PCA.ATTRIBUTE16, PCA.ATTRIBUTE17, PCA.ATTRIBUTE18, PCA.ATTRIBUTE19, PCA.ATTRIBUTE20, PCA.LAST_UPDATE_DATE, PCA.LAST_UPDATED_BY, PCA.LAST_UPDATE_LOGIN, PCA.CREATED_BY, PCA.CREATION_DATE FROM per_collective_agreements PCA, HR_ORGANIZATION_UNITS HR1, HR_ORGANIZATION_UNITS HR2 WHERE (HR1.ORGANIZATION_ID (+) = PCA.EMPLOYER_ORGANIZATION_ID AND HR2.ORGANIZATION_ID (+) = PCA.BARGAINING_ORGANIZATION_ID) AND PCA.START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT PCA.ROWID
, PCA.COLLECTIVE_AGREEMENT_ID
, PCA.BUSINESS_GROUP_ID
, PCA.OBJECT_VERSION_NUMBER
, PCA.NAME
, PCA.CAG_NUMBER
, PCA.DESCRIPTION
, PCA.START_DATE
, PCA.END_DATE
, PCA.EMPLOYER_ORGANIZATION_ID
, HR1.NAME
, PCA.EMPLOYER_SIGNATORY
, PCA.BARGAINING_ORGANIZATION_ID
, HR2.NAME
, PCA.BARGAINING_UNIT_SIGNATORY
, PCA.JURISDICTION
, PCA.AUTHORIZING_BODY
, PCA.AUTHORIZED_DATE
, PCA.STATUS
, PCA.CAG_INFORMATION_CATEGORY
, PCA.CAG_INFORMATION1
, PCA.CAG_INFORMATION2
, PCA.CAG_INFORMATION3
, PCA.CAG_INFORMATION4
, PCA.CAG_INFORMATION5
, PCA.CAG_INFORMATION6
, PCA.CAG_INFORMATION7
, PCA.CAG_INFORMATION8
, PCA.CAG_INFORMATION9
, PCA.CAG_INFORMATION10
, PCA.CAG_INFORMATION11
, PCA.CAG_INFORMATION12
, PCA.CAG_INFORMATION13
, PCA.CAG_INFORMATION14
, PCA.CAG_INFORMATION15
, PCA.CAG_INFORMATION16
, PCA.CAG_INFORMATION17
, PCA.CAG_INFORMATION18
, PCA.CAG_INFORMATION19
, PCA.CAG_INFORMATION20
, PCA.ATTRIBUTE_CATEGORY
, PCA.ATTRIBUTE1
, PCA.ATTRIBUTE2
, PCA.ATTRIBUTE3
, PCA.ATTRIBUTE4
, PCA.ATTRIBUTE5
, PCA.ATTRIBUTE6
, PCA.ATTRIBUTE7
, PCA.ATTRIBUTE8
, PCA.ATTRIBUTE9
, PCA.ATTRIBUTE10
, PCA.ATTRIBUTE11
, PCA.ATTRIBUTE12
, PCA.ATTRIBUTE13
, PCA.ATTRIBUTE14
, PCA.ATTRIBUTE15
, PCA.ATTRIBUTE16
, PCA.ATTRIBUTE17
, PCA.ATTRIBUTE18
, PCA.ATTRIBUTE19
, PCA.ATTRIBUTE20
, PCA.LAST_UPDATE_DATE
, PCA.LAST_UPDATED_BY
, PCA.LAST_UPDATE_LOGIN
, PCA.CREATED_BY
, PCA.CREATION_DATE
FROM PER_COLLECTIVE_AGREEMENTS PCA
, HR_ORGANIZATION_UNITS HR1
, HR_ORGANIZATION_UNITS HR2
WHERE (HR1.ORGANIZATION_ID (+) = PCA.EMPLOYER_ORGANIZATION_ID
AND HR2.ORGANIZATION_ID (+) = PCA.BARGAINING_ORGANIZATION_ID)
AND PCA.START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))