[Home] [Help]
1371:
1372: CURSOR c_po_miss_adls (p_po_distribution_id NUMBER) IS
1373: SELECT pod.award_id award_set_id,
1374: adl.adl_status -- Bug 2155774
1375: FROM po_distributions_all pod,
1376: gms_award_distributions adl
1377: WHERE pod.po_distribution_id = p_po_distribution_id
1378: AND pod.award_id IS NOT NULL
1379: AND pod.award_id = adl.award_set_id
1424: AND pd.award_id <> adl2.award_set_id
1425: UNION ALL
1426: SELECT adl2.award_set_id,adl2.document_type
1427: FROM gms_award_distributions adl2,
1428: po_distributions_all pd
1429: WHERE g_document_type_tab(i) = 'PO'
1430: AND adl2.document_type = 'PO'
1431: AND adl2.adl_line_num = 1
1432: AND adl2.po_distribution_id = pd.po_distribution_id
2423: ,AID.invoice_distribution_id aid_invoice_dist_id
2424: ,AID.parent_reversal_id aid_parent_reversal_id
2425: ,AID.po_distribution_id po_distribution_id
2426: ,AID.invoice_id bus_flow_inv_id
2427: ,Decode (IGC.CC_LINE, null, 'PO_DISTRIBUTIONS_ALL', IGC.CC_DIST_TYPE) Bus_Flow_PO_Dist_Type
2428: ,Decode (IGC.CC_LINE, null, Decode (pod.po_release_id, NULL, 'PURCHASE_ORDER', 'RELEASE') , IGC.CC_ENTITY_CODE) Bus_Flow_PO_Entity_Code
2429: ,Decode (IGC.CC_LINE, null, Decode (pod.po_release_id, NULL, pod.po_header_id,pod.po_release_id)
2430: ,IGC.cc_doc_id) Bus_Flow_PO_Doc_Id
2431: ,AID.project_id aid_project_id
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
2449: WHERE nvl(AID.posted_flag,'N') <> 'Y'
2536: ,ASAT.invoice_distribution_id aid_invoice_dist_id
2537: ,ASAT.parent_reversal_id aid_parent_reversal_id
2538: ,ASAT.po_distribution_id po_distribution_id
2539: ,ASAT.invoice_id bus_flow_inv_id
2540: ,Decode (IGC.CC_LINE, null, 'PO_DISTRIBUTIONS_ALL', IGC.CC_DIST_TYPE) Bus_Flow_PO_Dist_Type
2541: ,Decode (IGC.CC_LINE, null, Decode (pod.po_release_id, NULL, 'PURCHASE_ORDER', 'RELEASE'), IGC.CC_ENTITY_CODE) Bus_Flow_PO_Entity_Code
2542: ,Decode (IGC.CC_LINE, null, Decode (pod.po_release_id, NULL, pod.po_header_id,pod.po_release_id),IGC.cc_doc_id) Bus_Flow_PO_Doc_Id
2543: ,ASAT.project_id aid_project_id
2544: ,ASAT.task_id aid_task_id
2553: ,NVL(ASAT.amount,0) - NVL(ASAT.amount_variance,0)
2554: - NVL(ASAT.quantity_variance,0) encumbrance_amount
2555: ,ASAT.CHARGE_APPLICABLE_TO_DIST_ID charge_applicable_to_dist_id
2556: FROM AP_SELF_ASSESSED_TAX_DIST_ALL ASAT,
2557: PO_DISTRIBUTIONS_ALL POD,
2558: IGC_CC_SLA_BFLOW_PRIOR_V IGC
2559: WHERE nvl(ASAT.posted_flag,'N') <> 'Y'
2560: AND ASAT.po_distribution_id = POD.po_distribution_id(+)
2561: AND ASAT.po_distribution_id = IGC.po_distribution_id(+)
2673: decode(pll.accrue_on_receipt_flag, 'Y', 'F07',NULL)),
2674: poh.vendor_id,
2675: adl.ind_compiled_set_id,
2676: pod.rate -- Bug 5614467
2677: FROM po_distributions_all pod,
2678: po_headers_all poh,
2679: po_lines_all pol, --BUG 3022249
2680: po_line_locations_all pll, -- BUG 3022249
2681: gms_award_distributions adl
2805: l_prepay_exists VARCHAR2(1);
2806: l_stdinvoice_exists VARCHAR2(1);
2807: l_counter NUMBER;
2808: l_debug_start_counter NUMBER;
2809: l_po_award_id po_distributions_all.award_id%TYPE;
2810: l_po_result_code gms_bc_packets.result_code%TYPE;
2811: l_po_vendor_id po_headers_all.vendor_id%TYPE;
2812: l_po_ind_com_set_id gms_award_distributions.ind_compiled_set_id%TYPE;
2813:
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'
8326: AND gl.packet_id = pkt.packet_id