SELECT put.user_table_name
,pur.row_low_range_or_name
,pui.value
,puc.user_column_name
FROM pay_user_tables put
,pay_user_rows_f pur
,pay_user_columns puc
,pay_user_column_instances_f pui
WHERE 1=1
AND pur.user_table_id = put.user_table_id
AND pui.user_column_id = puc.user_column_id
AND pui.user_row_id = pur.user_row_id
AND SYSDATE BETWEEN pur.effective_start_date AND pur.effective_end_date
AND SYSDATE BETWEEN pui.effective_start_date AND pui.effective_end_date
--AND put.user_table_name = '<USER_DEFINED_TABLE_NAME>'
--AND puc.user_column_name = '<USER_DEFINED_COLUMN_NAME>'
AND puc.user_table_id = put.user_table_id
Keep posting.
ReplyDeleteThanks for sharing the knowledge.
ReplyDeleteGood
ReplyDeleteKeep sharing knowledge.
ReplyDeleteOptumflex.com
ReplyDelete