[Home] [Help]
1808: poh.segment1
1809: INTO l_reference_2,
1810: l_reference_4
1811: FROM po_distributions_all pod,
1812: po_headers_all poh
1813: WHERE pod.po_distribution_id = l_source_distribution_id_num_1
1814: AND pod.po_header_id = poh.po_header_id;
1815: EXCEPTION
1816: WHEN NO_DATA_FOUND THEN
1891: poh.segment1
1892: INTO l_reference_2,
1893: l_reference_4
1894: FROM po_distributions_all pod,
1895: po_headers_all poh
1896: WHERE pod.po_distribution_id = l_applied_to_dist_id_num_1
1897: AND pod.po_header_id = poh.po_header_id;
1898: EXCEPTION
1899: WHEN NO_DATA_FOUND THEN
2284: fvv.eliminations_id
2285: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2286: FROM rcv_transactions rt,
2287: po_vendors v,
2288: po_headers_all ph,
2289: fv_facts_vendors_v fvv
2290: WHERE rt.po_header_id = to_number(l_reference_2)
2291: AND rt.transaction_id = to_number(l_reference_5)
2292: AND rt.po_header_id = ph.po_header_id
2331: fvv.eliminations_id
2332: INTO l_vendor_id,
2333: l_vendor_type,
2334: l_eliminations_id
2335: FROM po_vendors pov, po_headers_all poh,
2336: fv_facts_vendors_v fvv
2337: WHERE poh.po_header_id = to_number(l_reference_2)
2338: AND pov.vendor_id = poh.vendor_id
2339: AND fvv.vendor_id = poh.vendor_id;
3115: WHERE to_char(distribution_id) = p_reference3;
3116:
3117: CURSOR Pur_Pur IS
3118: SELECT start_date, creation_date, created_by
3119: FROM po_headers_all
3120: WHERE segment1 = p_reference2;
3121:
3122: CURSOR Pur_Pur IS
3123: SELECT gl_encumbered_date, creation_date, created_by
3267: THEN
3268: l_gl_date := NULL;
3269: l_select :=
3270: 'SELECT h.'||g_pur_order_date_seg||', h.creation_date, h.created_by, d.gl_encumbered_date
3271: FROM po_headers_all h,
3272: po_distributions_all d
3273: WHERE h.po_header_id = '||p_reference2 ||'
3274: AND h.po_header_id = d.po_header_id
3275: AND d.po_distribution_id = '||p_reference3;
3290: EXCEPTION WHEN OTHERS THEN
3291: l_gl_date := NULL;
3292: l_select :=
3293: 'SELECT h.creation_date, h.creation_date, h.created_by, d.gl_encumbered_date
3294: FROM po_headers_all h,
3295: po_distributions_all d
3296: WHERE h.po_header_id = '||p_reference2 ||'
3297: AND h.po_header_id = d.po_header_id
3298: AND d.po_distribution_id = '||p_reference3;
3308: ELSE -- g_pur_order_date_seg is null
3309: l_gl_date := NULL;
3310: l_select :=
3311: 'SELECT h.creation_date, h.creation_date, h.created_by, d.gl_encumbered_date
3312: FROM po_headers_all h,
3313: po_distributions_all d
3314: WHERE h.po_header_id = '||p_reference2 ||'
3315: AND h.po_header_id = d.po_header_id
3316: AND d.po_distribution_id = '||p_reference3;