APPS.OE_2PC2_CONFIG_RCVED 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.SHIPPED_QUANTITY <> 0
21: AND a.LINE_CATEGORY_CODE = 'RETURN'
22: AND ( a.LINE_ID ) IN

Line 24: FROM OE_AK_ORDER_LINES_V b

20: AND a.SHIPPED_QUANTITY <> 0
21: AND a.LINE_CATEGORY_CODE = 'RETURN'
22: AND ( a.LINE_ID ) IN
23: ( SELECT b.LINE_ID
24: FROM OE_AK_ORDER_LINES_V b
25: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
26: AND b.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_ID
27: );
28:

Line 31: FROM OE_AK_ORDER_LINES_V b

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