APPS.OE_2PC2_ATOCON_PRCONF dependencies on OE_AK_ORDER_LINES_V

Line 18: FROM OE_AK_ORDER_LINES_V a

14: l_set_count NUMBER := 0;
15:
16: CURSOR C_VC IS
17: SELECT count(*)
18: FROM OE_AK_ORDER_LINES_V a
19: WHERE a.SHIPPED_QUANTITY IS NOT NULL
20: AND a.SOURCE_TYPE_CODE = 'EXTERNAL'
21: AND ( a.LINE_ID ) IN
22: ( SELECT b.LINE_ID

Line 23: FROM OE_AK_ORDER_LINES_V b

19: WHERE a.SHIPPED_QUANTITY IS NOT NULL
20: AND a.SOURCE_TYPE_CODE = 'EXTERNAL'
21: AND ( a.LINE_ID ) IN
22: ( SELECT b.LINE_ID
23: FROM OE_AK_ORDER_LINES_V b
24: WHERE b.ATO_LINE_ID = OE_LINE_SECURITY.g_record.ATO_LINE_ID
25: AND b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
26: );
27:

Line 30: FROM OE_AK_ORDER_LINES_V b

26: );
27:
28: CURSOR C_RSC IS
29: SELECT count(*)
30: FROM OE_AK_ORDER_LINES_V b
31: WHERE b.ATO_LINE_ID = OE_LINE_SECURITY.g_record.ATO_LINE_ID
32: AND b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
33: ;
34: