APPS.OZF_REFRESH_VIEW_PVT dependencies on OZF_BASELINE_SALES_FACTS
Line 661: OZF_BASELINE_SALES_FACTS x,
657: ) period_type_id,
658: SUM(CASE WHEN COM_BASELINE_QTY > 0 THEN COM_BASELINE_QTY ELSE 0 END) BASELINE_QTY,
659: SUM(CASE WHEN COM_BASELINE_AMT > 0 THEN COM_BASELINE_AMT ELSE 0 END) BASELINE_AMT
660: FROM 661: OZF_BASELINE_SALES_FACTS x, 662: OZF_TIME_DAY b
663: WHERE x.status_flag IS NULL
664: AND x.TRANSACTION_DATE = b.report_date
665: GROUP BY