Siebel SQLs/Error Messages >  Price and Product SQLs

-- these SQLs were tried in Siebel 7.7

--Qualification Price List per organization

SELECT T8.NAME, T8.CURCY_CD, T8.EFF_START_DT, T8.EFF_END_DT, T8.DESC_TEXT, T5.NAME

FROM SIEBEL.S_PARTY T1, SIEBEL.S_PRI_LST_BU T2, SIEBEL.S_PRIMDL T3, SIEBEL.S_PAYMENT_TERM T4, SIEBEL.S_ORG_EXT T5, SIEBEL.S_USER T6, SIEBEL.S_PRI_LST T7, SIEBEL.S_PRI_LST T8

WHERE T8.COST_LST_ID = T7.ROW_ID (+)

AND T8.LAST_UPD_BY = T6.PAR_ROW_ID (+)

AND T8.PAYMENT_TERM_ID = T4.ROW_ID (+)

AND T8.PRIMDL_ID = T3.ROW_ID (+)

AND T8.BU_ID = T2.BU_ID (+)

AND T8.ROW_ID = T2.PRI_LST_ID (+)

AND T2.BU_ID = T1.ROW_ID (+)

AND T2.BU_ID = T5.PAR_ROW_ID (+)

AND (T8.SUBTYPE_CD != 'COST LIST' AND T8.SUBTYPE_CD != 'RATE LIST')

ORDER BY T8.NAME, T8.SUBTYPE_CD;

--List of all active products per region

SELECT T9.NAME PRODUCT_NAME, T4.NAME PRODUCT_LINE, T9.DESC_TEXT, T2.NAME ORG_NAME, T9.ORDERABLE_FLG, T9.EFF_START_DT, T9.EFF_END_DT

FROM SIEBEL.S_PROD_CFGVER T1, SIEBEL.S_ORG_EXT T2, SIEBEL.S_LIT T3, SIEBEL.S_XA_CLASS T4, SIEBEL.S_PROD_INT_CRSE T5, SIEBEL.S_PARTY T6, SIEBEL.S_PROD_INT_BU T7, SIEBEL.S_LIT T8, SIEBEL.S_PROD_INT T9

WHERE T9.PROD_IMAGE_ID = T8.ROW_ID (+)

AND T9.ROW_ID = T1.PRODUCT_ID (+)

AND T9.XA_CLASS_ID = T4.ROW_ID (+)

AND T9.THMBNL_IMAGE_ID = T3.ROW_ID (+)

AND T9.ROW_ID = T5.PAR_ROW_ID (+)

AND T9.BU_ID = T7.BU_ID (+)

AND T9.ROW_ID = T7.PROD_INT_ID (+)

AND T7.BU_ID = T6.ROW_ID (+)

AND T7.BU_ID = T2.PAR_ROW_ID (+)

AND (T1.CURR_VER_FLG = 'Y' OR T1.CURR_VER_FLG IS NULL OR T1.RELEASED_FLG = 'N' AND T1.VERSION_NUM = '1')

ORDER BY T9.NAME;