DBA Data[Home] [Help]

APPS.RCV_BUSINESS_EVENTS dependencies on RCV_STAGING_TABLE

Line 116: INSERT INTO rcv_staging_table

112: -- statements for performance reason. For online mode request_id might come as 0 or null.
113: -- Hence we first check the request_id for Batch and Imeediate request_id is not null.
114: IF p_request_id = 0 OR p_request_id IS NULL -- On line mode
115: THEN
116: INSERT INTO rcv_staging_table
117: (transaction_id,
118: team,
119: status,
120: transaction_request_id,

Line 153: INSERT INTO rcv_staging_table

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.
153: INSERT INTO rcv_staging_table
154: (transaction_id,
155: team,
156: status,
157: transaction_request_id,