DBA Data[Home] [Help]

APPS.OE_2PC2_ORDLINS_BRANCH dependencies on OE_AK_ORDER_LINES_V

Line 28: FROM OE_AK_ORDER_LINES_V b

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

Line 34: FROM OE_AK_ORDER_LINES_V b

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