DBA Data[Home] [Help]

APPS.GMS_REPORT_SF425 dependencies on GMS_BC_PACKETS

Line 159: FROM gms_bc_packets gbc, GMS_BUDGET_VERSIONS GBV

155: AND trunc(gb.start_date) <= trunc(p_report_end_date) -- added to get the cumulative commitments
156: GROUP BY GB.award_id
157: UNION ALL
158: 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
159: FROM gms_bc_packets gbc, GMS_BUDGET_VERSIONS GBV
160: WHERE gbv.budget_version_id = gbc.budget_version_id
161: AND gbc.status_code = 'A'
162: AND GBV.budget_status_code = 'B'
163: AND GBV.current_flag in ('Y', 'R')