[Home] [Help]
442: where packet_id = p_packet_id
443: and substr(result_code,1,1) = 'P'
444: and (document_header_id,document_distribution_id) in
445: ( select distinct b.invoice_id,b.invoice_distribution_id
446: from ap_invoice_distributions_all a,
447: ap_invoice_distributions_all b
448: where (a.invoice_id,a.invoice_distribution_id) in
449: (select document_header_id,
450: document_distribution_id
443: and substr(result_code,1,1) = 'P'
444: and (document_header_id,document_distribution_id) in
445: ( select distinct b.invoice_id,b.invoice_distribution_id
446: from ap_invoice_distributions_all a,
447: ap_invoice_distributions_all b
448: where (a.invoice_id,a.invoice_distribution_id) in
449: (select document_header_id,
450: document_distribution_id
451: from gms_bc_packets gbc
507: and bp.packet_id = p_packet_id
508: and bp.status_code = 'P'
509: and bp.document_distribution_id in ( select distinct apid.po_distribution_id
510: from gms_bc_packets bp1,
511: ap_invoice_distributions_all apid
512: where bp1.packet_id = p_packet_id
513: and bp1.document_type = 'AP'
514: and bp1.document_distribution_id = apid.invoice_distribution_id
515: and substr(bp1.result_code,1,1) = 'F'
1324: SELECT DISTINCT adl.award_set_id,
1325: adl.document_type, -- Bug 2433889
1326: adl.invoice_id, -- Bug 2433889
1327: adl.invoice_distribution_id -- Bug 2433889
1328: FROM ap_invoice_distributions_all ap,
1329: gms_award_distributions adl
1330: WHERE ap.invoice_distribution_id = p_inv_dist_id
1331: AND ap.award_id IS NOT NULL
1332: AND ap.award_id = adl.award_set_id
1527: where adl.document_type = 'AP'
1528: and adl.adl_status = 'I'
1529: and adl.award_set_id in ( select adl2.award_set_id
1530: from gms_award_distributions adl2,
1531: ap_invoice_distributions_all apd
1532: where apd.invoice_id = g_doc_header_id_tab(i)
1533: AND apd.invoice_distribution_id = g_doc_dist_id_tab(i)
1534: and apd.award_id is not null
1535: and adl2.award_set_id = apd.award_id
1650: x_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
1651:
1652: gms_awards_dist_pkg.create_adls (x_rec);
1653:
1654: UPDATE ap_invoice_distributions_all
1655: SET award_id = x_rec.award_set_id
1656: WHERE invoice_id = g_doc_header_id_tab(i)
1657: AND invoice_distribution_id = g_doc_dist_id_tab(i);
1658: /* BUG 14216205 : Added the following Code for SAT : Starts */
2300: /* Added for Bug 5645290 */
2301: decode (apd.prepay_distribution_id ,NULL,line_type_lookup_code,'PREPAY')
2302: /* Bug 5645290 - End */
2303: FROM psa_bc_xla_events_gt xlaevt,
2304: ap_invoice_distributions_all apd,
2305: gms_project_types gpt,
2306: pa_projects_all pp,
2307: ap_invoices_all apinv
2308: WHERE apd.bc_event_id = xlaevt.event_id
2440: - NVL(AID.base_quantity_variance,NVL(AID.quantity_variance,0)) encumbrance_base_amount
2441: ,NVL(AID.amount,0) - NVL(AID.amount_variance,0)
2442: - NVL(AID.quantity_variance,0) encumbrance_amount
2443: ,AID.CHARGE_APPLICABLE_TO_DIST_ID charge_applicable_to_dist_id
2444: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID,
2445: PO_DISTRIBUTIONS_ALL POD,
2446: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2447: IGC_CC_SLA_BFLOW_PRIOR_V IGC,
2448: ap_system_parameters_all ASP
2464: AND (p_mode ='C' OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_mode <>'C')) */
2465: /* Adding for Bug 5645290*/
2466: AND exists (
2467: select 1
2468: from ap_invoice_distributions_all apd
2469: where apd.invoice_distribution_id = apext.aid_invoice_dist_id
2470: and ((apd.prepay_distribution_id is NULL AND p_mode <>'C') OR p_mode ='C' ))
2471: /* Bug 5645290 - End */
2472: AND p_stdinvoice_exists = 'Y'
2571: AND (p_mode ='C' OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_mode <>'C')) */
2572: /* Adding for Bug 5645290*/
2573: AND (exists (
2574: select 1
2575: from ap_invoice_distributions_all apd
2576: where apd.invoice_distribution_id = apext.aid_invoice_dist_id
2577: and ((APD.PREPAY_DISTRIBUTION_ID is null and P_MODE <>'C') or P_MODE ='C' ))
2578: OR exists ( /* BUG 14216205 : Added the following Code for SAT : Starts */
2579: select 1
2626: FROM AP_PREPAY_HISTORY_ALL APPH,
2627: PSA_BC_XLA_EVENTS_GT PBXEG,
2628: AP_PREPAY_APP_DISTS APAD,
2629: AP_INVOICE_LINES_ALL AIL,
2630: AP_INVOICE_DISTRIBUTIONS_ALL AID
2631: WHERE AID.bc_event_id = APPH.bc_Event_id
2632: AND APPH.prepay_history_id = APAD.prepay_history_id
2633: AND AID.invoice_line_number = AIL.line_number
2634: AND AID.invoice_id = AIL.invoice_id
2717: distribution is the negative of the BRC for the parent distribution. */
2718: ( SELECT decode(ap1.pa_addition_flag,'Y',NULL,-1 * nvl(adl1.burdenable_raw_cost,0)) --R12 AP Lines Uptake enhancement : Forward porting bug 4450291
2719: -- Reversing AP distributions should copy the BRC from reversed Distribution
2720: FROM gms_award_distributions adl1,
2721: ap_invoice_distributions ap1
2722: WHERE adl1.document_type = 'AP'
2723: AND adl1.adl_status = 'A' -- Bug 5654186
2724: AND adl1.fc_status = 'A' -- Bug 5654186
2725: AND ap1.invoice_id = apd.invoice_id
2729: AND apd.parent_reversal_id IS NOT NULL
2730: AND adl1.award_set_id = ap1.award_id
2731: AND adl1.adl_line_num =1 ) burdenable_raw_cost ,
2732: apd.parent_reversal_id parent_reversal_id -- Bug 5369296
2733: FROM ap_invoice_distributions_all apd,
2734: ap_invoices_all api,
2735: gms_award_distributions adl,
2736: pa_expenditure_types et
2737: WHERE apd.invoice_distribution_id = p_ap_dist_id
8317: pod.task_id task_id,
8318: adl.award_id award_id
8319: FROM gms_bc_packets pkt,
8320: gl_bc_packets gl,
8321: ap_invoice_distributions_all ap,
8322: po_distributions_all pod,
8323: gms_award_distributions adl
8324: WHERE pkt.packet_id = x_packet_id
8325: AND pkt.document_type = 'AP'
8408: And document_type = 'AP'
8409: And bc_packet_id in
8410: ( select a.bc_packet_id
8411: from gms_bc_packets a,
8412: ap_invoice_distributions_all apd
8413: where a.packet_id = x_packet_id
8414: and a.document_type = 'AP'
8415: and a.document_header_id = apd.invoice_id
8416: and a.document_distribution_id = apd.distribution_line_number