APPS.OE_1PC2_LINE_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.HEADER_ID = OE_HEADER_SECURITY.g_record.HEADER_ID
20: AND a.SHIPPED_QUANTITY IS NOT NULL
21: AND a.SHIPPED_QUANTITY <> 0
22: AND a.LINE_CATEGORY_CODE = 'RETURN'
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.HEADER_ID = OE_HEADER_SECURITY.g_record.HEADER_ID
29: ;
30:
31: BEGIN