Write Custom SQL for Oracle Argus Mart Advance Condition

Argus Insight provides different type of point-in-time queries. You may create custom SQL for any of these point-in-time queries.

The following sections comprise the procedures to create custom query for each type of point-in-time query:

• Current Data Point-in-Time Query
  
• As of Date Point-in-Time Query
  
• At Lock Point-in-Time Query
  
• Last Locked Revision as of a Point in Time Query
  
• Last Locked Revision for a Version in a Period (Case Receipt Date) Point-in-Time Query
  
• Last Locked Revision for a Version in a Period (Case Locked Date) Point-in-Time Query
  
• Last Locked Revision for a Version in a Period (Case Creation Date) Point-in-Time Query
  
• Aggregate Queries