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_CRTSUP dependencies on OE_AK_ORDER_LINES_V

Line 28: FROM OE_AK_ORDER_LINES_V a

24: AND wpa.activity_name = l_wf_activity_name
25: AND w.activity_status = l_wf_activity_status_code
26: AND w.item_key IN
27: ( SELECT a.LINE_ID || ''
28: FROM OE_AK_ORDER_LINES_V a
29: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
30: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
31: )
32: ;

Line 36: FROM OE_AK_ORDER_LINES_V a

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