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.PO_VAL_HEADERS dependencies on PO_LINES_ALL

Line 743: FROM PO_LINES_ALL ORDER_LINE

739: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
740: AND EXISTS
741: (
742: SELECT NULL
743: FROM PO_LINES_ALL ORDER_LINE
744: WHERE ORDER_LINE.from_header_id = p_header_id_tbl(i)
745: AND p_start_date_tbl(i) > ORDER_LINE.creation_date
746: );
747:

Line 1317: PO_LINES_ALL ORDER_LINE

1313: p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
1314: AND EXISTS
1315: ( SELECT NULL
1316: FROM
1317: PO_LINES_ALL ORDER_LINE
1318: , PO_HEADERS_ALL ORDER_HEADER
1319: WHERE
1320: ORDER_LINE.from_header_id = p_header_id_tbl(i)
1321: -- Bug # 13550798 Changed logic based on approved_date

Line 1401: PO_LINES_ALL ORDER_LINE

1397: p_type_lookup_code_tbl(i) = c_CONTRACT
1398: AND EXISTS
1399: ( SELECT NULL
1400: FROM
1401: PO_LINES_ALL ORDER_LINE
1402: , PO_HEADERS_ALL ORDER_HEADER
1403: WHERE
1404: ORDER_LINE.contract_id = p_header_id_tbl(i)
1405: AND TRUNC(p_start_date_tbl(i)) > ORDER_LINE.creation_date

Line 1485: PO_LINES_ALL ORDER_LINE

1481: p_type_lookup_code_tbl(i) = c_CONTRACT
1482: AND EXISTS
1483: ( SELECT NULL
1484: FROM
1485: PO_LINES_ALL ORDER_LINE
1486: , PO_HEADERS_ALL ORDER_HEADER
1487: WHERE
1488: ORDER_LINE.contract_id = p_header_id_tbl(i)
1489: -- Bug # 13550798 Changed logic based on approved_date