PSB Worksheet Submission Status

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
Blitz Report™