DBA Data[Home] [Help]

APPS.BIV_DBI_COLLECTION_INC dependencies on CS_INCIDENTS_AUDIT_B

Line 554: cs_incidents_audit_b a , cs_incidents_all_b i

550: , nvl(i.customer_id,-1) /* functionally should not be possible */
551: , nvl(i.sr_creation_channel,'-1') /* functionally should not be possible */
552: , nvl(i.resolution_code,'-1') /* valid, resolution code not specified*/
553: from
554: cs_incidents_audit_b a , cs_incidents_all_b i
555: where
556: a.creation_date between p_collect_from_date and p_collect_to_date
557: and i.incident_id = a.incident_id
558: and nvl(a.updated_entity_code, 'SR_HEADER') IN ('SR_HEADER','SR_ESCALATION')