APPS.OE_1019PC2_LINE_SHPCNF 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.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
20: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
21: AND a.LINE_CATEGORY_CODE = 'ORDER'
22: AND a.SHIPPED_QUANTITY IS NOT NULL

Line 27: FROM OE_AK_ORDER_LINES_V a

23: ;
24:
25: CURSOR C_RSC IS
26: SELECT count(*)
27: FROM OE_AK_ORDER_LINES_V a
28: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
29: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
30: ;
31: