APPS.OE_1018PC1_ORDER_RETREJD dependencies on OE_AK_ORDER_HEADERS_V

Line 30: FROM OE_AK_ORDER_HEADERS_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.HEADER_ID || ''
30: FROM OE_AK_ORDER_HEADERS_V a
31: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
32: )
33: ;
34:

Line 37: FROM OE_AK_ORDER_HEADERS_V a

33: ;
34:
35: CURSOR C_RSC IS
36: SELECT count(*)
37: FROM OE_AK_ORDER_HEADERS_V a
38: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
39: ;
40:
41: BEGIN