APPS.OE_2PC2_ATOCON_NAINV 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.INVOICE_INTERFACE_STATUS_CODE = 'NOT_ELIGIBLE'
20: AND ( a.LINE_ID ) IN
21: ( SELECT b.LINE_ID
22: FROM OE_AK_ORDER_LINES_V b

Line 22: FROM OE_AK_ORDER_LINES_V b

18: FROM OE_AK_ORDER_LINES_V a
19: WHERE a.INVOICE_INTERFACE_STATUS_CODE = 'NOT_ELIGIBLE'
20: AND ( a.LINE_ID ) IN
21: ( SELECT b.LINE_ID
22: FROM OE_AK_ORDER_LINES_V b
23: WHERE b.ATO_LINE_ID = OE_LINE_SECURITY.g_record.ATO_LINE_ID
24: AND b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
25: );
26:

Line 29: FROM OE_AK_ORDER_LINES_V b

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