APPS.RCV_BUSINESS_EVENTS dependencies on RCV_TRANSACTIONS

Line 22: FROM rcv_transactions rt

18:
19: CURSOR get_rcv_headers IS
20: SELECT DISTINCT rt.shipment_header_id,
21: GROUP_ID
22: FROM rcv_transactions rt
23: WHERE rt.request_id = p_request_id
24: AND rt.transaction_type = 'RECEIVE'
25: AND NVL(p_group_id, 0) = 0
26: UNION ALL

Line 29: FROM rcv_transactions rt

25: AND NVL(p_group_id, 0) = 0
26: UNION ALL
27: SELECT DISTINCT rt.shipment_header_id,
28: GROUP_ID
29: FROM rcv_transactions rt
30: WHERE rt.GROUP_ID = p_group_id
31: AND rt.request_id in (0, -1, p_request_id) -- for bug 8422764
32: AND rt.transaction_type = 'RECEIVE'
33: AND NVL(p_group_id, 0) <> 0;

Line 39: FROM rcv_transactions rt

35: --Modified for OPSM
36: --------------------------------
37: CURSOR get_rcv_headers_rma IS
38: SELECT DISTINCT rt.shipment_header_id,rt.group_id
39: FROM rcv_transactions rt
40: WHERE rt.request_id = p_request_id
41: AND rt.transaction_type = 'DELIVER'
42: AND nvl(p_group_id,0) = 0
43: UNION ALL

Line 45: FROM rcv_transactions rt

41: AND rt.transaction_type = 'DELIVER'
42: AND nvl(p_group_id,0) = 0
43: UNION ALL
44: SELECT DISTINCT rt.shipment_header_id,rt.group_id
45: FROM rcv_transactions rt
46: WHERE rt.group_id = p_group_id
47: AND rt.request_id in (0, -1, p_request_id)
48: AND rt.transaction_type = 'DELIVER'
49: AND nvl(p_group_id,0) <> 0;

Line 140: FROM rcv_transactions rt,

136: NULL last_update_login,
137: NULL request_id,
138: 0 last_updated_by,
139: SYSDATE last_update_date
140: FROM rcv_transactions rt,
141: rcv_shipment_lines rsl
142: WHERE rt.GROUP_ID = p_group_id
143: AND rt.shipment_line_id = rsl.shipment_line_id
144: AND rsl.osa_flag = 'Y'

Line 148: FROM rcv_transactions prt

144: AND rsl.osa_flag = 'Y'
145: AND ( rt.transaction_type IN('RECEIVE', 'RETURN TO VENDOR', 'RETURN TO CUSTOMER')
146: OR ( rt.transaction_type = 'CORRECT'
147: AND EXISTS(SELECT NULL
148: FROM rcv_transactions prt
149: WHERE prt.transaction_id = rt.parent_transaction_id
150: AND prt.transaction_type IN('RECEIVE', 'RETURN TO VENDOR', 'RETURN TO CUSTOMER')))
151: );
152: ELSE -- Batch and Immediate mode.

Line 177: FROM rcv_transactions rt,

173: NULL last_update_login,
174: NULL request_id,
175: 0 last_updated_by,
176: SYSDATE last_update_date
177: FROM rcv_transactions rt,
178: rcv_shipment_lines rsl
179: WHERE rt.request_id = p_request_id
180: AND ( rt.GROUP_ID = p_group_id
181: OR p_group_id = 0

Line 188: FROM rcv_transactions prt

184: AND rsl.osa_flag = 'Y'
185: AND ( rt.transaction_type IN('RECEIVE', 'RETURN TO VENDOR', 'RETURN TO CUSTOMER')
186: OR ( rt.transaction_type = 'CORRECT'
187: AND EXISTS(SELECT NULL
188: FROM rcv_transactions prt
189: WHERE prt.transaction_id = rt.parent_transaction_id
190: AND prt.transaction_type IN('RECEIVE', 'RETURN TO VENDOR', 'RETURN TO CUSTOMER')))
191: );
192: END IF;