DBA Data[Home] [Help]

APPS.RCV_BUSINESS_EVENTS dependencies on RCV_STAGING_TABLE

Line 68: INSERT INTO rcv_staging_table

64: -- statements for performance reason. For online mode request_id might come as 0 or null.
65: -- Hence we first check the request_id for Batch and Imeediate request_id is not null.
66: IF p_request_id = 0 OR p_request_id IS NULL -- On line mode
67: THEN
68: INSERT INTO rcv_staging_table
69: (transaction_id,
70: team,
71: status,
72: transaction_request_id,

Line 105: INSERT INTO rcv_staging_table

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.
105: INSERT INTO rcv_staging_table
106: (transaction_id,
107: team,
108: status,
109: transaction_request_id,