APPS.RCV_BUSINESS_EVENTS dependencies on RCV_TRANSACTIONS

Line 21: FROM rcv_transactions rt

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

Line 28: FROM rcv_transactions rt

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

Line 92: FROM rcv_transactions rt,

88: NULL last_update_login,
89: NULL request_id,
90: 0 last_updated_by,
91: SYSDATE last_update_date
92: FROM rcv_transactions rt,
93: rcv_shipment_lines rsl
94: WHERE rt.GROUP_ID = p_group_id
95: AND rt.shipment_line_id = rsl.shipment_line_id
96: AND rsl.osa_flag = 'Y'

Line 100: FROM rcv_transactions prt

96: AND rsl.osa_flag = 'Y'
97: AND ( rt.transaction_type IN('RECEIVE', 'RETURN TO VENDOR', 'RETURN TO CUSTOMER')
98: OR ( rt.transaction_type = 'CORRECT'
99: AND EXISTS(SELECT NULL
100: FROM rcv_transactions prt
101: WHERE prt.transaction_id = rt.parent_transaction_id
102: AND prt.transaction_type IN('RECEIVE', 'RETURN TO VENDOR', 'RETURN TO CUSTOMER')))
103: );
104: ELSE -- Batch and Immediate mode.

Line 129: FROM rcv_transactions rt,

125: NULL last_update_login,
126: NULL request_id,
127: 0 last_updated_by,
128: SYSDATE last_update_date
129: FROM rcv_transactions rt,
130: rcv_shipment_lines rsl
131: WHERE rt.request_id = p_request_id
132: AND ( rt.GROUP_ID = p_group_id
133: OR p_group_id = 0

Line 140: FROM rcv_transactions prt

136: AND rsl.osa_flag = 'Y'
137: AND ( rt.transaction_type IN('RECEIVE', 'RETURN TO VENDOR', 'RETURN TO CUSTOMER')
138: OR ( rt.transaction_type = 'CORRECT'
139: AND EXISTS(SELECT NULL
140: FROM rcv_transactions prt
141: WHERE prt.transaction_id = rt.parent_transaction_id
142: AND prt.transaction_type IN('RECEIVE', 'RETURN TO VENDOR', 'RETURN TO CUSTOMER')))
143: );
144: END IF;