APPS.BIM_LEAD_IMPORT_FACTS_PKG dependencies on AS_IMPORT_INTERFACE

Line 420: from AS_IMPORT_INTERFACE A

416: NULL failure_reason,
417: decode(A.Load_Status, 'SUCCESS', 1, 0) leads_valid,
418: decode(A.Load_Status, 'NEW', 1, 0) leads_new,
419: 0 leads_invalid
420: from AS_IMPORT_INTERFACE A
421: where a.last_update_date between p_start_datel and p_end_datel+0.9999
422: AND a.load_status IN ('SUCCESS', 'NEW')
423: group by a.promotion_code,
424: a.country,

Line 438: from AS_IMPORT_INTERFACE a,

434: max(b.error_text) FAILURE_REASON,
435: 0 leads_valid,
436: 0 leads_new,
437: decode(A.Load_Status, 'ERROR', 1,'UNEXP_ERROR', 1, 0) leads_Invalid
438: from AS_IMPORT_INTERFACE a,
439: AS_LEAD_IMPORT_ERRORS B
440: where a.last_update_date between p_start_datel and p_end_datel +0.9999
441: and a.Import_interface_id = B.import_interface_id(+)
442: AND a.load_status IN ('ERROR', 'UNEXP_ERROR')