APPS.FV_FACTS_TRX_REGISTER dependencies on PO_DISTRIBUTIONS_ALL

Line 1872: IF (l_source_distribution_type ='PO_DISTRIBUTIONS_ALL') THEN

1868: END;
1869:
1870: END IF;
1871: ELSIF (l_source = 'Purchasing' AND l_category = 'Purchases') THEN
1872: IF (l_source_distribution_type ='PO_DISTRIBUTIONS_ALL') THEN
1873: l_reference_1 := 'PO';
1874: l_reference_3 := l_source_distribution_id_num_1;
1875: BEGIN
1876: SELECT poh.po_header_id,

Line 1880: FROM po_distributions_all pod,

1876: SELECT poh.po_header_id,
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

Line 1974: FROM po_distributions_all pod,

1970: SELECT poh.po_header_id,
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

Line 3338: FROM po_distributions_all

3334: WHERE segment1 = p_reference2;
3335:
3336: CURSOR Pur_Pur IS
3337: SELECT gl_encumbered_date, creation_date, created_by
3338: FROM po_distributions_all
3339: WHERE to_char(po_distribution_id) = p_reference3;
3340: */
3341: CURSOR Manual IS
3342: SELECT default_effective_date

Line 3480: po_distributions_all d

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;
3484:

Line 3503: po_distributions_all d

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;
3507:

Line 3521: po_distributions_all d

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;
3525: