DBA Data[Home] [Help]

APPS.OE_2PC2_ORDLINS_INVIFAC dependencies on OE_AK_ORDER_LINES_V

Line 30: FROM OE_AK_ORDER_LINES_V b

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 b.LINE_ID || ''
30: FROM OE_AK_ORDER_LINES_V b
31: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
32: );
33:
34: CURSOR C_RSC IS

Line 36: FROM OE_AK_ORDER_LINES_V b

32: );
33:
34: CURSOR C_RSC IS
35: SELECT count(*)
36: FROM OE_AK_ORDER_LINES_V b
37: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
38: ;
39:
40: BEGIN