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_MOD_SYNC_PROCESS_PVT dependencies on PO_LINE_UCAS

Line 1907: FROM po_line_ucas

1903: FORALL i in 1.. l_po_line_id_tbl.COUNT
1904: UPDATE po_lines_draft_all
1905: SET clm_approved_undef_amount = nvl(l_base_clm_app_undef_amt_tbl(i),0)
1906: + nvl((SELECT undef_amount
1907: FROM po_line_ucas
1908: WHERE po_line_id = L_po_line_id_tbl(i)
1909: AND undef_draft_id = p_draft_id),0)
1910: - (SELECT Nvl(SUM(undef_amount), 0)
1911: FROM po_line_ucas

Line 1911: FROM po_line_ucas

1907: FROM po_line_ucas
1908: WHERE po_line_id = L_po_line_id_tbl(i)
1909: AND undef_draft_id = p_draft_id),0)
1910: - (SELECT Nvl(SUM(undef_amount), 0)
1911: FROM po_line_ucas
1912: WHERE po_line_id = L_po_line_id_tbl(i)
1913: AND def_draft_id = p_draft_id),
1914: clm_undef_flag = (SELECT Nvl(Max('Y'), l_base_clm_undef_flag_tbl(i))
1915: FROM po_line_ucas

Line 1915: FROM po_line_ucas

1911: FROM po_line_ucas
1912: WHERE po_line_id = L_po_line_id_tbl(i)
1913: AND def_draft_id = p_draft_id),
1914: clm_undef_flag = (SELECT Nvl(Max('Y'), l_base_clm_undef_flag_tbl(i))
1915: FROM po_line_ucas
1916: WHERE po_line_id = l_po_line_id_tbl(i)
1917: AND undef_draft_id = p_draft_id
1918: AND def_draft_id IS NULL),
1919: clm_undef_action_code = l_draft_CLM_UNDEF_ACTION_CODE(i)