APPS.ICX_POR_EXT_DIAG dependencies on PO_REQEXPRESS_LINES_ALL

Line 778: po_reqexpress_lines_all prl,

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
782: AND (prh.org_id is null and pOperatingUnitId is null or prh.org_id = pOperatingUnitId)

Line 1696: 'ipo_reqexpress_lines_all prl, ' ||

1692: VALID_FOR_EXTRACT || ')) ' ||
1693: 'FROM ';
1694: IF p_test_mode = 'Y' THEN
1695: xString := xString ||
1696: 'ipo_reqexpress_lines_all prl, ' ||
1697: 'imtl_system_items_kfv mi, ' ||
1698: 'ifinancials_system_params_all fsp ' ;
1699: ELSE
1700: xString := xString ||

Line 1701: 'po_reqexpress_lines_all prl, ' ||

1697: 'imtl_system_items_kfv mi, ' ||
1698: 'ifinancials_system_params_all fsp ' ;
1699: ELSE
1700: xString := xString ||
1701: 'po_reqexpress_lines_all prl, ' ||
1702: 'mtl_system_items_kfv mi, ' ||
1703: 'financials_system_params_all fsp ';
1704: END IF;
1705:

Line 1884: 'ipo_reqexpress_lines_all prl ';

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, '||
1888: 'po_reqexpress_lines_all prl ';

Line 1888: 'po_reqexpress_lines_all prl ';

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 ' ||
1892: 'AND p.org_id = nvl(prh.org_id, '||ICX_POR_EXT_ITEM.NULL_NUMBER||') '||