DBA Data[Home] [Help]

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