DBA Data[Home] [Help]

APPS.MSD_SR_UTIL dependencies on CSD_REPAIRS

Line 1155: csd_repairs crp

1151: 'attribute14', cust.attribute14, 'attribute15', cust.attribute15, '2'), '1',
1152: nvl(cia.account_id, msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)
1153: from cs_incidents_all_b cia,
1154: hz_cust_accounts cust,
1155: csd_repairs crp
1156: where crp.repair_line_id = p_repair_line_id
1157: and cia.incident_id = crp.incident_id
1158: and cust.cust_account_id = cia.account_id;
1159:

Line 1211: csd_repairs crp

1207: cursor c2 (p_repair_line_id in number) is
1208: select get_sr_zone_pk(hps.location_id, p_zone_filter)
1209: from cs_incidents_all_b cia,
1210: hz_party_sites hps,
1211: csd_repairs crp
1212: where crp.repair_line_id = p_repair_line_id
1213: and cia.incident_id = crp.incident_id
1214: and cia.install_site_id = hps.party_site_id (+);
1215: