ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4B006AD8E05362FB09051F8B select x.* from ( SELECT * FROM ( SELECT TO_CHAR(QPQ.QUALIFIER_ID) ECC_SPEC_ID , dfv.* ,QPQ.LIST_HEADER_ID LIST_HEADER_ID ,QPQ.LIST_LINE_ID LIST_LINE_ID ,QPQ.QUALIFIER_ID ,DECODE(QPH.LIST_TYPE_CODE,'PRL',QPTL.NAME,'AGR',QPTL.NAME,QPTL.DESCRIPTION) NAME ,QPQ.QUALIFIER_GROUPING_NO ,QP_STAGE.CONTEXT_NAME QUALIFIER_CONTEXT ,QP_STAGE.ATTRIBUTE_NAME QUALIFIER_ATTRIBUTE ,QP_STAGE.ATTRIBUTE_VALUE_NAME QUALIFIER_ATTR_VALUE ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Customer Name',QP_STAGE.ATTRIBUTE_VALUE_NAME) CUSTOMER_NAME ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Customer Class',QP_STAGE.ATTRIBUTE_VALUE_NAME) CUSTOMER_CLASS ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Ship To',QP_STAGE.ATTRIBUTE_VALUE_NAME) SHIP_TO ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Bill To',QP_STAGE.ATTRIBUTE_VALUE_NAME) BILL_TO ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Party ID',QP_STAGE.ATTRIBUTE_VALUE_NAME) PARTY_ID ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Account Type',QP_STAGE.ATTRIBUTE_VALUE_NAME) ACCOUNT_TYPE ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Agreement Name',QP_STAGE.ATTRIBUTE_VALUE_NAME) AGREEMENT_NAME ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Agreement Type',QP_STAGE.ATTRIBUTE_VALUE_NAME) AGREEMENT_TYPE ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Order Type',QP_STAGE.ATTRIBUTE_VALUE_NAME) ORDER_TYPE ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Order Date',QP_STAGE.ATTRIBUTE_VALUE_NAME) ORDER_DATE ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Line Type',QP_STAGE.ATTRIBUTE_VALUE_NAME) LINE_TYPE ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Freight Terms',QP_STAGE.ATTRIBUTE_VALUE_NAME) FREIGHT_TERMS ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Payment Terms',QP_STAGE.ATTRIBUTE_VALUE_NAME) PAYMENT_TERMS ,DECODE(QP_STAGE.ATTRIBUTE_NAME,'Shipping Method',QP_STAGE.ATTRIBUTE_VALUE_NAME) SHIPPING_METHOD ,DECODE (QPQ.ACTIVE_FLAG,'Y','ACTIVE','N','INACTIVE') ACTIVE_FLAG ,DECODE(COMPARISON_OPERATOR_CODE ,'=','EQUAL','NOT =','NOT EQUAL','BETWEEN','BETWEEN') OPERATOR_CODE ,QUALIFIER_PRECEDENCE ,DECODE(QUALIFIER_DATATYPE,'N','Number','C','Character','X','Date','No Datatype') QUALIFIER_DATATYPE ,DECODE (QPQ.LIST_TYPE_CODE,'PRL','Price List', 'CHARGES','Charges', 'DLT','Discounts', 'PRO','Promotional', 'PML','Factors', 'AGR','Agreement Price List', 'SLT','Surcharge', 'DEL','Deal') LIST_TYPE ,QPQ.START_DATE_ACTIVE ,QPQ.END_DATE_ACTIVE ,QPTL.LANGUAGE FROM QP_QUALIFIERS QPQ, QP_ECC_STAGING_TABLE QP_STAGE , QP_LIST_HEADERS_B QPH, QP_LIST_HEADERS_TL QPTL, (select ROW_ID "'QPQ_ROW_ID'",CONTEXT_VALUE "'QPQ_CONTEXT_VALUE'" ,CONCATENATED_SEGMENTS "'QPQ_CONCATENATED_SEGMENTS'" from QP_QUALIFIERS_DFV) dfv WHERE QPQ.QUALIFIER_CONTEXT=QP_STAGE.CONEXT_CODE AND QP_STAGE.ATTRIBUTE_TYPE='QUALIFIER' AND QPQ.QUALIFIER_ATTRIBUTE=QP_STAGE.ATTRIBUTE_CODE AND QPQ.QUALIFIER_ATTR_VALUE=QP_STAGE.ATTRIBUTE_VALUE_ID AND QPQ.LIST_HEADER_ID=QPH.LIST_HEADER_ID AND QPH.LIST_HEADER_ID=QPTL.LIST_HEADER_ID AND QPH.ACTIVE_FLAG='Y' and qpq.rowid=dfv."'QPQ_ROW_ID'"(+) AND QPTL.LANGUAGE in ('US') ) PIVOT ( MAX(NAME) AS NAME FOR LANGUAGE IN ('US' "US")) ) x where 2=2 Y AR ECC التسعير المتقدم, مؤهلات التسعير Imported from Enterprise Command Center Description: مجموعة البيانات التي تحتوي على معلومات حول مؤهلات التسعير Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts D ECC Advanced Pricing, Preisfindungskriterien Imported from Enterprise Command Center Description: DatenSet mit Informationen über Preisfindungskriterien Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts E ECC Advanced Pricing, Cualificadores de Asignación de Precios Imported from Enterprise Command Center Description: Juego de datos con información sobre cualificadores de asignación de precios Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts F ECC Advanced Pricing, Qualificatifs tarification Imported from Enterprise Command Center Description: Jeu de données des informations sur les qualificatifs de tarification Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts I ECC Advanced Pricing, Qualificatori det. prezzi Imported from Enterprise Command Center Description: Serie di dati con informazioni sui qualificatori di determinazione prezzi Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts JA ECC 拡張価格設定, 価格設定クオリファイア Imported from Enterprise Command Center Description: 価格設定クオリファイアに関する情報を保持するデータ・セット Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts KO ECC Advanced Pricing, 가격책정 구분자 Imported from Enterprise Command Center Description: 가격책정 구분자에 대한 정보가 포함되어 있는 데이터 세트입니다. Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts RU ECC Диспетчер цен, Описатели цен Imported from Enterprise Command Center Description: Набор данных, содержащий сведения об описателях цен Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts S ECC Prissättning, Prissättningskvalificerare Imported from Enterprise Command Center Description: Datauppsättning som innehåller information om prissättningskvalificerare Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts TR ECC İleri Fiyatlama, Fiyatlandırma Niteleyicisi Imported from Enterprise Command Center Description: Fiyatlandırma niteleyicileri hakkında bilgi saklayan veri kümesi Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts US ECC Advanced Pricing, Pricing Qualifiers Imported from Enterprise Command Center Description: Data set that holds information about pricing qualifiers Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts ZHS ECC Advanced Pricing, 定价限定词 Imported from Enterprise Command Center Description: 此数据集包含与定价限定词有关的信息 Dataset Key: qp-qualifiers Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: ts Enterprise Command Center