Pass variable into View?
From: Mark <zzzzzz45_at_hotmail.com>
Date: 19 Jul 2004 09:11:06 -0700
Message-ID: <9c8c0698.0407190811.6185f392_at_posting.google.com>
Hi,
Date: 19 Jul 2004 09:11:06 -0700
Message-ID: <9c8c0698.0407190811.6185f392_at_posting.google.com>
Hi,
Thanks,
Mark
CREATE OR REPLACE VIEW CGPPR_GLOBAL_FPS_AT_DATE ( GLOBAL_FP_ID,
GLOBAL_FP_PRICE, GLOBAL_FP_COMMENT, GLOBAL_FP_TBU, GLOBAL_FP_DISC_CAT, GLOBAL_FP_VOL_DISC, GLOBAL_FP_PARTNER_PRICE, GLOBAL_FP_LIST_PRICE, GLOBAL_FP_MSCAT, GLOBAL_FP_WPCAT, GLOBAL_FP_EFF_DATE, GLOBAL_FP_MOD_WHO, GLOBAL_FP_MOD_DATE ) AS Select tblA.* From ( Select GLOBAL_FP_ID, GLOBAL_FP_PRICE, GLOBAL_FP_COMMENT, GLOBAL_FP_TBU, GLOBAL_FP_DISC_CAT, GLOBAL_FP_VOL_DISC, GLOBAL_FP_PARTNER_PRICE, GLOBAL_FP_LIST_PRICE, GLOBAL_FP_MSCAT,GLOBAL_FP_WPCAT, GLOBAL_FP_EFF_DATE, GLOBAL_FP_MOD_WHO, GLOBAL_FP_MOD_DATE
From cgppr_global_fps UNION ALL Select GLOBAL_FP_ID, GLOBAL_FP_PRICE, GLOBAL_FP_COMMENT, GLOBAL_FP_TBU, GLOBAL_FP_DISC_CAT, GLOBAL_FP_VOL_DISC, GLOBAL_FP_PARTNER_PRICE, GLOBAL_FP_LIST_PRICE, GLOBAL_FP_MSCAT,GLOBAL_FP_WPCAT, GLOBAL_FP_EFF_DATE, GLOBAL_FP_MOD_WHO, GLOBAL_FP_MOD_DATE
From cgppr_global_fpsReceived on Mon Jul 19 2004 - 18:11:06 CEST
) tblA,
( Select GLOBAL_FP_ID, Max(GLOBAL_FP_MOD_DATE) GLOBAL_FP_MOD_DATE From ( Select GLOBAL_FP_ID, GLOBAL_FP_MOD_DATE From cgppr_global_fps UNION Select GLOBAL_FP_ID, GLOBAL_FP_MOD_DATE From cgppr_h_global_fps ) Where GLOBAL_FP_MOD_DATE < to_date('01/01/2001', 'dd/mm/YY') Group By GLOBAL_FP_ID
) tblB
Where tblA.GLOBAL_FP_ID = tblB.GLOBAL_FP_ID And tblA.GLOBAL_FP_MOD_DATE = tblB.GLOBAL_FP_MOD_DATE WITH READ ONLY;