eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_POR_EXT_ITEM dependencies on PO_REQEXPRESS_LINES_ALL

Line 1423: FROM po_reqexpress_lines_all r1,

1419: AND p2.rowid <> p.rowid
1420: AND ((p2.last_update_date > p.last_update_date) OR
1421: (p2.last_update_date = p.last_update_date AND
1422: EXISTS (SELECT 'exists'
1423: FROM po_reqexpress_lines_all r1,
1424: po_reqexpress_lines_all r2
1425: WHERE r2.express_name = p2.template_id
1426: AND r2.sequence_num = p2. template_line_id
1427: AND nvl(r2.org_id, -2) = p2.org_id

Line 1424: po_reqexpress_lines_all r2

1420: AND ((p2.last_update_date > p.last_update_date) OR
1421: (p2.last_update_date = p.last_update_date AND
1422: EXISTS (SELECT 'exists'
1423: FROM po_reqexpress_lines_all r1,
1424: po_reqexpress_lines_all r2
1425: WHERE r2.express_name = p2.template_id
1426: AND r2.sequence_num = p2. template_line_id
1427: AND nvl(r2.org_id, -2) = p2.org_id
1428: AND r1.express_name = p.template_id

Line 1447: FROM po_reqexpress_lines_all r1,

1443: AND p2.rowid <> p.rowid
1444: AND ((p2.last_update_date > p.last_update_date) OR
1445: (p2.last_update_date = p.last_update_date AND
1446: EXISTS (SELECT 'exists'
1447: FROM po_reqexpress_lines_all r1,
1448: po_reqexpress_lines_all r2
1449: WHERE r2.express_name = p2.template_id
1450: AND r2.sequence_num = p2. template_line_id
1451: AND nvl(r2.org_id, -2) = p2.org_id

Line 1448: po_reqexpress_lines_all r2

1444: AND ((p2.last_update_date > p.last_update_date) OR
1445: (p2.last_update_date = p.last_update_date AND
1446: EXISTS (SELECT 'exists'
1447: FROM po_reqexpress_lines_all r1,
1448: po_reqexpress_lines_all r2
1449: WHERE r2.express_name = p2.template_id
1450: AND r2.sequence_num = p2. template_line_id
1451: AND nvl(r2.org_id, -2) = p2.org_id
1452: AND r1.express_name = p.template_id

Line 1493: FROM po_reqexpress_lines_all r1,

1489: --Bug 4349235
1490: AND ((p2.last_update_date > p.last_update_date) OR
1491: (p2.last_update_date = p.last_update_date AND
1492: EXISTS (SELECT 'exists'
1493: FROM po_reqexpress_lines_all r1,
1494: po_reqexpress_lines_all r2
1495: WHERE r2.express_name = p2.template_id
1496: AND r2.sequence_num = p2. template_line_id
1497: AND nvl(r2.org_id, -2) = p2.org_id

Line 1494: po_reqexpress_lines_all r2

1490: AND ((p2.last_update_date > p.last_update_date) OR
1491: (p2.last_update_date = p.last_update_date AND
1492: EXISTS (SELECT 'exists'
1493: FROM po_reqexpress_lines_all r1,
1494: po_reqexpress_lines_all r2
1495: WHERE r2.express_name = p2.template_id
1496: AND r2.sequence_num = p2. template_line_id
1497: AND nvl(r2.org_id, -2) = p2.org_id
1498: AND r1.express_name = p.template_id

Line 1542: 'FROM ipo_reqexpress_lines_all t, ' ;

1538: 'SELECT p.rt_item_id, t.item_description, ' ||
1539: ' null, null ' ;
1540: IF (xTestMode = 'Y') THEN
1541: xString := xString ||
1542: 'FROM ipo_reqexpress_lines_all t, ' ;
1543: ELSE
1544: xString := xString ||
1545: 'FROM po_reqexpress_lines_all t, ' ;
1546: END IF;

Line 1545: 'FROM po_reqexpress_lines_all t, ' ;

1541: xString := xString ||
1542: 'FROM ipo_reqexpress_lines_all t, ' ;
1543: ELSE
1544: xString := xString ||
1545: 'FROM po_reqexpress_lines_all t, ' ;
1546: END IF;
1547: xString := xString ||
1548: ' icx_cat_item_prices p, ' ||
1549: ' icx_cat_extract_gt i ' ||

Line 5732: 'ipo_reqexpress_lines_all prl, '||

5728: 'FROM icx_por_loader_values l, ';
5729: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
5730: xViewStr2 := xViewStr2 ||
5731: 'ipo_reqexpress_headers_all prh, '||
5732: 'ipo_reqexpress_lines_all prl, '||
5733: 'ipo_headers_all ph, '||
5734: 'ipo_lines_all pl, '||
5735: 'imtl_system_items_kfv mi, '||
5736: 'ipo_vendors icx_pv, '||

Line 5745: 'po_reqexpress_lines_all prl, '||

5741: 'ipo_line_types_b pltb, ';
5742: ELSE
5743: xViewStr2 := xViewStr2 ||
5744: 'po_reqexpress_headers_all prh, '||
5745: 'po_reqexpress_lines_all prl, '||
5746: 'po_headers_all ph, '||
5747: 'po_lines_all pl, '||
5748: 'mtl_system_items_kfv mi, '||
5749: 'po_vendors icx_pv, '||