APPS.FV_FACTS_TRX_REGISTER dependencies on PO_DISTRIBUTIONS_ALL

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

1799: END;
1800:
1801: END IF;
1802: ELSIF (l_source = 'Purchasing' AND l_category = 'Purchases') THEN
1803: IF (l_source_distribution_type ='PO_DISTRIBUTIONS_ALL') THEN
1804: l_reference_1 := 'PO';
1805: l_reference_3 := l_source_distribution_id_num_1;
1806: BEGIN
1807: SELECT poh.po_header_id,

Line 1811: FROM po_distributions_all pod,

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

Line 1894: FROM po_distributions_all pod,

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

Line 3124: FROM po_distributions_all

3120: WHERE segment1 = p_reference2;
3121:
3122: CURSOR Pur_Pur IS
3123: SELECT gl_encumbered_date, creation_date, created_by
3124: FROM po_distributions_all
3125: WHERE to_char(po_distribution_id) = p_reference3;
3126: */
3127: CURSOR Manual IS
3128: SELECT default_effective_date

Line 3272: po_distributions_all d

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

Line 3295: po_distributions_all d

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

Line 3313: po_distributions_all d

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