VIEW: APPS.FII_AR_INV_CUST_L7D_WH_V

Source

View Text - Preformatted

SELECT f.set_of_books_fk_key, f.operating_unit_fk_key, f.customer_fk_key, f.functional_currency, decode(sign(f.calendar_date - cal.cycq_7days_ago), -1, 0, decode(sign(cal.cycq_today - f.calendar_date), -1, 0, f.amt_invoiced_ar_g)), decode(sign(f.calendar_date - cal.cycq_7days_ago), -1, 0, decode(sign(cal.cycq_today - f.calendar_date), -1, 0, f.inv_created_cnt)) from (select fii_time_wh_api.ent_cycq_start cycq_start, fii_time_wh_api.today cycq_today, fii_time_wh_api.today - 6 cycq_7days_ago from dual) cal, fii_ar_oper_cust_summary_f f WHERE f.calendar_date between cal.cycq_start and cal.cycq_today and (decode(sign(f.calendar_date - cal.cycq_7days_ago), -1, 0, decode(sign(cal.cycq_today - f.calendar_date), -1, 0, f.amt_invoiced_ar_g)) <> 0 or decode(sign(f.calendar_date - cal.cycq_7days_ago), -1, 0, decode(sign(cal.cycq_today - f.calendar_date), -1, 0, f.inv_created_cnt)) <> 0)

View Text - HTML Formatted

SELECT F.SET_OF_BOOKS_FK_KEY
, F.OPERATING_UNIT_FK_KEY
, F.CUSTOMER_FK_KEY
, F.FUNCTIONAL_CURRENCY
, DECODE(SIGN(F.CALENDAR_DATE - CAL.CYCQ_7DAYS_AGO)
, -1
, 0
, DECODE(SIGN(CAL.CYCQ_TODAY - F.CALENDAR_DATE)
, -1
, 0
, F.AMT_INVOICED_AR_G))
, DECODE(SIGN(F.CALENDAR_DATE - CAL.CYCQ_7DAYS_AGO)
, -1
, 0
, DECODE(SIGN(CAL.CYCQ_TODAY - F.CALENDAR_DATE)
, -1
, 0
, F.INV_CREATED_CNT))
FROM (SELECT FII_TIME_WH_API.ENT_CYCQ_START CYCQ_START
, FII_TIME_WH_API.TODAY CYCQ_TODAY
, FII_TIME_WH_API.TODAY - 6 CYCQ_7DAYS_AGO
FROM DUAL) CAL
, FII_AR_OPER_CUST_SUMMARY_F F
WHERE F.CALENDAR_DATE BETWEEN CAL.CYCQ_START
AND CAL.CYCQ_TODAY
AND (DECODE(SIGN(F.CALENDAR_DATE - CAL.CYCQ_7DAYS_AGO)
, -1
, 0
, DECODE(SIGN(CAL.CYCQ_TODAY - F.CALENDAR_DATE)
, -1
, 0
, F.AMT_INVOICED_AR_G)) <> 0 OR DECODE(SIGN(F.CALENDAR_DATE - CAL.CYCQ_7DAYS_AGO)
, -1
, 0
, DECODE(SIGN(CAL.CYCQ_TODAY - F.CALENDAR_DATE)
, -1
, 0
, F.INV_CREATED_CNT)) <> 0)