APPS.OE_1018PC2_LINE_RCVED dependencies on OE_BLANKET_HEADER_SECURITY
Line 19: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
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.SHIPPED_QUANTITY <> 0
21: AND a.LINE_CATEGORY_CODE = 'RETURN'
22: AND a.SHIPPED_QUANTITY IS NOT NULL
23: ;
Line 28: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
24:
25: CURSOR C_RSC IS
26: SELECT count(*)
27: FROM OE_AK_ORDER_LINES_V a 28: WHERE a.BLANKET_NUMBER = OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER 29: ;
30:
31: BEGIN
32: x_result := 0;