[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Insert into as_leads_log(
LOG_ID , LEAD_ID ,CREATED_BY ,CREATION_DATE ,
LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , STATUS_CODE ,
SALES_STAGE_ID , WIN_PROBABILITY , DECISION_DATE , SECURITY_GROUP_ID ,
ADDRESS_ID , CHANNEL_CODE , CURRENCY_CODE , TOTAL_AMOUNT ,
LOG_MODE , CUSTOMER_ID , DESCRIPTION ,SOURCE_PROMOTION_ID ,
OFFER_ID , CLOSE_COMPETITOR_ID , VEHICLE_RESPONSE_CODE , SALES_METHODOLOGY_ID ,
OWNER_SALESFORCE_ID ,OWNER_SALES_GROUP_ID , ORG_ID,
LOG_START_DATE, LOG_END_DATE, LOG_ACTIVE_DAYS, ENDDAY_LOG_FLAG, CURRENT_LOG )
SELECT AS_LEAD_LOG_S.nextval , a.LEAD_ID ,a.CREATED_BY ,a.CREATION_DATE ,
a.LAST_UPDATED_BY , a.LAST_UPDATE_DATE , a.LAST_UPDATE_LOGIN , a.STATUS ,
a.SALES_STAGE_ID , a.WIN_PROBABILITY , a.DECISION_DATE , a.SECURITY_GROUP_ID ,
a.ADDRESS_ID , a.CHANNEL_CODE , a.CURRENCY_CODE , a.TOTAL_AMOUNT ,
'I', a.CUSTOMER_ID , a.DESCRIPTION ,a.SOURCE_PROMOTION_ID ,
a.OFFER_ID , a.CLOSE_COMPETITOR_ID , a.VEHICLE_RESPONSE_CODE , a.SALES_METHODOLOGY_ID ,
a.OWNER_SALESFORCE_ID ,a.OWNER_SALES_GROUP_ID , a.ORG_ID,
LAST_UPDATE_DATE, LAST_UPDATE_DATE, 0, 'Y', 1
FROM AS_LEADS_ALL a
where a.lead_id not in ( select log.lead_id from AS_LEADS_LOG log);
Insert into AS_LEAD_LINES_LOG (
log_id, lead_id, lead_line_id,
last_update_date, last_updated_by, last_update_login, creation_date,
created_by, log_mode, interest_type_id, primary_interest_code_id, secondary_interest_code_id,
product_category_id, product_cat_set_id,
inventory_item_id, organization_id, source_promotion_id, offer_id, org_id,
forecast_date, rolling_forecast_flag, endday_log_flag)
SELECT AS_LEAD_LINES_LOG_S.NEXTVAL , a.lead_id, a.lead_line_id,
a.last_update_date, a.last_updated_by, a.last_update_login, a.creation_date,
a.created_by, 'I', a.interest_type_id, a.primary_interest_code_id, a.secondary_interest_code_id,
a.product_category_id, a.product_cat_set_id,
a.inventory_item_id, a.organization_id, a.source_promotion_id, a.offer_id, a.org_id,
a.forecast_date , a.rolling_forecast_flag, 'Y'
FROM AS_LEAD_LINES_ALL a
where a.lead_line_id not in ( select log.lead_line_id from AS_LEAD_LINES_LOG log);
Insert into AS_SALES_CREDITS_LOG ( log_id,
lead_id, lead_line_id, sales_credit_id, last_update_date,
last_updated_by, last_update_login, creation_date, created_by,
log_mode, salesforce_id, salesgroup_id, credit_type_id,
credit_percent, credit_amount, endday_log_flag)
SELECT AS_SALES_CREDIT_LOG_S.NEXTVAL ,
lead_id, lead_line_id, sales_credit_id, last_update_date,
last_updated_by, last_update_login, creation_date, created_by,
'I', salesforce_id, salesgroup_id, credit_type_id,
credit_percent, credit_amount, 'Y'
FROM AS_SALES_CREDITS
where AS_SALES_CREDITS.sales_credit_id not in (select AS_SALES_CREDITS_LOG.sales_credit_id
FROM AS_SALES_CREDITS_LOG);