ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4AFF6AD8E05362FB09051F8BY select x.* from ( SELECT * FROM ( select qpll.* , dfv.* from ( SELECT qpl.rowid row_id,TO_CHAR (QPL.LIST_HEADER_ID)|| '-'|| TO_CHAR(QPL.LIST_LINE_ID) ECC_SPEC_ID ,QPL.LIST_HEADER_ID LIST_HEADER_ID ,DECODE(QPH.LIST_TYPE_CODE,'PRL',QPTL.NAME,'AGR',QPTL.NAME,QPTL.DESCRIPTION) NAME ,QPTL.LANGUAGE ,QPL.LIST_LINE_ID ,(SELECT MEANING FROM QP_LOOKUPS QPLTC WHERE QPLTC.LOOKUP_TYPE = 'LIST_LINE_TYPE_CODE' AND QPLTC.LOOKUP_CODE = QPL.LIST_LINE_TYPE_CODE) LIST_LINE_TYPE_CODE ,QPL.START_DATE_ACTIVE ,QPL.END_DATE_ACTIVE ,DECODE(QPL.AUTOMATIC_FLAG,'Y','Yes','N','No') AUTOMATIC_FLAG ,DECODE(QPH.LIST_TYPE_CODE,'PRL',NULL,(SELECT MEANING FROM QP_LOOKUPS QPLTC WHERE QPLTC.LOOKUP_TYPE = 'MODIFIER_LEVEL_CODE' AND QPLTC.LOOKUP_CODE = QPL.MODIFIER_LEVEL_CODE)) MODIFIER_LEVEL_CODE , nvl(QPL.PRICE_BY_FORMULA_ID,QPL.GENERATE_USING_FORMULA_ID) PRICE_BY_FORMULA_ID ,QPL.LIST_PRICE ,DECODE(QPL.PRIMARY_UOM_FLAG,'Y','Yes','N','No') PRIMARY_UOM_FLAG ,(SELECT MEANING FROM QP_LOOKUPS QPLTC WHERE QPLTC.LOOKUP_TYPE = 'ARITHMETIC_OPERATOR' AND QPLTC.LOOKUP_CODE = QPL.ARITHMETIC_OPERATOR) ARITHMETIC_OPERATOR ,QPL.OPERAND ,DECODE(QPL.OVERRIDE_FLAG,'Y','Yes','N','No') OVERRIDE_FLAG ,QPL.LIST_LINE_NO ,DECODE(QPL.ACCRUAL_FLAG,'Y','Yes','N','No') ACCRUAL_FLAG ,QPL.INCOMPATIBILITY_GRP_CODE ,QPL.PRODUCT_PRECEDENCE ,(SELECT NAME FROM QP_PRICING_PHASES WHERE PRICING_PHASE_ID = QPL.PRICING_PHASE_ID) PRICING_PHASE ,(SELECT NAME FROM QP_PRICE_FORMULAS_VL QPF WHERE QPF.PRICE_FORMULA_ID = nvl(QPL.PRICE_BY_FORMULA_ID,QPL.GENERATE_USING_FORMULA_ID)) PRICE_BY_FORMULA ,DECODE (QPA.PRODUCT_ATTRIBUTE ,'PRICING_ATTRIBUTE1' ,'Item Number' ,'PRICING_ATTRIBUTE2' ,'Item Category' , 'All Items') Product_attribute ,(CASE WHEN QPA.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1' THEN (SELECT MTLV.CONCATENATED_SEGMENTS FROM MTL_SYSTEM_ITEMS_B_KFV MTLV WHERE MTLV.INVENTORY_ITEM_ID = QPA.PRODUCT_ATTR_VALUE AND ROWNUM <2 ) ELSE (CASE WHEN QPA.PRODUCT_ATTRIBUTE ='PRICING_ATTRIBUTE2' THEN (SELECT QPIC.CATEGORY_NAME FROM QP_ITEM_CATEGORIES_V QPIC WHERE QPIC.CATEGORY_ID = QPA.PRODUCT_ATTR_VALUE AND ROWNUM <2) ELSE 'All' END) END) PRODUCT_ATTR_VALUE ,QPL.LAST_UPDATE_DATE ,DECODE(QPL.LIMIT_EXISTS_FLAG,'Y','Yes','N','No') LIMIT_EXISTS_FLAG ,QPA.PRODUCT_UOM_CODE FROM QP_LIST_LINES QPL , QP_PRICING_ATTRIBUTES QPA, QP_LIST_HEADERS_ALL_B QPH, QP_LIST_HEADERS_TL QPTL where QPL.LIST_HEADER_ID=QPA.LIST_HEADER_ID AND QPH.LIST_HEADER_ID=QPTL.LIST_HEADER_ID AND QPL.LIST_LINE_ID=QPA.LIST_LINE_ID and (( QPA.ROWID = ( SELECT QPPR.ROWID FROM QP_PRICING_ATTRIBUTES QPPR WHERE QPA.LIST_LINE_ID = LIST_LINE_ID AND QPA.LIST_HEADER_ID = LIST_HEADER_ID AND PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND PRODUCT_ATTRIBUTE in ('PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE2','PRICING_ATTRIBUTE3') AND ROWNUM < 2 ) )) AND QPH.LIST_HEADER_ID=QPL.LIST_HEADER_ID AND QPH.LIST_TYPE_CODE <> 'PML' AND QPH.ACTIVE_FLAG='Y' UNION ALL SELECT /*+ index(qpl QP_LIST_LINES_N3) */ qpl.rowid row_id, TO_CHAR (QPL.LIST_HEADER_ID)|| '-'|| TO_CHAR(QPL.LIST_LINE_ID) ECC_SPEC_ID ,QPL.LIST_HEADER_ID LIST_HEADER_ID ,DECODE(QPH.LIST_TYPE_CODE,'PRL',QPTL.NAME,'AGR',QPTL.NAME,QPTL.DESCRIPTION) NAME ,QPTL.LANGUAGE ,QPL.LIST_LINE_ID ,(SELECT MEANING FROM QP_LOOKUPS QPLTC WHERE QPLTC.LOOKUP_TYPE = 'LIST_LINE_TYPE_CODE' AND QPLTC.LOOKUP_CODE = QPL.LIST_LINE_TYPE_CODE) LIST_LINE_TYPE_CODE ,QPL.START_DATE_ACTIVE ,QPL.END_DATE_ACTIVE ,DECODE(QPL.AUTOMATIC_FLAG,'Y','Yes','N','No') AUTOMATIC_FLAG ,DECODE(QPH.LIST_TYPE_CODE,'PRL',NULL,(SELECT MEANING FROM QP_LOOKUPS QPLTC WHERE QPLTC.LOOKUP_TYPE = 'MODIFIER_LEVEL_CODE' AND QPLTC.LOOKUP_CODE = QPL.MODIFIER_LEVEL_CODE)) MODIFIER_LEVEL_CODE , nvl(QPL.PRICE_BY_FORMULA_ID,QPL.GENERATE_USING_FORMULA_ID) PRICE_BY_FORMULA_ID ,QPL.LIST_PRICE ,DECODE(QPL.PRIMARY_UOM_FLAG,'Y','Yes','N','No') PRIMARY_UOM_FLAG ,(SELECT MEANING FROM QP_LOOKUPS QPLTC WHERE QPLTC.LOOKUP_TYPE = 'ARITHMETIC_OPERATOR' AND QPLTC.LOOKUP_CODE = QPL.ARITHMETIC_OPERATOR) ARITHMETIC_OPERATOR ,QPL.OPERAND ,DECODE(QPL.OVERRIDE_FLAG,'Y','Yes','N','No') OVERRIDE_FLAG ,QPL.LIST_LINE_NO ,DECODE(QPL.ACCRUAL_FLAG,'Y','Yes','N','No') ACCRUAL_FLAG ,QPL.INCOMPATIBILITY_GRP_CODE ,QPL.PRODUCT_PRECEDENCE ,(SELECT NAME FROM QP_PRICING_PHASES WHERE PRICING_PHASE_ID = QPL.PRICING_PHASE_ID) PRICING_PHASE ,(SELECT NAME FROM QP_PRICE_FORMULAS_VL QPF WHERE QPF.PRICE_FORMULA_ID = nvl(QPL.PRICE_BY_FORMULA_ID,QPL.GENERATE_USING_FORMULA_ID)) PRICE_BY_FORMULA ,NULL Product_attribute ,NULL PRODUCT_ATTR_VALUE ,QPL.LAST_UPDATE_DATE ,DECODE(QPL.LIMIT_EXISTS_FLAG,'Y','Yes','N','No') LIMIT_EXISTS_FLAG ,QPL.PRODUCT_UOM_CODE FROM QP_LIST_LINES QPL ,QP_LIST_HEADERS_ALL_B QPH,QP_LIST_HEADERS_TL QPTL where QPH.LIST_HEADER_ID=QPL.LIST_HEADER_ID and QPH.LIST_HEADER_ID=QPTL.LIST_HEADER_ID AND QPH.LIST_TYPE_CODE <> 'PML' AND QPH.ACTIVE_FLAG='Y' AND QPL.QUALIFICATION_IND In (0,2,8,10) and QPL.LIST_LINE_TYPE_CODE not in ('PLL') )QPLL , (select ROW_ID "'QPL_ROW_ID'",CONTEXT_VALUE "'QPL_CONTEXT_VALUE'" ,CONCATENATED_SEGMENTS "'QPL_CONCATENATED_SEGMENTS'" from QP_LIST_LINES_DFV) dfv where qpll.row_id = dfv."'QPL_ROW_ID'"(+) AND LANGUAGE in ('US') ) PIVOT ( MAX(NAME) AS NAME FOR LANGUAGE IN ('US' "US")) ) x where 2=2 AR ECC التسعير المتقدم, سطور التسعير Imported from Enterprise Command Center Description: مجموعة البيانات التي تحتوي على معلومات حول سطور التسعير Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub D ECC Advanced Pricing, Preispositionen Imported from Enterprise Command Center Description: DatenSet mit Informationen über Preisfindungspositionen Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub E ECC Advanced Pricing, Líneas de Asignación de Precios Imported from Enterprise Command Center Description: Juego de datos con información sobre líneas de asignación de precios Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub F ECC Advanced Pricing, Lignes tarification Imported from Enterprise Command Center Description: Jeu de données des informations sur les lignes de tarification Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub I ECC Advanced Pricing, Linee det. prezzi Imported from Enterprise Command Center Description: Serie di dati con informazioni sulle linee di determinazione prezzi Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub JA ECC 拡張価格設定, 価格設定明細 Imported from Enterprise Command Center Description: 価格設定明細に関する情報を保持するデータ・セット Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub KO ECC Advanced Pricing, 가격책정 라인 Imported from Enterprise Command Center Description: 가격책정 라인에 대한 정보가 포함되어 있는 데이터 세트입니다. Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub RU ECC Диспетчер цен, Строки ценообр. Imported from Enterprise Command Center Description: Набор данных, содержащий сведения о строках ценообразования Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub S ECC Prissättning, Prissättningsrader Imported from Enterprise Command Center Description: Datauppsättning som innehåller information om prissättningsrader Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub TR ECC İleri Fiyatlama, Fiyatlandırma Satırları Imported from Enterprise Command Center Description: Fiyatlandırma satırları hakkında bilgi saklayan veri kümesi Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub US ECC Advanced Pricing, Pricing Lines Imported from Enterprise Command Center Description: Data set that holds information about pricing lines Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub ZHS ECC Advanced Pricing, 定价行 Imported from Enterprise Command Center Description: 此数据集包含与定价行有关的信息 Dataset Key: qp-lines Query Procedure: QP_ECC_UTIL_PVT.GET_ECC_QP_DATA_LOAD_INFO Security Procedure: qp_ecc_datasecurity_pkg_pub Enterprise Command Center