DBA Data[Home] [Help]

APPS.OE_2PC2_ORDLINS_ATOCOMP dependencies on STANDARD

Line 20: AND a.ITEM_TYPE_CODE <> 'STANDARD'

16: CURSOR C_VC IS
17: SELECT count(*)
18: FROM OE_AK_ORDER_LINES_V a
19: WHERE a.ATO_LINE_ID IS NOT NULL
20: AND a.ITEM_TYPE_CODE <> 'STANDARD'
21: AND ( a.LINE_ID ) IN
22: ( SELECT b.LINE_ID
23: FROM OE_AK_ORDER_LINES_V b
24: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID