APPS.ICX_POR_EXT_DIAG dependencies on PO_REQEXPRESS_HEADERS_ALL

Line 508: FROM po_reqexpress_headers_all

504: xErrLoc := 100;
505: BEGIN
506: SELECT inactive_date
507: INTO xInactiveDate
508: FROM po_reqexpress_headers_all
509: WHERE express_name = pValue
510: AND rownum = 1;
511: EXCEPTION
512: WHEN OTHERS THEN

Line 777: FROM po_reqexpress_headers_all prh,

773: prl.category_id
774: INTO xStatus,
775: xItemNum,
776: xCategoryId
777: FROM po_reqexpress_headers_all prh,
778: po_reqexpress_lines_all prl,
779: financials_system_params_all fsp,
780: mtl_system_items_kfv mi
781: WHERE prh.express_name = pTemplateName

Line 1883: 'ipo_reqexpress_headers_all prh, '||

1879: 'p.contract_line_id '||
1880: 'FROM icx_cat_item_prices p, ';
1881: IF p_test_mode = 'Y' THEN
1882: xString := xString ||
1883: 'ipo_reqexpress_headers_all prh, '||
1884: 'ipo_reqexpress_lines_all prl ';
1885: ELSE
1886: xString := xString ||
1887: 'po_reqexpress_headers_all prh, '||

Line 1887: 'po_reqexpress_headers_all prh, '||

1883: 'ipo_reqexpress_headers_all prh, '||
1884: 'ipo_reqexpress_lines_all prl ';
1885: ELSE
1886: xString := xString ||
1887: 'po_reqexpress_headers_all prh, '||
1888: 'po_reqexpress_lines_all prl ';
1889: END IF;
1890: xString := xString ||
1891: 'WHERE p.rowid = :row_id ' ||