[Home] [Help]
54: L_REFERENCE_2 FV_SF224_TEMP.REFERENCE_2%TYPE;
55:
56: -- References Check_id
57: L_REFERENCE_3 FV_SF224_TEMP.REFERENCE_3%TYPE;
58: L_REFERENCE_8 GL_JE_LINES.REFERENCE_8%TYPE; -- Invoice Dist Line Num
59:
60: -- New Variable added as a part of bug fix #983941
61: L_REFERENCE_9 FV_SF224_TEMP.REFERENCE_9%TYPE ;
62:
1888: glh.je_category,
1889: glh.je_from_sla_flag
1890: FROM gl_je_batches glb,
1891: gl_je_headers glh,
1892: gl_je_lines gll,
1893: gl_code_combinations gcc,
1894: fv_report_definitions frd,
1895: fv_fund_parameters ffp,
1896: fv_treasury_symbols fts
1975: glh.je_category,
1976: glh.je_from_sla_flag
1977: FROM gl_je_batches glb,
1978: gl_je_headers glh,
1979: gl_je_lines gll,
1980: gl_code_combinations gcc,
1981: fv_report_definitions frd,
1982: fv_fund_parameters ffp,
1983: fv_treasury_symbols fts,
2089: glh.je_category,
2090: glh.je_from_sla_flag
2091: FROM gl_je_batches glb,
2092: gl_je_headers glh,
2093: gl_je_lines gll,
2094: gl_code_combinations gcc,
2095: fv_report_definitions frd,
2096: fv_fund_parameters ffp,
2097: fv_treasury_symbols fts,
2181: glh.je_category,
2182: glh.je_from_sla_flag
2183: FROM gl_je_batches glb,
2184: gl_je_headers glh,
2185: gl_je_lines gll,
2186: gl_code_combinations gcc,
2187: fv_report_definitions frd,
2188: fv_fund_parameters ffp,
2189: fv_treasury_symbols fts,
2295: glh.je_category,
2296: glh.je_from_sla_flag
2297: FROM gl_je_batches glb,
2298: gl_je_headers glh,
2299: gl_je_lines gll,
2300: gl_code_combinations gcc,
2301: fv_report_definitions frd,
2302: fv_fund_parameters ffp,
2303: fv_treasury_symbols fts,
2408: glh.je_from_sla_flag
2409:
2410: FROM gl_je_batches glb,
2411: gl_je_headers glh,
2412: gl_je_lines gll,
2413: gl_code_combinations gcc,
2414: fv_report_definitions frd,
2415: fv_fund_parameters ffp,
2416: fv_treasury_symbols fts,
2516: glh.je_category,
2517: glh.je_from_sla_flag
2518: FROM gl_je_batches glb,
2519: gl_je_headers glh,
2520: gl_je_lines gll,
2521: gl_code_combinations gcc,
2522: fv_report_definitions frd,
2523: fv_fund_parameters ffp,
2524: fv_treasury_symbols fts,
2629: glh.je_category,
2630: glh.je_from_sla_flag
2631: FROM gl_je_batches glb,
2632: gl_je_headers glh,
2633: gl_je_lines gll,
2634: gl_code_combinations gcc,
2635: fv_report_definitions frd,
2636: fv_fund_parameters ffp,
2637: fv_treasury_symbols fts,
2743: glh.je_category,
2744: glh.je_from_sla_flag
2745: FROM gl_je_batches glb,
2746: gl_je_headers glh,
2747: gl_je_lines gll,
2748: gl_code_combinations gcc,
2749: fv_report_definitions frd,
2750: fv_fund_parameters ffp,
2751: fv_treasury_symbols fts,
5413: -- And this process submit the Report which lists all the imported data from AP to FV table (FV_REFUNDS_VOIDS_all)
5414: -- with con request Id as the parameter
5415: -- Logic :
5416: -- This process takes all the posted Refunds (ie, Payment Type Flag = 'R' (Refund) and
5417: -- Posted Flag = Y (Accounted) and Entry exist in GL_JE_LINES (Posted in GL),
5418: -- which are not in the FV table (ie INVOICE PAYMNET ID does not exist in FV table )
5419: -- and GL date with in the GL Period.
5420: -- If the Distibution is derived from a PO, the PO date is populated as obligation Date
5421: -- and PO Number as Obligation Number
5422: -- Else If the Distibution is derived from an Invoice, the Invocie date is populated as
5423: -- obligation Date and parent Invoice Number as Obligation Nuber
5424: -- Else that is the distribution is manual entry then NULL is populated for
5425: -- Obligation date and Obligation Number
5426: -- The dist_code_combination_id is joined with gl_je_lines code_combination_id is to
5427: -- imporve the performance
5428: -- ==============================================================================================
5429: PROCEDURE fv_ap_refund_populate( errbuf OUT NOCOPY VARCHAR2,
5430: retcode OUT NOCOPY NUMBER,
5626: WHERE invoice_payment_id = apip.invoice_payment_id)
5627: /*
5628: Commented for bug 14022463
5629: AND EXISTS (SELECT 1
5630: FROM gl_je_lines gljl,
5631: gl_je_headers gljh,
5632: ap_invoice_distributions_all apid
5633: WHERE gljl.ledger_id = apid.set_of_books_id
5634: AND gljl.status = 'P'
5638: AND apid.invoice_id = api.invoice_id
5639: AND gljl.reference_2 = TO_CHAR(api.invoice_id)
5640: UNION
5641: SELECT 1
5642: FROM gl_je_lines gljl,
5643: gl_je_headers gljh,
5644: gl_import_references glir,
5645: xla_ae_lines xal,
5646: xla_distribution_links xdl,