PSB Worksheet Submission Status

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Worksheet Submission Status Report (XML)
Short Name: PSBWSSUB_XML
DB package: PSB_PSBWSSUB_XMLP_PKG
Run PSB Worksheet Submission Status and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT ws.worksheet_id Worksheet_ID1,
             ws.budget_group_id budget_group_id2,
             bg.name Budget_Group,
             DECODE(ws.date_submitted, NULL, 'N','Y') Submitted
FROM    psb_worksheets       ws,
             psb_budget_groups  bg
WHERE ws.global_worksheet_id = :cp_global_worksheet_id
AND      NVL(ws.global_worksheet_flag, 'N')  <> 'Y'
AND      NVL(ws.local_copy_flag, 'N')           <> 'Y'
AND      bg.budget_group_id = ws.budget_group_id
AND      DECODE( ws.date_submitted, NULL, 'N', 'Y') 
             = 
             DECODE ( :p_not_submitted_only_flag, 
                             'Y', 'N', 
                             DECODE(ws.date_submitted, NULL, 'N', 'Y')
                           ) 
 and ws.budget_group_id=:budget_group_id1
Parameter Name SQL text Validation
Budget Group Name 
 
 LOV Oracle
Worksheet 
 
 LOV Oracle
Print Not Submitted Only 
 
 LOV Oracle
Download
Related Blitz Reports
PSB Vacant Position PSB Service Package Description PSB Vacant Position Report by Responsibility PSB Service Package Utilization PSB Stage Variance Report for Position by Responsibility PSB Stage Variance Report for Account by Responsibility PSB Worksheet Account Costing PSB Stage Variance Report for Position PSB Worksheet Account Costing Report By Responsibility
Blitz Report™

Blitz Report™ provides multiple benefits: