[Home] [Help]
1877: poh.segment1
1878: INTO l_reference_2,
1879: l_reference_4
1880: FROM po_distributions_all pod,
1881: po_headers_all poh
1882: WHERE pod.po_distribution_id = l_source_distribution_id_num_1
1883: AND pod.po_header_id = poh.po_header_id;
1884: EXCEPTION
1885: WHEN NO_DATA_FOUND THEN
1971: poh.segment1
1972: INTO l_reference_2,
1973: l_reference_4
1974: FROM po_distributions_all pod,
1975: po_headers_all poh
1976: WHERE pod.po_distribution_id = l_applied_to_dist_id_num_1
1977: AND pod.po_header_id = poh.po_header_id;
1978: EXCEPTION
1979: WHEN NO_DATA_FOUND THEN
2370: fvv.eliminations_id
2371: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2372: FROM rcv_transactions rt,
2373: po_vendors v,
2374: po_headers_all ph,
2375: fv_facts_vendors_v fvv
2376: WHERE rt.po_header_id = to_number(l_reference_2)
2377: AND rt.transaction_id = to_number(l_reference_5)
2378: AND rt.po_header_id = ph.po_header_id
2417: fvv.eliminations_id
2418: INTO l_vendor_id,
2419: l_vendor_type,
2420: l_eliminations_id
2421: FROM po_vendors pov, po_headers_all poh,
2422: fv_facts_vendors_v fvv
2423: WHERE poh.po_header_id = to_number(l_reference_2)
2424: AND pov.vendor_id = poh.vendor_id
2425: AND fvv.vendor_id = poh.vendor_id;
3329: WHERE to_char(distribution_id) = p_reference3;
3330:
3331: CURSOR Pur_Pur IS
3332: SELECT start_date, creation_date, created_by
3333: FROM po_headers_all
3334: WHERE segment1 = p_reference2;
3335:
3336: CURSOR Pur_Pur IS
3337: SELECT gl_encumbered_date, creation_date, created_by
3475: IF g_pur_order_date_seg IS NOT NULL THEN
3476: l_gl_date := NULL;
3477: l_select :=
3478: 'SELECT h.'||g_pur_order_date_seg||', h.creation_date, h.created_by, d.gl_encumbered_date
3479: FROM po_headers_all h,
3480: po_distributions_all d
3481: WHERE h.po_header_id = '||p_reference2 ||'
3482: AND h.po_header_id = d.po_header_id
3483: AND d.po_distribution_id = '||p_reference3;
3498: EXCEPTION WHEN OTHERS THEN
3499: l_gl_date := NULL;
3500: l_select :=
3501: 'SELECT h.creation_date, h.creation_date, h.created_by, d.gl_encumbered_date
3502: FROM po_headers_all h,
3503: po_distributions_all d
3504: WHERE h.po_header_id = '||p_reference2 ||'
3505: AND h.po_header_id = d.po_header_id
3506: AND d.po_distribution_id = '||p_reference3;
3516: ELSE -- g_pur_order_date_seg is null
3517: l_gl_date := NULL;
3518: l_select :=
3519: 'SELECT h.creation_date, h.creation_date, h.created_by, d.gl_encumbered_date
3520: FROM po_headers_all h,
3521: po_distributions_all d
3522: WHERE h.po_header_id = '||p_reference2 ||'
3523: AND h.po_header_id = d.po_header_id
3524: AND d.po_distribution_id = '||p_reference3;