eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PRICING_CORE_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 273: ,aso_quote_lines_all qte

269: /*Cursor to obtain the top model inventory item id*/
270: CURSOR C_top_model_item_id(p_config_hdr_id NUMBER, p_rev_num NUMBER) IS
271: SELECT qte.inventory_item_id
272: FROM aso_quote_line_details line_dtl
273: ,aso_quote_lines_all qte
274: WHERE qte.quote_line_id = line_dtl.quote_line_id
275: AND line_dtl.config_header_id = p_config_hdr_id
276: AND line_dtl.config_revision_num = p_rev_num
277: AND line_dtl.ref_type_code = 'CONFIG'

Line 960: FROM ASO_QUOTE_LINES_ALL

956: PROCEDURE PROCESS_LN_TSN(p_quote_header_id NUMBER, p_insert_type VARCHAR2) IS
957:
958: CURSOR c_qte_lines IS
959: SELECT quote_line_id
960: FROM ASO_QUOTE_LINES_ALL
961: WHERE quote_header_id = p_quote_header_id;
962:
963: CURSOR c_get_free_lines IS
964: SELECT quote_line_id

Line 965: FROM ASO_QUOTE_LINES_ALL

961: WHERE quote_header_id = p_quote_header_id;
962:
963: CURSOR c_get_free_lines IS
964: SELECT quote_line_id
965: FROM ASO_QUOTE_LINES_ALL
966: WHERE quote_header_id = p_quote_header_id
967: AND nvl(pricing_line_type_indicator,'X') = G_FREE_LINE_FLAG;
968:
969: CURSOR c_ln_tsn_count(p_quote_line_id NUMBER) IS

Line 6608: FROM ASO_QUOTE_LINES_ALL l

6604: SET OPERAND_PER_PQTY = (SELECT decode(arithmetic_operator,'%',operand,
6605: 'LUMPSUM',operand,
6606: 'AMT',(operand*l.quantity)/l.PRICING_QUANTITY,
6607: 'NEWPRICE',(operand*l.quantity)/l.PRICING_QUANTITY)
6608: FROM ASO_QUOTE_LINES_ALL l
6609: WHERE l.quote_header_id = apa.quote_header_id
6610: AND l.quote_line_id = apa.quote_line_id
6611: )
6612: WHERE apa.quote_header_id = p_quote_header_id

Line 6918: FROM ASO_QUOTE_LINES_ALL l

6914: SET OPERAND_PER_PQTY = (SELECT decode(arithmetic_operator,'%',operand,
6915: 'LUMPSUM',operand,
6916: 'AMT',(operand*l.quantity)/l.PRICING_QUANTITY,
6917: 'NEWPRICE',(operand*l.quantity)/l.PRICING_QUANTITY)
6918: FROM ASO_QUOTE_LINES_ALL l
6919: WHERE l.quote_header_id = apa.quote_header_id
6920: AND l.quote_line_id = apa.quote_line_id
6921: )
6922: WHERE apa.quote_header_id = p_quote_header_id

Line 7097: FROM ASO_QUOTE_LINES_ALL l

7093: SET OPERAND_PER_PQTY = (SELECT decode(arithmetic_operator,'%',operand,
7094: 'LUMPSUM',operand,
7095: 'AMT',operand,
7096: 'NEWPRICE',operand)
7097: FROM ASO_QUOTE_LINES_ALL l
7098: WHERE l.quote_header_id = apa.quote_header_id
7099: AND l.quote_line_id = apa.quote_line_id
7100: )
7101: WHERE apa.quote_header_id = p_quote_header_id

Line 7308: AND EXISTS ( SELECT null from ASO_QUOTE_LINES_ALL lines2

7304: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7305: AND adj.QUOTE_LINE_ID = Lines.column_value
7306: AND adj.QUOTE_LINE_ID IS NOT NULL
7307: AND (( NVL(adj.updated_flag,'N') = 'Y'
7308: AND EXISTS ( SELECT null from ASO_QUOTE_LINES_ALL lines2
7309: WHERE lines2.quote_line_id = adj.quote_line_id
7310: AND nvl(lines2.RECALCULATE_FLAG,'N') = 'N' )
7311: AND NVL(ASO_PRICING_INT.G_HEADER_REC.RECALCULATE_FLAG,'N') = 'N')
7312: OR ( adj.modifier_line_type_code = 'PRG'

Line 7375: ASO_QUOTE_LINES_ALL lines

7371: to_number(NULL),
7372: to_number(NULL)
7373: FROM ASO_QUOTE_LINE_DETAILS ldets,
7374: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,
7375: ASO_QUOTE_LINES_ALL lines
7376: WHERE ldets.quote_line_id = serviceLines.column_value
7377: AND lines.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7378: AND lines.quote_line_id = ldets.quote_line_id
7379: AND ldets.service_ref_line_id IS NOT NULL;

Line 7404: ASO_QUOTE_LINES_ALL lines

7400: G_RLTD_LST_LN_ID_DEF_TBL,
7401: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7402: FROM ASO_QUOTE_LINE_DETAILS ldets,
7403: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,
7404: ASO_QUOTE_LINES_ALL lines
7405: WHERE ldets.quote_line_id = serviceLines.column_value
7406: AND lines.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7407: AND lines.quote_line_id = ldets.quote_line_id
7408: AND ldets.service_ref_line_id IS NOT NULL;

Line 9379: FROM ASO_QUOTE_LINES_ALL

9375: END IF;
9376:
9377: SELECT count(rowid)
9378: INTO l_db_line_counter
9379: FROM ASO_QUOTE_LINES_ALL
9380: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
9381:
9382: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9383: aso_debug_pub.add('ASO_PRICING_CORE_PVT:l_db_line_counter:'||l_db_line_counter,1,'Y');

Line 9451: UPDATE ASO_QUOTE_LINES_all l

9447: END IF;
9448:
9449: If (P_control_rec.pricing_event = 'PRICE') then
9450:
9451: UPDATE ASO_QUOTE_LINES_all l
9452: SET (line_quote_price
9453: ,line_list_price
9454: ,line_adjusted_amount
9455: ,line_adjusted_percent

Line 9499: UPDATE ASO_QUOTE_LINES_all l

9495:
9496: else
9497: -- manual price change is possible
9498:
9499: UPDATE ASO_QUOTE_LINES_all l
9500: SET (line_quote_price
9501: ,line_list_price
9502: ,line_adjusted_amount
9503: ,line_adjusted_percent

Line 10512: FROM ASO_QUOTE_LINES_ALL

10508:
10509: CURSOR c_qte_sum IS
10510: SELECT sum(NVL(LINE_LIST_PRICE*quantity, 0)) total_list_price,
10511: sum(NVL(line_adjusted_amount*quantity,NVL(LINE_ADJUSTED_PERCENT*LINE_LIST_PRICE*quantity,0))) ln_total_discount
10512: FROM ASO_QUOTE_LINES_ALL
10513: WHERE QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id;
10514:
10515: l_api_name CONSTANT VARCHAR2(30) := 'Process_Charges';
10516: l_api_version_number CONSTANT NUMBER := 1.0;