[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:
1863: glh.je_category,
1864: glh.je_from_sla_flag
1865: FROM gl_je_batches glb,
1866: gl_je_headers glh,
1867: gl_je_lines gll,
1868: gl_code_combinations gcc,
1869: fv_report_definitions frd,
1870: fv_fund_parameters ffp,
1871: fv_treasury_symbols fts
1949: glh.je_category,
1950: glh.je_from_sla_flag
1951: FROM gl_je_batches glb,
1952: gl_je_headers glh,
1953: gl_je_lines gll,
1954: gl_code_combinations gcc,
1955: fv_report_definitions frd,
1956: fv_fund_parameters ffp,
1957: fv_treasury_symbols fts,
2062: glh.je_category,
2063: glh.je_from_sla_flag
2064: FROM gl_je_batches glb,
2065: gl_je_headers glh,
2066: gl_je_lines gll,
2067: gl_code_combinations gcc,
2068: fv_report_definitions frd,
2069: fv_fund_parameters ffp,
2070: fv_treasury_symbols fts,
2172: glh.je_category,
2173: glh.je_from_sla_flag
2174: FROM gl_je_batches glb,
2175: gl_je_headers glh,
2176: gl_je_lines gll,
2177: gl_code_combinations gcc,
2178: fv_report_definitions frd,
2179: fv_fund_parameters ffp,
2180: fv_treasury_symbols fts,
2284: glh.je_from_sla_flag
2285:
2286: FROM gl_je_batches glb,
2287: gl_je_headers glh,
2288: gl_je_lines gll,
2289: gl_code_combinations gcc,
2290: fv_report_definitions frd,
2291: fv_fund_parameters ffp,
2292: fv_treasury_symbols fts,
2391: glh.je_category,
2392: glh.je_from_sla_flag
2393: FROM gl_je_batches glb,
2394: gl_je_headers glh,
2395: gl_je_lines gll,
2396: gl_code_combinations gcc,
2397: fv_report_definitions frd,
2398: fv_fund_parameters ffp,
2399: fv_treasury_symbols fts,
2503: glh.je_category,
2504: glh.je_from_sla_flag
2505: FROM gl_je_batches glb,
2506: gl_je_headers glh,
2507: gl_je_lines gll,
2508: gl_code_combinations gcc,
2509: fv_report_definitions frd,
2510: fv_fund_parameters ffp,
2511: fv_treasury_symbols fts,
2616: glh.je_category,
2617: glh.je_from_sla_flag
2618: FROM gl_je_batches glb,
2619: gl_je_headers glh,
2620: gl_je_lines gll,
2621: gl_code_combinations gcc,
2622: fv_report_definitions frd,
2623: fv_fund_parameters ffp,
2624: fv_treasury_symbols fts,
5275: -- And this process submit the Report which lists all the imported data from AP to FV table (FV_REFUNDS_VOIDS_all)
5276: -- with con request Id as the parameter
5277: -- Logic :
5278: -- This process takes all the posted Refunds (ie, Payment Type Flag = 'R' (Refund) and
5279: -- Posted Flag = Y (Accounted) and Entry exist in GL_JE_LINES (Posted in GL),
5280: -- which are not in the FV table (ie INVOICE PAYMNET ID does not exist in FV table )
5281: -- and GL date with in the GL Period.
5282: -- If the Distibution is derived from a PO, the PO date is populated as obligation Date
5283: -- and PO Number as Obligation Number
5284: -- Else If the Distibution is derived from an Invoice, the Invocie date is populated as
5285: -- obligation Date and parent Invoice Number as Obligation Nuber
5286: -- Else that is the distribution is manual entry then NULL is populated for
5287: -- Obligation date and Obligation Number
5288: -- The dist_code_combination_id is joined with gl_je_lines code_combination_id is to
5289: -- imporve the performance
5290: -- ==============================================================================================
5291: PROCEDURE fv_ap_refund_populate( errbuf OUT NOCOPY VARCHAR2,
5292: retcode OUT NOCOPY NUMBER,
5480: AND NOT EXISTS
5481: ( SELECT 1 FROM fv_refunds_voids_all
5482: WHERE invoice_payment_id = apip.invoice_payment_id)
5483: AND EXISTS (SELECT 1
5484: FROM gl_je_lines gljl,
5485: gl_je_headers gljh,
5486: ap_invoice_distributions_all apid
5487: WHERE gljl.ledger_id = apid.set_of_books_id
5488: AND gljl.status = 'P'
5492: AND apid.invoice_id = api.invoice_id
5493: AND gljl.reference_2 = TO_CHAR(api.invoice_id)
5494: UNION
5495: SELECT 1
5496: FROM gl_je_lines gljl,
5497: gl_je_headers gljh,
5498: gl_import_references glir,
5499: xla_ae_lines xal,
5500: xla_distribution_links xdl,