DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on CS_ESTIMATE_DETAILS

Line 1137: + ' cs_estimate_details csd Where ro.repair_line_id = :1'

1133:
1134: IF(l_predicate IS NULL OR l_predicate <> '(1=1)') THEN
1135:
1136: l_sql_str := ' Select ''x'' from csd_repairs_v ro, csd_product_txns_v prd, '
1137: + ' cs_estimate_details csd Where ro.repair_line_id = :1'
1138: + ' And prd.repair_line_id = ro.repair_line_id '
1139: + ' And prd.action_code = :2 '
1140: + ' And prd.action_type = :3 '
1141: + ' And csd.estimate_detail_id = prd.estimate_detail_id '

Line 1181: + ' cs_estimate_details csd Where ro.repair_line_id = :1'

1177:
1178: IF(l_predicate IS NULL OR l_predicate <> '(1=1)') THEN
1179:
1180: l_sql_str := ' Select ''x'' from csd_repairs_v ro, csd_product_txns_v prd, '
1181: + ' cs_estimate_details csd Where ro.repair_line_id = :1'
1182: + ' And prd.repair_line_id = ro.repair_line_id '
1183: + ' And prd.action_code = :2 '
1184: + ' And prd.action_type = :3 '
1185: + ' And csd.estimate_detail_id = prd.estimate_detail_id '

Line 3185: cs_estimate_details ced, csd_product_transactions cpt,wsh_delivery_details wdd,

3181:
3182: SELECT cpt.repair_line_id,oeh.header_id,ced.inventory_item_id,cr.incident_id
3183: INTO l_repair_line_id,l_header_id,l_ship_inv_item_id,l_incident_id
3184: FROM oe_order_lines_all oel, oe_order_headers_all oeh,
3185: cs_estimate_details ced, csd_product_transactions cpt,wsh_delivery_details wdd,
3186: csd_repairs cr
3187: WHERE oel.line_id = p_order_line_id
3188: AND oel.header_id = oeh.header_id
3189: AND oeh.header_id = ced.order_header_id