VIEW: APPS.PER_COLL_AGREE_GRADES_V

Source

View Text - Preformatted

SELECT cgs.ROWID, ca.name, ca.business_group_id, fx.id_flex_structure_name, cgs.collective_agreement_id, cgs.CAGR_GRADE_STRUCTURE_id, cgs.ID_FLEX_NUM , cgs.dynamic_insert_allowed , cgs.attribute_category, cgs.ATTRIBUTE1 , cgs.ATTRIBUTE2 , cgs.ATTRIBUTE3 , cgs.ATTRIBUTE4 , cgs.ATTRIBUTE5 , cgs.ATTRIBUTE6 , cgs.ATTRIBUTE7 , cgs.ATTRIBUTE8 , cgs.ATTRIBUTE9 , cgs.ATTRIBUTE10 , cgs.ATTRIBUTE11 , cgs.ATTRIBUTE12 , cgs.ATTRIBUTE13 , cgs.ATTRIBUTE14 , cgs.ATTRIBUTE15 , cgs.ATTRIBUTE16 , cgs.ATTRIBUTE17 , cgs.ATTRIBUTE18 , cgs.ATTRIBUTE19 , cgs.ATTRIBUTE20 , cgs.OBJECT_VERSION_NUMBER, cgs.LAST_UPDATE_DATE , cgs.LAST_UPDATED_BY , cgs.LAST_UPDATE_LOGIN , cgs.CREATED_BY , cgs.CREATION_DATE FROM fnd_id_flex_structures_vl fx, per_collective_agreements ca, per_cagr_grade_structures cgs WHERE cgs.collective_agreement_id = ca.collective_agreement_id AND cgs.id_flex_num = fx.id_flex_num AND fx.id_flex_code= 'CAGR' AND fx.application_id = 800

View Text - HTML Formatted

SELECT CGS.ROWID
, CA.NAME
, CA.BUSINESS_GROUP_ID
, FX.ID_FLEX_STRUCTURE_NAME
, CGS.COLLECTIVE_AGREEMENT_ID
, CGS.CAGR_GRADE_STRUCTURE_ID
, CGS.ID_FLEX_NUM
, CGS.DYNAMIC_INSERT_ALLOWED
, CGS.ATTRIBUTE_CATEGORY
, CGS.ATTRIBUTE1
, CGS.ATTRIBUTE2
, CGS.ATTRIBUTE3
, CGS.ATTRIBUTE4
, CGS.ATTRIBUTE5
, CGS.ATTRIBUTE6
, CGS.ATTRIBUTE7
, CGS.ATTRIBUTE8
, CGS.ATTRIBUTE9
, CGS.ATTRIBUTE10
, CGS.ATTRIBUTE11
, CGS.ATTRIBUTE12
, CGS.ATTRIBUTE13
, CGS.ATTRIBUTE14
, CGS.ATTRIBUTE15
, CGS.ATTRIBUTE16
, CGS.ATTRIBUTE17
, CGS.ATTRIBUTE18
, CGS.ATTRIBUTE19
, CGS.ATTRIBUTE20
, CGS.OBJECT_VERSION_NUMBER
, CGS.LAST_UPDATE_DATE
, CGS.LAST_UPDATED_BY
, CGS.LAST_UPDATE_LOGIN
, CGS.CREATED_BY
, CGS.CREATION_DATE
FROM FND_ID_FLEX_STRUCTURES_VL FX
, PER_COLLECTIVE_AGREEMENTS CA
, PER_CAGR_GRADE_STRUCTURES CGS
WHERE CGS.COLLECTIVE_AGREEMENT_ID = CA.COLLECTIVE_AGREEMENT_ID
AND CGS.ID_FLEX_NUM = FX.ID_FLEX_NUM
AND FX.ID_FLEX_CODE= 'CAGR'
AND FX.APPLICATION_ID = 800