DBA Data[Home] [Help]

APPS.MSD_SR_UTIL dependencies on CSD_REPAIRS

Line 1087: csd_repairs crp

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
1090: and cust.cust_account_id = cia.account_id;
1091:

Line 1143: csd_repairs crp

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
1146: and cia.install_site_id = hps.party_site_id (+);
1147: