[Home] [Help]
3364: |
3365: | This function is only applicable to pre 11i and 11i data. Due to R12
3366: | new funds/encumbrance solution. AP will be maintaining this function
3367: | for pre-upgrade data because of PSA team decide no upgrade for
3368: | AP_ENCUMBRANCE_LINES_ALL table.
3369: |
3370: | PARAMETERS
3371: | P_Po_distribution_id - po_distribution_id (in)
3372: | P_Start_date - Start gl date (in)
3410: FROM (SELECT DISTINCT old_distribution_id, encumbered_flag, org_id
3411: FROM AP_INVOICE_DISTRIBUTIONS dist
3412: WHERE po_distribution_id = p_po_distribution_id
3413: ) aid,
3414: AP_ENCUMBRANCE_LINES ael,
3415: financials_system_parameters fsp
3416: WHERE 1=1 --aid.po_distribution_id = P_po_distribution_id --commented for bug12962585
3417: AND aid.old_distribution_id = ael.invoice_distribution_id -- added for bug12962585
3418: -- AND aid.invoice_distribution_id = ael.invoice_distribution_id --commented for bug12962585
3459: AND (aid.accrual_posted_flag = 'Y' or aid.cash_posted_flag = 'Y')
3460: AND (( p_start_gl_date is not null and p_start_gl_date <= aid.accounting_date) or (p_start_gl_date is null))
3461: AND ((p_end_gl_date is not null and p_end_gl_date >= aid.accounting_date) or (p_end_gl_date is null))
3462: AND NOT EXISTS (SELECT 'release 11.5 encumbrance'
3463: from ap_encumbrance_lines_all ael
3464: where ael.invoice_distribution_id = aid.invoice_distribution_id)
3465: -- bug 7225570
3466: AND aid.bc_event_id is null
3467: AND NOT EXISTS (SELECT 'release 11.5 encumbrance tax'
3464: where ael.invoice_distribution_id = aid.invoice_distribution_id)
3465: -- bug 7225570
3466: AND aid.bc_event_id is null
3467: AND NOT EXISTS (SELECT 'release 11.5 encumbrance tax'
3468: from ap_encumbrance_lines_all ael
3469: where ael.invoice_distribution_id = aid.charge_applicable_to_dist_id);
3470:
3471: BEGIN
3472: