DBA Data[Home] [Help]

APPS.RCV_BUSINESS_EVENTS dependencies on RCV_SHIPMENT_LINES

Line 141: rcv_shipment_lines rsl

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'
145: AND ( rt.transaction_type IN('RECEIVE', 'RETURN TO VENDOR', 'RETURN TO CUSTOMER')

Line 178: rcv_shipment_lines rsl

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
182: OR p_group_id IS NULL)