APPS.OE_1PC2_LINE_INVIFAC 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.HEADER_ID = OE_HEADER_SECURITY.g_record.HEADER_ID
32: )
33: ;
34:
Line 37: FROM OE_AK_ORDER_LINES_V a
33: ;
34:
35: CURSOR C_RSC IS
36: SELECT count(*) 37: FROM OE_AK_ORDER_LINES_V a 38: WHERE a.HEADER_ID = OE_HEADER_SECURITY.g_record.HEADER_ID
39: ;
40:
41: BEGIN