[Home] [Help]
1342:
1343: CURSOR c_po_miss_adls (p_po_distribution_id NUMBER) IS
1344: SELECT pod.award_id award_set_id,
1345: adl.adl_status -- Bug 2155774
1346: FROM po_distributions_all pod,
1347: gms_award_distributions adl
1348: WHERE pod.po_distribution_id = p_po_distribution_id
1349: AND pod.award_id IS NOT NULL
1350: AND pod.award_id = adl.award_set_id
1395: AND pd.award_id <> adl2.award_set_id
1396: UNION ALL
1397: SELECT adl2.award_set_id,adl2.document_type
1398: FROM gms_award_distributions adl2,
1399: po_distributions_all pd
1400: WHERE g_document_type_tab(i) = 'PO'
1401: AND adl2.document_type = 'PO'
1402: AND adl2.adl_line_num = 1
1403: AND adl2.po_distribution_id = pd.po_distribution_id
2447: decode(pll.accrue_on_receipt_flag, 'Y', 'F07',NULL)),
2448: poh.vendor_id,
2449: adl.ind_compiled_set_id,
2450: pod.rate -- Bug 5614467
2451: FROM po_distributions_all pod,
2452: po_headers_all poh,
2453: po_lines_all pol, --BUG 3022249
2454: po_line_locations_all pll, -- BUG 3022249
2455: gms_award_distributions adl
2534: l_prepay_exists VARCHAR2(1);
2535: l_stdinvoice_exists VARCHAR2(1);
2536: l_counter NUMBER;
2537: l_debug_start_counter NUMBER;
2538: l_po_award_id po_distributions_all.award_id%TYPE;
2539: l_po_result_code gms_bc_packets.result_code%TYPE;
2540: l_po_vendor_id po_headers_all.vendor_id%TYPE;
2541: l_po_ind_com_set_id gms_award_distributions.ind_compiled_set_id%TYPE;
2542:
7962: adl.award_id award_id
7963: FROM gms_bc_packets pkt,
7964: gl_bc_packets gl,
7965: ap_invoice_distributions_all ap,
7966: po_distributions_all pod,
7967: gms_award_distributions adl
7968: WHERE pkt.packet_id = x_packet_id
7969: AND pkt.document_type = 'AP'
7970: AND gl.packet_id = pkt.packet_id