DBA Data[Home] [Help]

APPS.OE_1019PC2_LINE_ATOCOMP dependencies on STANDARD

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

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.ATO_LINE_ID IS NOT NULL
22: AND a.ITEM_TYPE_CODE <> 'STANDARD'
23: ;
24:
25: CURSOR C_RSC IS
26: SELECT count(*)