APPS.FV_GTAS_TRX_REGISTER dependencies on PO_DISTRIBUTIONS_ALL

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

2437:
2438: END IF;
2439: ELSIF (l_source = 'Purchasing' AND
2440: l_category = 'Purchases') THEN
2441: IF (l_source_distribution_type ='PO_DISTRIBUTIONS_ALL') THEN
2442: l_reference_1 := 'PO';
2443: l_reference_3 := l_source_distribution_id_num_1;
2444: BEGIN
2445: SELECT poh.po_header_id,

Line 2449: FROM po_distributions_all pod,

2445: SELECT poh.po_header_id,
2446: poh.segment1
2447: INTO l_reference_2,
2448: l_reference_4
2449: FROM po_distributions_all pod,
2450: po_headers_all poh
2451: WHERE pod.po_distribution_id = l_source_distribution_id_num_1
2452: AND pod.po_header_id = poh.po_header_id;
2453: EXCEPTION

Line 2475: FROM po_distributions_all pod,

2471: SELECT poh.po_header_id,
2472: poh.segment1
2473: INTO l_reference_2,
2474: l_reference_4
2475: FROM po_distributions_all pod,
2476: po_headers_all poh
2477: WHERE pod.po_distribution_id = l_reference_3
2478: AND pod.po_header_id = poh.po_header_id;
2479: /*

Line 2553: FROM po_distributions_all pod,

2549: SELECT poh.po_header_id,
2550: poh.segment1
2551: INTO l_reference_2,
2552: l_reference_4
2553: FROM po_distributions_all pod,
2554: po_headers_all poh
2555: WHERE pod.po_distribution_id = l_applied_to_dist_id_num_1
2556: AND pod.po_header_id = poh.po_header_id;
2557: EXCEPTION

Line 3610: po_distributions_all d

3606: l_select :=
3607: 'SELECT h.'||g_pur_order_date_seg||', h.creation_date,
3608: h.created_by, d.gl_encumbered_date
3609: FROM po_headers_all h,
3610: po_distributions_all d
3611: WHERE h.po_header_id = '||p_reference2 ||'
3612: AND h.po_header_id = d.po_header_id
3613: AND d.po_distribution_id = '||p_reference3;
3614:

Line 3634: po_distributions_all d

3630: l_select :=
3631: 'SELECT h.creation_date, h.creation_date,
3632: h.created_by, d.gl_encumbered_date
3633: FROM po_headers_all h,
3634: po_distributions_all d
3635: WHERE h.po_header_id = '||p_reference2 ||'
3636: AND h.po_header_id = d.po_header_id
3637: AND d.po_distribution_id = '||p_reference3;
3638:

Line 3653: po_distributions_all d

3649: l_select :=
3650: 'SELECT h.creation_date, h.creation_date,
3651: h.created_by, d.gl_encumbered_date
3652: FROM po_headers_all h,
3653: po_distributions_all d
3654: WHERE h.po_header_id = '||p_reference2 ||'
3655: AND h.po_header_id = d.po_header_id
3656: AND d.po_distribution_id = '||p_reference3;
3657: