APPS.FV_GTAS_TRX_REGISTER dependencies on PO_REQUISITION_HEADERS_ALL

Line 2503: po_requisition_headers_all poh,

2499: poh.segment1
2500: INTO l_reference_2,
2501: l_reference_4
2502: FROM po_req_distributions_all pod,
2503: po_requisition_headers_all poh,
2504: po_requisition_lines_all pol
2505: WHERE pod.distribution_id = l_source_distribution_id_num_1
2506: AND pol.requisition_header_id = poh.requisition_header_id
2507: AND pod.requisition_line_id = pol.requisition_line_id;

Line 3556: FROM po_requisition_headers_all

3552: IF g_req_date_seg IS NOT NULL THEN
3553: l_select :=
3554: 'SELECT '||g_req_date_seg||',
3555: creation_date, created_by
3556: FROM po_requisition_headers_all
3557: WHERE requisition_header_id = '||
3558: to_number(p_reference2) ;
3559:
3560:

Line 3575: FROM po_requisition_headers_all

3571:
3572: EXCEPTION WHEN OTHERS THEN
3573: l_select :=
3574: 'SELECT creation_date, creation_date, created_by
3575: FROM po_requisition_headers_all
3576: WHERE requisition_header_id = '
3577: ||to_number(p_reference2) ;
3578:
3579: OPEN pur_req FOR l_select ;

Line 3589: FROM po_requisition_headers_all

3585:
3586: ELSE -- g_req_date_seg is null
3587: l_select :=
3588: 'SELECT creation_date, creation_date, created_by
3589: FROM po_requisition_headers_all
3590: WHERE requisition_header_id = '||to_number(p_reference2) ;
3591:
3592: OPEN pur_req FOR l_select ;
3593: FETCH pur_req INTO l_doc_date,