APPS.ASO_SERVICE_CONTRACTS_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 38: FROM aso_quote_headers_all a,aso_quote_lines_all b

34: where inventory_item_id = inv1
35: and organization_id = lc_organization_id;
36: CURSOR C_qln(c_qln_id NUMBER) IS
37: SELECT b.inventory_item_id,b.organization_id,a.cust_account_id
38: FROM aso_quote_headers_all a,aso_quote_lines_all b
39: WHERE b.quote_line_id = c_qln_id and
40: a.quote_header_id=b.quote_header_id;
41: CURSOR C_get_cust IS
42: SELECT cust_account_id

Line 43: FROM aso_quote_headers_all

39: WHERE b.quote_line_id = c_qln_id and
40: a.quote_header_id=b.quote_header_id;
41: CURSOR C_get_cust IS
42: SELECT cust_account_id
43: FROM aso_quote_headers_all
44: WHERE quote_header_id= P_Qte_Line_Rec.quote_header_id;
45: /*
46: CURSOR C_cs_item(cs_prd_id NUMBER) IS
47: SELECT a.inventory_item_id

Line 71: FROM aso_quote_headers_all

67:
68: /* Commented for Sun ER 8647883
69: CURSOR C_cust_id (Quote_hd_id NUMBER)IS
70: SELECT cust_account_id
71: FROM aso_quote_headers_all
72: WHERE quote_header_id= Quote_hd_id;
73: */
74:
75: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/

Line 80: FROM aso_quote_headers_all

76: CURSOR C_cust_id (Quote_hd_id NUMBER)IS
77: SELECT cust_account_id,
78: decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id)
79: hd_end_cust_account_id
80: FROM aso_quote_headers_all
81: WHERE quote_header_id= Quote_hd_id;
82:
83:
84: CURSOR C_get_cust_line(Quote_ln_id number) IS