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.OE_1019PC2_LINE_RTLAPVD dependencies on OE_AK_ORDER_LINES_V

Line 30: FROM OE_AK_ORDER_LINES_V a

26: AND w.activity_status = l_wf_activity_status_code
27: AND w.activity_result_code = l_wf_activity_result_code
28: AND w.item_key IN
29: ( SELECT a.LINE_ID || ''
30: FROM OE_AK_ORDER_LINES_V a
31: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
32: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
33: )
34: ;

Line 38: FROM OE_AK_ORDER_LINES_V a

34: ;
35:
36: CURSOR C_RSC IS
37: SELECT count(*)
38: FROM OE_AK_ORDER_LINES_V a
39: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
40: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
41: ;
42: