DBA Data[Home] [Help]

APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_ST_DELIVERY_DETAILS

Line 4500: UPDATE MSC_ST_DELIVERY_DETAILS

4496: reqid number;
4497: BEGIN
4498: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
4499: /* Updating Who cols of Staging Tables */
4500: UPDATE MSC_ST_DELIVERY_DETAILS
4501: SET
4502: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
4503: LAST_UPDATE_DATE = MSC_CL_COLLECTION.v_current_date,
4504: LAST_UPDATED_BY = MSC_CL_COLLECTION.v_current_user,