APPS.ASO_SERVICE_CONTRACTS_INT dependencies on ASO_QUOTE_LINES_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 86: FROM aso_quote_lines_all

82:
83:
84: CURSOR C_get_cust_line(Quote_ln_id number) IS
85: SELECT END_CUSTOMER_CUST_ACCOUNT_ID cust_account_id
86: FROM aso_quote_lines_all
87: WHERE quote_line_id= Quote_ln_id;
88:
89: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
90: