DBA Data[Home] [Help]

APPS.GMS_REPORT_SF269 dependencies on GMS_BC_PACKETS

Line 379: FROM gms_bc_packets gbc, GMS_BUDGET_VERSIONS GBV

375: AND GBV.budget_status_code = 'B'
376: GROUP BY GB.award_id
377: UNION ALL
378: SELECT sum((nvl(gbc.entered_dr,0)- nvl(gbc.entered_cr,0)) * decode(gbc.document_type,'PO',1,'AP',1,'ENC',1,0)) burdened_cost
379: FROM gms_bc_packets gbc, GMS_BUDGET_VERSIONS GBV
380: WHERE gbv.budget_version_id = gbc.budget_version_id
381: AND gbc.status_code = 'A'
382: AND GBV.budget_status_code = 'B'
383: AND GBV.current_flag in ('Y', 'R')