DBA Data[Home] [Help]

APPS.AS_OPP_INITIAL_LOG_PKG dependencies on AS_LEAD_LINES_ALL

Line 111: FROM AS_LEAD_LINES_ALL a

107: a.created_by, 'I', a.interest_type_id, a.primary_interest_code_id, a.secondary_interest_code_id,
108: a.product_category_id, a.product_cat_set_id,
109: a.inventory_item_id, a.organization_id, a.source_promotion_id, a.offer_id, a.org_id,
110: a.forecast_date , a.rolling_forecast_flag, 'Y'
111: FROM AS_LEAD_LINES_ALL a
112: where a.lead_line_id not in ( select log.lead_line_id from AS_LEAD_LINES_LOG log);
113: write_log(l_module, G_DEBUG_CONCURRENT, 1, 'Refresh of as_lead_lines_log Process Completed @: '||to_char(sysdate,'DD-MON-RRRR:HH:MI:SS'));
114: COMMIT;
115: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN