DBA Data[Home] [Help]

APPS.RCV_BUSINESS_EVENTS dependencies on RCV_SHIPMENT_LINES

Line 93: rcv_shipment_lines rsl

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

Line 130: rcv_shipment_lines rsl

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