APPS.OE_1019PC2_LINE_RCVED dependencies on OE_BLANKET_LINE_SECURITY

Line 19: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_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_LINE_SECURITY.g_record.ORDER_NUMBER
20: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
21: AND a.SHIPPED_QUANTITY IS NOT NULL
22: AND a.SHIPPED_QUANTITY <> 0
23: AND a.LINE_CATEGORY_CODE = 'RETURN'

Line 20: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER

16: CURSOR C_VC IS
17: SELECT count(*)
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.SHIPPED_QUANTITY IS NOT NULL
22: AND a.SHIPPED_QUANTITY <> 0
23: AND a.LINE_CATEGORY_CODE = 'RETURN'
24: ;

Line 29: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER

25:
26: CURSOR C_RSC IS
27: SELECT count(*)
28: FROM OE_AK_ORDER_LINES_V a
29: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
30: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
31: ;
32:
33: BEGIN

Line 30: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER

26: CURSOR C_RSC IS
27: SELECT count(*)
28: FROM OE_AK_ORDER_LINES_V a
29: WHERE a.BLANKET_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.ORDER_NUMBER
30: AND a.BLANKET_LINE_NUMBER = OE_BLANKET_LINE_SECURITY.g_record.LINE_NUMBER
31: ;
32:
33: BEGIN
34: x_result := 0;