eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

MATERIALIZED VIEW: APPS.ASO_BI_DISC_BUK_MV

Source


SELECT  /* 12.0: bug#4526784 */  BUK.rowid r, cust.rowid c, '1' mark,
        cust.range1_low low, cust.range1_high high,
        BUK.short_name, BUK.bucket_id
FROM  BIS.BIS_BUCKET buk,
      BIS.BIS_BUCKET_CUSTOMIZATIONS cust
WHERE
      buk.application_id=697
AND   buk.short_name='ASO_DISCOUNT_PERCENT_BUK'
AND   cust.bucket_id  = buk.bucket_id
UNION ALL
SELECT  BUK.rowid r, cust.rowid c, '2' mark,
        cust.range2_low low, cust.range2_high high,
        BUK.short_name short_name, BUK.bucket_id
FROM  BIS.BIS_BUCKET buk,
      BIS.BIS_BUCKET_CUSTOMIZATIONS cust
WHERE
      buk.application_id=697
AND   buk.short_name='ASO_DISCOUNT_PERCENT_BUK'
AND   cust.bucket_id  = buk.bucket_id
UNION ALL
SELECT  BUK.rowid r, cust.rowid c, '3' mark,
        cust.range3_low low, cust.range3_high high,
        BUK.short_name, BUK.bucket_id
FROM  BIS.BIS_BUCKET buk,
      BIS.BIS_BUCKET_CUSTOMIZATIONS cust
WHERE
      buk.application_id=697
AND   buk.short_name='ASO_DISCOUNT_PERCENT_BUK'
AND   cust.bucket_id  = buk.bucket_id
UNION ALL
SELECT  BUK.rowid r, cust.rowid c, '4' mark,
        cust.range4_low low, cust.range4_high high,
        BUK.short_name, BUK.bucket_id
FROM  BIS.BIS_BUCKET buk,
      BIS.BIS_BUCKET_CUSTOMIZATIONS cust
WHERE
      buk.application_id=697
AND   buk.short_name='ASO_DISCOUNT_PERCENT_BUK'
AND   cust.bucket_id  = buk.bucket_id
UNION ALL
SELECT  BUK.rowid r, cust.rowid c, '5' mark,
        cust.range5_low low, cust.range5_high high,
        BUK.short_name, BUK.bucket_id
FROM  BIS.BIS_BUCKET buk,
      BIS.BIS_BUCKET_CUSTOMIZATIONS cust
WHERE
      buk.application_id=697
AND   buk.short_name= 'ASO_DISCOUNT_PERCENT_BUK'
AND   cust.bucket_id  = buk.bucket_id
UNION ALL
SELECT  BUK.rowid r, cust.rowid c, '6' mark,
        cust.range6_low low, cust.range6_high high,
        BUK.short_name, BUK.bucket_id
FROM  BIS.BIS_BUCKET buk,
      BIS.BIS_BUCKET_CUSTOMIZATIONS cust
WHERE
      buk.application_id=697
AND   buk.short_name='ASO_DISCOUNT_PERCENT_BUK'
AND   cust.bucket_id  = buk.bucket_id
UNION ALL
SELECT  BUK.rowid r, cust.rowid c, '7' mark,
        cust.range7_low low, cust.range7_high high,
        BUK.short_name, BUK.bucket_id
FROM  BIS.BIS_BUCKET buk,
      BIS.BIS_BUCKET_CUSTOMIZATIONS cust
WHERE
      buk.application_id=697
AND   buk.short_name='ASO_DISCOUNT_PERCENT_BUK'
AND   cust.bucket_id  = buk.bucket_id
UNION ALL
SELECT  BUK.rowid r, cust.rowid c, '8' mark,
        cust.range8_low low, cust.range8_high high,
        BUK.short_name, BUK.bucket_id
FROM  BIS.BIS_BUCKET buk,
      BIS.BIS_BUCKET_CUSTOMIZATIONS cust
WHERE
      buk.application_id=697
AND   buk.short_name='ASO_DISCOUNT_PERCENT_BUK'
AND   cust.bucket_id  = buk.bucket_id
UNION ALL
SELECT  BUK.rowid r, cust.rowid c, '9' mark,
        cust.range9_low low, cust.range9_high high,
        BUK.short_name, BUK.bucket_id
FROM  BIS.BIS_BUCKET buk,
      BIS.BIS_BUCKET_CUSTOMIZATIONS cust
WHERE
      buk.application_id=697
AND   buk.short_name='ASO_DISCOUNT_PERCENT_BUK'
AND   cust.bucket_id  = buk.bucket_id
UNION ALL
SELECT  BUK.rowid r, cust.rowid c, '10' mark,
        cust.range10_low low, cust.range10_high high,
        BUK.short_name, BUK.bucket_id
FROM  BIS.BIS_BUCKET buk,
      BIS.BIS_BUCKET_CUSTOMIZATIONS cust
WHERE
      buk.application_id=697
AND   buk.short_name='ASO_DISCOUNT_PERCENT_BUK'
AND   cust.bucket_id  = buk.bucket_id