APPS.FV_FACTS_TRX_REGISTER dependencies on PO_REQUISITION_HEADERS_ALL

Line 1900: po_requisition_headers_all poh,

1896: --, poh.segment1
1897: INTO l_reference_2
1898: --, l_reference_4
1899: FROM po_req_distributions_all pod,
1900: po_requisition_headers_all poh,
1901: po_requisition_lines_all pol
1902: WHERE pod.distribution_id = l_source_distribution_id_num_1
1903: AND pol.requisition_header_id = poh.requisition_header_id
1904: AND pod.requisition_line_id = pol.requisition_line_id;

Line 1927: po_requisition_headers_all poh,

1923: poh.segment1
1924: INTO l_reference_2,
1925: l_reference_4
1926: FROM po_req_distributions_all pod,
1927: po_requisition_headers_all poh,
1928: po_requisition_lines_all pol
1929: WHERE pod.distribution_id = l_source_distribution_id_num_1
1930: AND pol.requisition_header_id = poh.requisition_header_id
1931: AND pod.requisition_line_id = pol.requisition_line_id;

Line 3323: FROM po_requisition_headers_all

3319: AND h.doc_id = d.doc_id;
3320: /*
3321: CURSOR Pur_Req IS
3322: SELECT start_date_active, creation_date, created_by
3323: FROM po_requisition_headers_all
3324: WHERE to_char(requisition_header_id) = p_reference2;
3325:
3326: CURSOR Pur_Req IS
3327: SELECT gl_encumbered_date, creation_date, created_by

Line 3428: FROM po_requisition_headers_all

3424: IF g_req_date_seg IS NOT NULL
3425: THEN
3426: l_select :=
3427: 'SELECT '||g_req_date_seg||', creation_date, created_by
3428: FROM po_requisition_headers_all
3429: WHERE requisition_header_id = '||to_number(p_reference2) ;
3430:
3431:
3432: OPEN pur_req FOR l_select ;

Line 3446: FROM po_requisition_headers_all

3442:
3443: EXCEPTION WHEN OTHERS THEN
3444: l_select :=
3445: 'SELECT creation_date, creation_date, created_by
3446: FROM po_requisition_headers_all
3447: WHERE requisition_header_id = '||to_number(p_reference2) ;
3448:
3449: OPEN pur_req FOR l_select ;
3450: FETCH pur_req INTO l_doc_date,

Line 3459: FROM po_requisition_headers_all

3455:
3456: ELSE -- g_req_date_seg is null
3457: l_select :=
3458: 'SELECT creation_date, creation_date, created_by
3459: FROM po_requisition_headers_all
3460: WHERE requisition_header_id = '||to_number(p_reference2) ;
3461:
3462: OPEN pur_req FOR l_select ;
3463: FETCH pur_req INTO l_doc_date,