ECC Contract Lifecycle Management, CLM Deliverables, SQL5
Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Supplier Contact ...
Columns: Ecc Spec Id, Supplier Contact ...
Imported from Enterprise Command Center
Dataset Key: po-clm-deliverables
Query Procedure: PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesAwd
Dataset Key: po-clm-deliverables
Query Procedure: PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesAwd
select x.* from ( SELECT gt.char1 ecc_spec_id ,hz.party_name SUPPLIER_CONTACT FROM okc_deliverables del ,po_session_gt gt ,hz_parties hz WHERE del.deliverable_id = gt.num2 AND del.EXTERNAL_PARTY_CONTACT_ID = hz.party_id AND gt.key = 3197934 ) x where 2=2 |