APPS.FV_1219_TRANSACTIONS dependencies on FV_SF1219_REPORT_TEMPLATE

Line 4409: FV_SF1219_REPORT_TEMPLATE fvr

4405: SELECT p_def_org_id, fvt.alc_code,
4406: substr(fvt.group_name,1,3),
4407: sum(fvt.amount * fvr.multiplier)
4408: FROM FV_SF1219_TEMP fvt,
4409: FV_SF1219_REPORT_TEMPLATE fvr
4410: WHERE fvt.alc_code is not null
4411: AND ( fvt.record_type = 'A' OR
4412: (fvt.record_type = 'R' AND fvt.group_name IS NOT NULL))
4413: AND substr(fvt.group_name,1,3) = fvr.line_id

Line 4421: FV_SF1219_REPORT_TEMPLATE fvr

4417: SELECT p_def_org_id, fvt.alc_code, fvm.line_id, sum(fvt.amount *
4418: DECODE(fvt.record_type, 'N', 1,fvr.multiplier))
4419: FROM FV_SF1219_TEMP fvt,
4420: FV_SF1219_MANUAL_LINES fvm,
4421: FV_SF1219_REPORT_TEMPLATE fvr
4422: WHERE fvt.alc_code IS NOT NULL
4423: AND ((fvt.record_type IN ('M', 'N')
4424: OR (fvt.record_type = 'R' AND fvt.group_name IS NULL))
4425: AND fvt.temp_record_id = fvm.temp_record_id )

Line 4859: x_line_id fv_sf1219_report_template.line_id%TYPE;

4855: IS
4856: l_module_name VARCHAR2(200) := g_module_name || 'GEN_FLAT_FILE';
4857:
4858: i NUMBER;
4859: x_line_id fv_sf1219_report_template.line_id%TYPE;
4860: x_amt fv_sf1219_org_temp.amount%TYPE;
4861:
4862: TYPE total_rec_type IS RECORD
4863: (line_id fv_sf1219_report_template.line_id%TYPE,

Line 4863: (line_id fv_sf1219_report_template.line_id%TYPE,

4859: x_line_id fv_sf1219_report_template.line_id%TYPE;
4860: x_amt fv_sf1219_org_temp.amount%TYPE;
4861:
4862: TYPE total_rec_type IS RECORD
4863: (line_id fv_sf1219_report_template.line_id%TYPE,
4864: amt fv_sf1219_org_temp.amount%TYPE);
4865:
4866: TYPE total_tab_type IS TABLE OF total_rec_type INDEX BY BINARY_INTEGER;
4867:

Line 4875: FROM fv_sf1219_report_template fvr,

4871: SELECT fvr.line_id v_line_id, SUM(DECODE(fvr.line_type,
4872: 'A', fvo.amount,
4873: 'T', fvo.amount,
4874: 'B',fvo.amount,0)) v_amt
4875: FROM fv_sf1219_report_template fvr,
4876: fv_sf1219_org_temp fvo
4877: WHERE fvr.line_id = fvo.line_id
4878: AND fvo.alc_code = v_alc_code
4879: AND line_type <> 'D'

Line 4883: FROM fv_sf1219_report_template

4879: AND line_type <> 'D'
4880: GROUP BY fvr.line_id
4881: UNION
4882: SELECT line_id,0
4883: FROM fv_sf1219_report_template
4884: WHERE line_id NOT IN
4885: (SELECT line_id FROM fv_sf1219_org_temp
4886: WHERE alc_code = v_alc_code)
4887: AND line_type <> 'D'

Line 4897: FROM fv_sf1219_report_template fvr,

4893: SELECT SUM(grp_amount) group_amount, alc alc_code
4894: FROM (SELECT SUM(decode(fvt.record_type,'N', fvt.amount,
4895: fvt.amount*fvr.multiplier))
4896: grp_amount, fvt.alc_code alc
4897: FROM fv_sf1219_report_template fvr,
4898: fv_sf1219_temp fvt
4899: WHERE substr(fvt.group_name,1,3) = fvr.line_id
4900: AND (fvt.record_type IN ('A') OR
4901: (fvt.record_type = 'R' AND fvt.group_name IS NOT NULL))

Line 4909: FROM fv_sf1219_report_template fvr,

4905: UNION
4906: SELECT SUM(decode(fvt.record_type,'N', fvt.amount,
4907: fvt.amount*fvr.multiplier))
4908: grp_amount, fvt.alc_code alc
4909: FROM fv_sf1219_report_template fvr,
4910: fv_sf1219_temp fvt,
4911: fv_sf1219_manual_lines fvm
4912: WHERE fvm.line_id = fvr.line_id
4913: AND fvt.temp_record_id = fvm.temp_record_id

Line 4930: FROM fv_sf1219_report_template fvr, fv_sf1219_temp fvt

4926: FROM (SELECT fvt.alc_code alc, SUBSTR(fvt.group_name,1,3) l_num,
4927: to_char(to_date(fvt.accomplish_month,'MMYYYY'),'MM/YY') acc_mon,
4928: SUM(decode(fvt.record_type,'N', fvt.amount,
4929: fvt.amount*fvr.multiplier)) grp_amt
4930: FROM fv_sf1219_report_template fvr, fv_sf1219_temp fvt
4931: WHERE substr(fvt.group_name,1,3) = fvr.line_id
4932: AND (fvt.record_type IN ('A') OR
4933: (fvt.record_type = 'R' AND fvt.group_name IS NOT NULL))
4934: AND fvt.alc_code = v_alc_code

Line 4943: FROM fv_sf1219_report_template fvr,

4939: SELECT fvt.alc_code alc, fvm.line_id l_num,
4940: to_char(to_date(fvt.accomplish_month,'MMYYYY'),'MM/YY') acc_mon,
4941: SUM(decode(fvt.record_type,'N', fvt.amount,
4942: fvt.amount*fvr.multiplier)) grp_amt
4943: FROM fv_sf1219_report_template fvr,
4944: fv_sf1219_temp fvt, fv_sf1219_manual_lines fvm
4945: WHERE fvm.line_id = fvr.line_id
4946: AND fvt.temp_record_id = fvm.temp_record_id
4947: AND (fvt.record_type IN ('M','N') OR