ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL3
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: po-clm-close-out
Query Procedure: PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesAwd
Dataset Key: po-clm-close-out
Query Procedure: PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesAwd
Run
ECC Contract Lifecycle Management, CLM Closeout Tasks, SQL3 and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( SELECT * FROM ( SELECT gt.char1 ecc_spec_id ,org.name RESPONSIBLE_PARTY_NAME ,org_tl.name INTERNAL_ORGANIZATION ,org_tl.language ,ppf.full_name INTERNAL_CONTACT FROM okc_deliverables del ,po_session_gt gt ,HR_ALL_ORGANIZATION_UNITS_TL org_tl ,HR_ALL_ORGANIZATION_UNITS org ,per_all_people_f ppf WHERE del.deliverable_id = gt.num2 AND del.INTERNAL_PARTY_ID = org.ORGANIZATION_ID AND org.ORGANIZATION_ID = org_tl.ORGANIZATION_ID AND ppf.person_id = del.internal_party_contact_id AND ppf.effective_start_date <= SYSDATE AND (ppf.effective_end_date is NULL OR ppf.effective_end_date> sysdate) AND org_tl.language in ( 'US') AND gt.key = 3218976 ) PIVOT ( max(INTERNAL_ORGANIZATION) as INTERNAL_ORGANIZATION FOR language in ( 'US' "US")) ) x where 2=2 |
Blitz Report™