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.OKE_NUMBER_SEQUENCES_PKG dependencies on OKC_K_LINES_B

Line 302: FROM okc_k_lines_b d

298: AND ONO.buy_or_sell = CH.buy_or_sell;
299:
300: CURSOR PrntLnNum IS
301: SELECT Line_Number
302: FROM okc_k_lines_b d
303: WHERE ID = X_Parent_Line_ID;
304:
305: CURSOR LineNum IS
306: SELECT Line_Number

Line 307: FROM okc_k_lines_b d

303: WHERE ID = X_Parent_Line_ID;
304:
305: CURSOR LineNum IS
306: SELECT Line_Number
307: FROM okc_k_lines_b d
308: WHERE Dnz_Chr_ID = X_K_Header_ID
309: AND NVL(CLe_ID,-1) = NVL(X_Parent_Line_ID,-1)
310: AND ltrim(Line_Number,'0') = (
311: SELECT TO_CHAR(MAX(TO_NUMBER(Line_Number)))

Line 312: FROM okc_k_lines_b

308: WHERE Dnz_Chr_ID = X_K_Header_ID
309: AND NVL(CLe_ID,-1) = NVL(X_Parent_Line_ID,-1)
310: AND ltrim(Line_Number,'0') = (
311: SELECT TO_CHAR(MAX(TO_NUMBER(Line_Number)))
312: FROM okc_k_lines_b
313: WHERE Dnz_Chr_ID = d.Dnz_Chr_ID
314: AND NVL(CLe_ID,-1) = NVL(X_Parent_Line_ID,-1)
315: AND OKE_NUMBER_SEQUENCES_PKG.Value_Is_Numeric
316: (Line_Number) = 'Y'