DBA Data[Home] [Help]

APPS.MSD_SR_UTIL dependencies on CS_INCIDENTS_ALL_B

Line 1085: from cs_incidents_all_b cia,

1081: 'attribute9', cust.attribute9, 'attribute10', cust.attribute10, 'attribute11',
1082: cust.attribute11, 'attribute12', cust.attribute12, 'attribute13',cust.attribute13,
1083: 'attribute14', cust.attribute14, 'attribute15', cust.attribute15, '2'), '1',
1084: nvl(cia.account_id, msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)
1085: from cs_incidents_all_b cia,
1086: hz_cust_accounts cust,
1087: csd_repairs crp
1088: where crp.repair_line_id = p_repair_line_id
1089: and cia.incident_id = crp.incident_id

Line 1141: from cs_incidents_all_b cia,

1137: order by repair_job_xref_id desc;
1138:
1139: cursor c2 (p_repair_line_id in number) is
1140: select get_sr_zone_pk(hps.location_id, p_zone_filter)
1141: from cs_incidents_all_b cia,
1142: hz_party_sites hps,
1143: csd_repairs crp
1144: where crp.repair_line_id = p_repair_line_id
1145: and cia.incident_id = crp.incident_id