DBA Data[Home] [Help]

APPS.OE_1018PC2_LINE_ATOCOMP 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_HEADER_SECURITY.g_record.ORDER_NUMBER
20: AND a.ATO_LINE_ID IS NOT NULL
21: AND a.ITEM_TYPE_CODE <> 'STANDARD'
22: ;

Line 26: FROM OE_AK_ORDER_LINES_V a

22: ;
23:
24: CURSOR C_RSC IS
25: SELECT count(*)
26: FROM OE_AK_ORDER_LINES_V a
27: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
28: ;
29:
30: BEGIN