APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on CSD_REPAIR_ESTIMATE_LINES_V

Line 3112: FROM csd_repair_estimate_lines_v

3108: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3109:
3110: SELECT SUM(NVL(charge, 0))
3111: INTO x_estimated_charge
3112: FROM csd_repair_estimate_lines_v
3113: WHERE repair_line_id = p_repair_line_id
3114: AND billing_type IN ('M', 'L', 'E');
3115:
3116: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

Line 4266: from csd_repair_estimate_lines_v csd

4262: and KBSets.set_id = SetLinkTG.set_id
4263: and KBSets.status = 'PUB' -- only published solutions
4264: and not exists -- not already brought in
4265: ( select 'x'
4266: from csd_repair_estimate_lines_v csd
4267: where csd.repair_line_id = SetLinkRO.other_id
4268: and csd.est_line_source_type_code = 'SOLUTION'
4269: and csd.est_line_source_id1 = KBSets.set_id);
4270:

Line 4328: from csd_repair_estimate_lines_v csd

4324: and KBSets.set_id = SetLinkTG.set_id
4325: and KBSets.status = 'PUB' -- only published solutions
4326: and not exists -- not already brought in
4327: ( select 'x'
4328: from csd_repair_estimate_lines_v csd
4329: where csd.repair_line_id = SetLinkRO.other_id
4330: and csd.est_line_source_type_code = 'SOLUTION'
4331: and csd.est_line_source_id1 = KBSets.set_id);
4332: */

Line 4505: FROM csd_repair_estimate_lines_v csd

4501: AND KBSets.set_id = SetLinkTG.set_id
4502: AND KBSets.status = 'PUB' -- only published solutions
4503: AND NOT EXISTS -- not already brought in
4504: (SELECT 'x'
4505: FROM csd_repair_estimate_lines_v csd
4506: WHERE csd.repair_line_id = SetLinkRO.other_id
4507: AND csd.est_line_source_type_code = 'SOLUTION'
4508: AND csd.est_line_source_id1 = KBSets.set_id);
4509:

Line 4566: FROM csd_repair_estimate_lines_v csd

4562: AND KBSets.set_id = SetLinkTG.set_id
4563: AND KBSets.status = 'PUB' -- only published solutions
4564: AND NOT EXISTS -- not already brought in
4565: (SELECT 'x'
4566: FROM csd_repair_estimate_lines_v csd
4567: WHERE csd.repair_line_id = SetLinkRO.other_id
4568: AND csd.est_line_source_type_code = 'SOLUTION'
4569: AND csd.est_line_source_id1 = KBSets.set_id);
4570:

Line 4597: FROM csd_repair_estimate_lines_v csd

4593: AND KBSets.status = 'PUB' -- only published solutions
4594: AND repairs.repair_line_id = SetLinkRO.other_id
4595: AND NOT EXISTS -- not already brought in
4596: (SELECT 'x'
4597: FROM csd_repair_estimate_lines_v csd
4598: WHERE csd.repair_line_id = SetLinkRO.other_id
4599: AND csd.est_line_source_type_code = 'SOLUTION'
4600: AND csd.est_line_source_id1 = KBSets.set_id)
4601: AND NOT EXISTS -- no template for this product