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_ATP_INT dependencies on ASO_QUOTE_LINE_DETAILS

Line 435: from aso_quote_line_details a, aso_quote_lines_all b

431: cursor c_config_dtl(p_qte_line_id number) is
432: select a.quote_line_id, b.item_type_code, a.config_header_id, a.config_revision_num,a.component_code,
433: a.config_item_id, a.ref_line_id, a.top_model_line_id, a.ato_line_id, a.component_sequence_id,
434: b.ship_model_complete_flag
435: from aso_quote_line_details a, aso_quote_lines_all b
436: where b.quote_line_id = p_qte_line_id
437: and b.quote_line_id = a.quote_line_id
438: and a.ref_type_code = 'CONFIG';
439:

Line 442: from aso_quote_line_details

438: and a.ref_type_code = 'CONFIG';
439:
440: cursor c_quote_line_id(p_config_header_id number, p_config_revision_num number, p_config_item_id number) is
441: select quote_line_id
442: from aso_quote_line_details
443: where config_header_id = p_config_header_id
444: and config_revision_num = p_config_revision_num
445: and config_item_id = p_config_item_id;
446:

Line 459: from aso_quote_line_details a, aso_shipments b

455: where quote_header_id = p_quote_header_id;
456:
457: cursor c_configuration_rows(p_config_header_id number, p_config_revision_num number) is
458: select a.quote_line_id, b.shipment_id
459: from aso_quote_line_details a, aso_shipments b
460: where a.quote_line_id = b.quote_line_id
461: and a.config_header_id = p_config_header_id
462: and a.config_revision_num = p_config_revision_num
463: order by a.bom_sort_order;

Line 467: from aso_quote_line_details a, aso_shipments b

463: order by a.bom_sort_order;
464:
465: cursor c_ato_rows(p_config_header_id number, p_config_revision_num number, p_ato_line_id number) is
466: select a.quote_line_id, b.shipment_id
467: from aso_quote_line_details a, aso_shipments b
468: where a.quote_line_id = b.quote_line_id
469: and a.config_header_id = p_config_header_id
470: and a.config_revision_num = p_config_revision_num
471: and a.ato_line_id = p_ato_line_id

Line 475: select quote_line_id from aso_quote_line_details

471: and a.ato_line_id = p_ato_line_id
472: order by a.bom_sort_order;
473:
474: cursor c_top_model_line_id(p_config_header_id number, p_config_revision_num number) is
475: select quote_line_id from aso_quote_line_details
476: where config_header_id = p_config_header_id
477: and config_revision_num = p_config_revision_num
478: and ref_line_id is null
479: and ref_type_code = 'CONFIG';

Line 512: from aso_quote_line_details

508: and quote_header_id = p_qte_header_id;
509:
510: cursor c_get_ids (p_qte_line_id number) is
511: select ato_line_id,top_model_line_id
512: from aso_quote_line_details
513: where quote_line_id = p_qte_line_id;
514:
515: cursor c_get_request_date (p_qte_line_id number, p_qte_header_id number,p_date_type varchar2 ) is
516: select request_date

Line 2434: from aso_quote_lines_all a, aso_quote_line_details b

2430: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
2431:
2432: Cursor get_line_details(l_qte_header_id NUMBER) IS
2433: SELECT b.config_header_id,b.config_revision_num,b.quote_line_id
2434: from aso_quote_lines_all a, aso_quote_line_details b
2435: where a.quote_line_id = b.quote_line_id
2436: and a. quote_header_id = l_qte_header_id
2437: and b.ref_line_id is null
2438: and b.ref_type_code = 'CONFIG';

Line 2442: from aso_quote_lines_all a, aso_quote_line_details b

2438: and b.ref_type_code = 'CONFIG';
2439:
2440: Cursor get_line_id(l_config_header_id Number,l_config_revision_num Number) IS
2441: select a.quote_line_id
2442: from aso_quote_lines_all a, aso_quote_line_details b
2443: where a.quote_line_id = b.quote_line_id
2444: and b.config_header_id = l_config_header_id
2445: and b.config_revision_num = l_config_revision_num
2446: and ref_type_code = 'CONFIG'

Line 2451: from aso_quote_lines_all a, aso_quote_line_details b

2447: and ref_line_id is null;
2448:
2449: Cursor get_no_of_lines(l_qte_header_id NUMBER) IS
2450: select count(a.quote_line_id)
2451: from aso_quote_lines_all a, aso_quote_line_details b
2452: where a.quote_line_id = b.quote_line_id
2453: and a. quote_header_id = l_qte_header_id
2454: and b.ref_line_id is null
2455: and b.ref_type_code = 'CONFIG';

Line 2460: from cz_config_details_v a, aso_quote_line_details b

2456:
2457:
2458: Cursor get_cz_data(l_config_header_id Number,l_config_revision_num Number) IS
2459: select a.ato_config_item_id,b.quote_line_detail_id
2460: from cz_config_details_v a, aso_quote_line_details b
2461: where a.config_hdr_id = b.config_header_id
2462: and a.config_rev_nbr = b.config_revision_num
2463: and b.config_header_id = l_config_header_id
2464: and b.config_revision_num = l_config_revision_num

Line 2469: from aso_quote_line_details

2465: order by b.bom_sort_order;
2466:
2467: Cursor get_ato_line(l_config_header_id Number,l_config_revision_num Number,l_config_item_id Number) IS
2468: select quote_line_id
2469: from aso_quote_line_details
2470: where config_header_id = l_config_header_id
2471: and config_revision_num = l_config_revision_num
2472: and config_item_id = l_config_item_id;
2473:

Line 2593: update aso_quote_line_details

2589: open get_ato_line(l_qte_line_dtl_tbl(i).config_header_id,l_qte_line_dtl_tbl(i).config_revision_num,l_ato_item_id);
2590: fetch get_ato_line into l_ato_line_id;
2591: close get_ato_line;
2592:
2593: update aso_quote_line_details
2594: set top_model_line_id = l_qte_line_dtl_tbl(i).quote_line_id,
2595: ato_line_id = nvl(l_ato_line_id,null)
2596: where quote_line_detail_id = l_line_detail_id;
2597: end loop;