APPS.FV_GTAS_TRX_REGISTER dependencies on PO_HEADERS_ALL

Line 2450: po_headers_all poh

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
2454: WHEN NO_DATA_FOUND THEN

Line 2476: po_headers_all poh

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: /*
2480: SELECT transaction_number

Line 2554: po_headers_all poh

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
2558: WHEN NO_DATA_FOUND THEN

Line 2954: po_headers_all ph

2950: substr(v.global_attribute5,1,3)
2951: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2952: FROM rcv_transactions rt,
2953: po_vendors v,
2954: po_headers_all ph
2955: WHERE rt.po_header_id = to_number(l_reference_2)
2956: AND rt.transaction_id = to_number(l_reference_5)
2957: AND rt.po_header_id = ph.po_header_id
2958: AND v.vendor_id = ph.vendor_id;

Line 2990: FROM po_vendors pov, po_headers_all poh

2986: SUBSTR(pov.global_attribute5,1,3)
2987: INTO l_vendor_id,
2988: l_vendor_type,
2989: l_eliminations_id
2990: FROM po_vendors pov, po_headers_all poh
2991: WHERE poh.po_header_id = to_number(l_reference_2)
2992: AND pov.vendor_id = poh.vendor_id;
2993: EXCEPTION
2994: WHEN NO_DATA_FOUND THEN

Line 3609: FROM po_headers_all h,

3605: l_gl_date := NULL;
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;

Line 3633: FROM po_headers_all h,

3629: l_gl_date := NULL;
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;

Line 3652: FROM po_headers_all h,

3648: l_gl_date := NULL;
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;