[Home] [Help]
117: l_quote_header_id number;
118: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
119: SELECT qh.cust_account_id, qs.ship_to_party_site_id,
120: qs.ship_to_cust_account_id,qh.quote_header_id
121: FROM aso_quote_headers_all qh, aso_shipments qs, aso_quote_lines_all ql
122: WHERE qh.quote_header_id = qs.quote_header_id
123: AND ql.quote_header_id = qh.quote_header_id
124: AND ql.quote_line_id = l_quote_line_id
125: AND ql.quote_line_id = qs.quote_line_id;
254: l_quote_header_id number;
255: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
256: SELECT qh.cust_account_id, ql.invoice_to_party_site_id,
257: ql.invoice_to_cust_account_id, qh.quote_header_id
258: FROM aso_quote_headers_all qh, aso_quote_lines_all ql
259: WHERE ql.quote_line_id = l_quote_line_id
260: AND ql.quote_header_id = qh.quote_header_id;
261:
262: BEGIN
393: RETURN NUMBER
394: IS
395: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
396: SELECT qs.invoice_to_party_site_id
397: FROM aso_quote_lines_all qs
398: WHERE qs.quote_line_id = l_quote_line_id;
399:
400: xl_inv_party_site_id NUMBER;
401:
559: BEGIN
560:
561: SELECT SUM(nvl(quantity,0))
562: INTO l_quote_qty
563: FROM aso_quote_lines_all
564: WHERE quote_header_id=p_qte_header_id
565: AND (line_category_code<>'RETURN' OR line_category_code IS NULL)
566: GROUP BY quote_header_id;
567:
587: BEGIN
588:
589: SELECT SUM((nvl(quantity,0))*(LINE_LIST_PRICE-LINE_ADJUSTED_AMOUNT))
590: INTO l_quote_amount
591: FROM aso_quote_lines_all
592: WHERE quote_header_id=p_qte_header_id
593: AND (line_category_code<>'RETURN' OR line_category_code IS NULL)
594: GROUP BY quote_header_id;
595:
613: BEGIN
614:
615: SELECT shippable_item_flag
616: INTO x_shippable_item_flag
617: FROM aso_i_items_v i, aso_quote_lines_all l
618: WHERE l.quote_line_id = p_qte_line_id
619: and l.inventory_item_id = i.inventory_item_id
620: and l.organization_id = i.organization_id;
621:
808: and qs.freight_terms_code is not null;
809:
810: CURSOR C_hdr_freight_terms_code IS
811: SELECT qs.freight_terms_code
812: FROM aso_shipments qs, aso_quote_lines_all ql
813: WHERE qs.quote_header_id = ql.quote_header_id
814: and ql.quote_line_id = p_qte_line_id
815: and qs.quote_line_id IS NULL;
816:
873: and qs.ship_method_code is not null;
874:
875: CURSOR C_hdr_ship_method_code IS
876: SELECT qs.ship_method_code
877: FROM aso_shipments qs, aso_quote_lines_all ql
878: WHERE qs.quote_header_id = ql.quote_header_id
879: and ql.quote_line_id = p_qte_line_id
880: and qs.quote_line_id IS NULL;
881:
945: where aso_rel.related_quote_line_id = l_quote_line_id;
946:
947: CURSOR C_item_id IS
948: select inventory_item_id
949: from aso_quote_lines_all
950: where quote_line_id = x_top_model_line_id;
951:
952:
953: BEGIN
1018: x_count varchar2(1);
1019:
1020: CURSOR C_Is_Item_Shippable IS
1021: SELECT 'x'
1022: FROM aso_quote_lines_all l
1023: WHERE l.quote_header_id = p_qte_header_id
1024: AND EXISTS ( SELECT null
1025: FROM mtl_system_items_b i
1026: WHERE l.inventory_item_id = i.inventory_item_id
1034: END IF;
1035:
1036: --SELECT count(*)
1037: -- INTO x_count
1038: --FROM aso_i_items_v i, aso_quote_lines_all l,
1039: --aso_quote_headers_all h
1040: --WHERE l.quote_header_id=h.quote_header_id
1041: --and h.quote_header_id = p_qte_header_id
1042: --and l.inventory_item_id = i.inventory_item_id
1097:
1098: IF l_SERVICE_REF_TYPE_CODE = 'QUOTE' Then
1099: select line_list_price
1100: INTO x_list_price
1101: from aso_quote_lines_all ql
1102: where ql.quote_line_id = l_service_ref_line_id;
1103: Elsif l_SERVICE_REF_TYPE_CODE = 'ORDER' then
1104: select unit_list_price
1105: INTO x_list_price