VIEW: APPS.BEN_COPY_ENTITY_TXNS_VW

Source

View Text - Preformatted

SELECT cet.copy_entity_txn_id , cet.action_date , cet.context , cet.transaction_category_id , cet.src_effective_date , cet.txn_category_attribute_id , cet.display_name , cet.replacement_type_cd , cet.start_with , cet.increment_by , cet.number_of_copies , cet.status , cet.object_version_number , cet.last_update_date , cet.last_updated_by , cet.last_update_login , cet.created_by , cet.creation_date , cet.context_business_group_id , cet.datetrack_mode , cet.wf_transaction_category_id , cea.copy_entity_attrib_id , cea.row_type_cd , cea.information_category , cea.information1 , cea.information2 , cea.information3 , cea.information4 , cea.information5 , cea.information6 , cea.information7 , cea.information8 , cea.information9 , cea.information10 , cea.information11 , cea.information12 , cea.information13 , cea.information14 , cea.information15 , cea.information16 , cea.information17 , cea.information18 , cea.information19 , cea.information20 , cea.information21 , cea.information22 , cea.information23 , cea.information24 , cea.information25 , cea.information26 , cea.information27 , cea.information28 , cea.information29 , cea.information30 , cea.object_version_number from pqh_copy_entity_txns cet, pqh_copy_entity_attribs cea WHERE cet.copy_entity_txn_id = cea.copy_entity_txn_id

View Text - HTML Formatted

SELECT CET.COPY_ENTITY_TXN_ID
, CET.ACTION_DATE
, CET.CONTEXT
, CET.TRANSACTION_CATEGORY_ID
, CET.SRC_EFFECTIVE_DATE
, CET.TXN_CATEGORY_ATTRIBUTE_ID
, CET.DISPLAY_NAME
, CET.REPLACEMENT_TYPE_CD
, CET.START_WITH
, CET.INCREMENT_BY
, CET.NUMBER_OF_COPIES
, CET.STATUS
, CET.OBJECT_VERSION_NUMBER
, CET.LAST_UPDATE_DATE
, CET.LAST_UPDATED_BY
, CET.LAST_UPDATE_LOGIN
, CET.CREATED_BY
, CET.CREATION_DATE
, CET.CONTEXT_BUSINESS_GROUP_ID
, CET.DATETRACK_MODE
, CET.WF_TRANSACTION_CATEGORY_ID
, CEA.COPY_ENTITY_ATTRIB_ID
, CEA.ROW_TYPE_CD
, CEA.INFORMATION_CATEGORY
, CEA.INFORMATION1
, CEA.INFORMATION2
, CEA.INFORMATION3
, CEA.INFORMATION4
, CEA.INFORMATION5
, CEA.INFORMATION6
, CEA.INFORMATION7
, CEA.INFORMATION8
, CEA.INFORMATION9
, CEA.INFORMATION10
, CEA.INFORMATION11
, CEA.INFORMATION12
, CEA.INFORMATION13
, CEA.INFORMATION14
, CEA.INFORMATION15
, CEA.INFORMATION16
, CEA.INFORMATION17
, CEA.INFORMATION18
, CEA.INFORMATION19
, CEA.INFORMATION20
, CEA.INFORMATION21
, CEA.INFORMATION22
, CEA.INFORMATION23
, CEA.INFORMATION24
, CEA.INFORMATION25
, CEA.INFORMATION26
, CEA.INFORMATION27
, CEA.INFORMATION28
, CEA.INFORMATION29
, CEA.INFORMATION30
, CEA.OBJECT_VERSION_NUMBER
FROM PQH_COPY_ENTITY_TXNS CET
, PQH_COPY_ENTITY_ATTRIBS CEA
WHERE CET.COPY_ENTITY_TXN_ID = CEA.COPY_ENTITY_TXN_ID