|
SELECT A.DP_PUBLISHNAME , A.DP_PUBLISH_DATE , A.DP_FORECASTITEM , A.DP_FCITEMCAPTION , A.DP_CONTROLGROUP , A.DP_UPDATETOINVPOL , A.DP_BASEUOM , A.DP_PUBLISHUOM , A.DP_STDUOMCONVFACT , A.DP_WEIGHT , A.DP_WEIGHTUOM , A.DP_VOLUME , A.DP_VOLUMEUOM , A.DP_CONVFACTOR , A.DP_STANDARDCOST , A.DP_STANDARDPRICE , A.UTILIZ_CD , A.UTILIZ_GROUP , A.DP_FORECASTANALYST , A.DP_EFFDEMANDPDS , A.DP_HISTDEMANDPDS , A.DP_ADJFOREDEV , A.DP_STATFOREDEV , A.DP_PRORATEDFOREDEV , A.DP_FC_EFFPD , A.DP_FC_EFFYR , A.DP_FCMETHOD , A.DP_LIFEPROFILEITEM , A.DP_NEXTFCITEM , A.DP_PERIODCREATED , A.DP_YEARCREATED , A.DP_PRORATE , A.DP_SEASONALITYPROF , A.DP_SUSPENDEDITEM , A.DP_TEMPLATEITEM , A.BILL_TO_CUST_ID , A.BUSINESS_UNIT_BI , A.BUSINESS_UNIT_IN , A.BUSINESS_UNIT_OM , A.CATEGORY_ID , A.CORP_CUST_ID , A.CLASSIFICATION , A.CURRENCY_CD , A.CUSTOMER_GROUP , A.CUST_CHANNEL , A.CUST_FIELD_C10_A , A.CUST_FIELD_C10_B , A.CUST_FIELD_C10_C , A.CUST_FIELD_C10_D , A.CUST_FIELD_C1_A , A.CUST_FIELD_C1_B , A.CUST_FIELD_C1_C , A.CUST_FIELD_C1_D , A.CUST_FIELD_C2 , A.CUST_FIELD_C4 , A.CUST_FIELD_C6 , A.CUST_FIELD_C8 , A.CUST_FIELD_C30_A , A.CUST_FIELD_C30_B , A.CUST_FIELD_C30_C , A.CUST_FIELD_C30_D , A.INVOICE , A.INV_ITEM_COLOR , A.INV_ITEM_GROUP , A.INV_ITEM_ID , A.INV_ITEM_TYPE , A.INV_PROD_FAM_CD , A.ITEM_FIELD_C10_A , A.ITEM_FIELD_C10_B , A.ITEM_FIELD_C10_C , A.ITEM_FIELD_C10_D , A.ITEM_FIELD_C1_A , A.ITEM_FIELD_C1_B , A.ITEM_FIELD_C1_C , A.ITEM_FIELD_C1_D , A.ITEM_FIELD_C2 , A.ITEM_FIELD_C4 , A.ITEM_FIELD_C6 , A.ITEM_FIELD_C8 , A.ITEM_FIELD_C30_A , A.ITEM_FIELD_C30_B , A.ITEM_FIELD_C30_C , A.ITEM_FIELD_C30_D , A.MITBL_DESCR , A.PM_DIVISION , A.PM_TERRITORY , A.PM_REGION , A.PRDITM_DESCR , A.PRICE_PROGRAM , A.PROD_BRAND , A.PROD_CATEGORY , A.PROD_FIELD_C10_A , A.PROD_FIELD_C10_B , A.PROD_FIELD_C10_C , A.PROD_FIELD_C10_D , A.PROD_FIELD_C2 , A.PROD_FIELD_C4 , A.PROD_FIELD_C6 , A.PROD_FIELD_C8 , A.PROD_FIELD_C1_A , A.PROD_FIELD_C1_B , A.PROD_FIELD_C1_C , A.PROD_FIELD_C1_D , A.PROD_FIELD_C30_A , A.PROD_FIELD_C30_B , A.PROD_FIELD_C30_C , A.PROD_FIELD_C30_D , A.REGION_CD , A.SHIP_TO_CUST_ID , A.SOLD_TO_CUST_ID , A.SOURCE_CODE , A.SUBCUST_QUAL1 , A.SUBCUST_QUAL2 , A.DP_ITEMCODE , A.DP_LOCATION , A.DP_DESCRIPTION , A.DP_AVGPRICE , A.DP_CURRENTMODELPD , A.DP_CURRENTMODELYR , A.DP_LIFEPROFILE , A.DP_WEIGHTPROFILE , A.DP_INHIBITED , A.DP_DEMANDAVERAGE , A.DP_KEYFLDNAMES , A.PRODUCT_ID , A.DP_NEXTLEVELUOM , A.DP_NEXTLEVELCONV , A.DP_CALCULATIONTYPE , A.DP_USESSEASONPROF , A.DP_DETSEASPROFILE , A.DP_LASTRESETPD , A.DP_LASTRESETYR , A.DP_EVALPERIODS , A.DP_AUDITREVIEWDONE , A.DP_ROUNDDECIMALS , A.DP_ROLLBACKPERIODS , A.DP_SEASONALITYTYPE , A.DP_LASTEVALPDS , B.DP_UD01 , B.DP_UD02 , B.DP_UD03 , B.DP_UD04 , B.DP_UD05 , B.DP_UD06 , B.DP_UD07 , B.DP_UD08 , B.DP_UD09 , B.DP_UD10 , B.DP_UD11 , B.DP_UD12 , B.DP_UD13 , B.DP_UD14 , B.DP_UD15 , B.DP_UD16 , B.DP_UD17 , B.DP_UD18 , B.DP_UD19 , B.DP_UD20 , B.DP_UD21 , B.DP_UD22 , B.DP_UD23 , B.DP_UD24 , B.DP_UD25 , B.DP_UD26 , B.DP_UD27 , B.DP_UD28 , B.DP_UD29 , B.DP_UD30 , B.DP_UD31 , B.DP_UD32 , B.DP_UD33 , B.DP_UD34 , B.DP_UD35 , B.DP_UD36 , B.DP_UD37 , B.DP_UD38 , B.DP_UD39 , B.DP_UD40 , B.DP_UD41 , B.DP_UD42 , B.DP_UD43 , B.DP_UD44 , B.DP_UD45 , B.DP_UD46 , B.DP_UD47 , B.DP_UD48 , B.DP_UD49 , B.DP_UD50 , A.PRODUCT_GROUP , A.PRODUCT_KIT_FLAG , A.SETID , A.CM_UNIT_COST , A.CONVERSION_RATE , A.UPC_ID FROM PS_DP_PUB_FCITEMS A , PS_DP_PUB_FCITEMS2 B WHERE A.DP_PUBLISHNAME = B.DP_PUBLISHNAME(+) AND A.DP_PUBLISH_DATE = B.DP_PUBLISH_DATE(+) AND A.DP_FORECASTITEM = B.DP_FORECASTITEM(+)
|
DP_PUBLISHNAME