APPS.FV_FACTS_TRX_REGISTER dependencies on PO_REQUISITION_HEADERS_ALL

Line 1828: po_requisition_headers_all poh,

1824: poh.segment1
1825: INTO l_reference_2,
1826: l_reference_4
1827: FROM po_req_distributions_all pod,
1828: po_requisition_headers_all poh,
1829: po_requisition_lines_all pol
1830: WHERE pod.distribution_id = l_source_distribution_id_num_1
1831: AND pol.requisition_header_id = poh.requisition_header_id
1832: AND pod.requisition_line_id = pol.requisition_line_id;

Line 1847: po_requisition_headers_all poh,

1843: poh.segment1
1844: INTO l_reference_2,
1845: l_reference_4
1846: FROM po_req_distributions_all pod,
1847: po_requisition_headers_all poh,
1848: po_requisition_lines_all pol
1849: WHERE pod.distribution_id = l_source_distribution_id_num_1
1850: AND pol.requisition_header_id = poh.requisition_header_id
1851: AND pod.requisition_line_id = pol.requisition_line_id;

Line 3109: FROM po_requisition_headers_all

3105: AND h.doc_id = d.doc_id;
3106: /*
3107: CURSOR Pur_Req IS
3108: SELECT start_date_active, creation_date, created_by
3109: FROM po_requisition_headers_all
3110: WHERE to_char(requisition_header_id) = p_reference2;
3111:
3112: CURSOR Pur_Req IS
3113: SELECT gl_encumbered_date, creation_date, created_by

Line 3218: FROM po_requisition_headers_all

3214: IF g_req_date_seg IS NOT NULL
3215: THEN
3216: l_select :=
3217: 'SELECT '||g_req_date_seg||', creation_date, created_by
3218: FROM po_requisition_headers_all
3219: WHERE requisition_header_id = '||to_number(p_reference2) ;
3220:
3221:
3222: OPEN pur_req FOR l_select ;

Line 3236: FROM po_requisition_headers_all

3232:
3233: EXCEPTION WHEN OTHERS THEN
3234: l_select :=
3235: 'SELECT creation_date, creation_date, created_by
3236: FROM po_requisition_headers_all
3237: WHERE requisition_header_id = '||to_number(p_reference2) ;
3238:
3239: OPEN pur_req FOR l_select ;
3240: FETCH pur_req INTO l_doc_date,

Line 3249: FROM po_requisition_headers_all

3245:
3246: ELSE -- g_req_date_seg is null
3247: l_select :=
3248: 'SELECT creation_date, creation_date, created_by
3249: FROM po_requisition_headers_all
3250: WHERE requisition_header_id = '||to_number(p_reference2) ;
3251:
3252: OPEN pur_req FOR l_select ;
3253: FETCH pur_req INTO l_doc_date,