APPS.OE_UPG_INSTALL_DETAILS dependencies on SO_LINE_SERVICE_DETAILS

Line 50: ' FROM so_line_service_details sld,' ||

46: -- slab parameter is being passed.
47:
48: l_install_lines_stmt VARCHAR2(2000) :=
49: 'SELECT sld.line_service_detail_id, sld.line_id' ||
50: ' FROM so_line_service_details sld,' ||
51: ' oe_order_lines_all ol' ||
52: ' WHERE ol.line_id = sld.line_id' ||
53: ' AND NOT exists' ||
54: ' (SELECT 1' ||

Line 338: SO_LINE_SERVICE_DETAILS LSD

334: l_party_site_id
335: FROM
336: HZ_CUST_ACCT_SITES_ALL CAS,
337: HZ_CUST_SITE_USES_ALL CSU,
338: SO_LINE_SERVICE_DETAILS LSD
339: WHERE
340: csu.cust_acct_site_id = cas.cust_acct_site_id (+)
341: AND lsd.installation_site_use_id = csu.site_use_id (+)
342: AND lsd.line_service_detail_id = p_line_inst_details_id;