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.

[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 2329: update aso_quote_line_details

2325: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2326: aso_debug_pub.ADD ( 'Copy_Rows - Updating the top model and ato line id for the top model line ', 1 , 'Y' );
2327: aso_debug_pub.ADD ( 'Copy_Rows - l_ato_model: ' || l_ato_model , 1 , 'Y' );
2328: END IF;
2329: update aso_quote_line_details
2330: set top_model_line_id = lx_qte_line_rec.quote_line_id,
2331: ato_line_id = decode(l_ato_model,fnd_api.g_true,lx_qte_line_rec.quote_line_id,null)
2332: where quote_line_id = lx_qte_line_rec.quote_line_id;
2333:

Line 2585: UPDATE aso_quote_line_details

2581:
2582: IF l_orig_item_id_tbl.count > 0 AND l_new_item_id_tbl.count > 0 THEN
2583:
2584: FORALL i IN l_orig_item_id_tbl.FIRST..l_orig_item_id_tbl.LAST
2585: UPDATE aso_quote_line_details
2586: SET config_item_id = l_new_item_id_tbl(i)
2587: ,last_update_date = SYSDATE
2588: ,last_updated_by =G_USER_ID
2589: ,last_update_login = G_LOGIN_ID

Line 2925: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID

2921: config_hdr_id NUMBER
2922: , config_rev_number NUMBER
2923: , qte_hdr_id NUMBER
2924: ) IS
2925: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
2926: FROM ASO_Quote_Line_Details
2927: , ASO_Quote_Lines_all
2928: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2929: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

Line 2926: FROM ASO_Quote_Line_Details

2922: , config_rev_number NUMBER
2923: , qte_hdr_id NUMBER
2924: ) IS
2925: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
2926: FROM ASO_Quote_Line_Details
2927: , ASO_Quote_Lines_all
2928: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2929: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
2930: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

Line 2928: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id

2924: ) IS
2925: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
2926: FROM ASO_Quote_Line_Details
2927: , ASO_Quote_Lines_all
2928: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2929: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
2930: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
2931: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
2932: AND ASO_quote_line_details.ref_line_id is not null

Line 2929: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

2925: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
2926: FROM ASO_Quote_Line_Details
2927: , ASO_Quote_Lines_all
2928: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2929: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
2930: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
2931: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
2932: AND ASO_quote_line_details.ref_line_id is not null
2933: AND aso_quote_lines_all.quote_header_id = qte_hdr_id

Line 2930: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

2926: FROM ASO_Quote_Line_Details
2927: , ASO_Quote_Lines_all
2928: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2929: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
2930: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
2931: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
2932: AND ASO_quote_line_details.ref_line_id is not null
2933: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
2934: ORDER BY aso_quote_line_details.bom_sort_order;

Line 2931: AND ASO_quote_line_details.ref_type_code = 'CONFIG'

2927: , ASO_Quote_Lines_all
2928: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2929: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
2930: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
2931: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
2932: AND ASO_quote_line_details.ref_line_id is not null
2933: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
2934: ORDER BY aso_quote_line_details.bom_sort_order;
2935:

Line 2932: AND ASO_quote_line_details.ref_line_id is not null

2928: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2929: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
2930: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
2931: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
2932: AND ASO_quote_line_details.ref_line_id is not null
2933: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
2934: ORDER BY aso_quote_line_details.bom_sort_order;
2935:
2936: CURSOR C_Serviceable_Product (

Line 2934: ORDER BY aso_quote_line_details.bom_sort_order;

2930: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
2931: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
2932: AND ASO_quote_line_details.ref_line_id is not null
2933: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
2934: ORDER BY aso_quote_line_details.bom_sort_order;
2935:
2936: CURSOR C_Serviceable_Product (
2937: l_organization_id NUMBER
2938: , l_inv_item_id NUMBER

Line 2995: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID

2991: config_hdr_id NUMBER
2992: , config_rev_number NUMBER
2993: , qte_hdr_id NUMBER
2994: ) IS
2995: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
2996: FROM ASO_Quote_Line_Details
2997: , ASO_Quote_Lines_all
2998: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2999: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

Line 2996: FROM ASO_Quote_Line_Details

2992: , config_rev_number NUMBER
2993: , qte_hdr_id NUMBER
2994: ) IS
2995: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
2996: FROM ASO_Quote_Line_Details
2997: , ASO_Quote_Lines_all
2998: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2999: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
3000: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

Line 2998: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id

2994: ) IS
2995: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
2996: FROM ASO_Quote_Line_Details
2997: , ASO_Quote_Lines_all
2998: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2999: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
3000: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
3001: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
3002: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;

Line 2999: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

2995: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
2996: FROM ASO_Quote_Line_Details
2997: , ASO_Quote_Lines_all
2998: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2999: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
3000: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
3001: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
3002: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
3003:

Line 3000: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

2996: FROM ASO_Quote_Line_Details
2997: , ASO_Quote_Lines_all
2998: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
2999: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
3000: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
3001: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
3002: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
3003:
3004: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 4926: update aso_quote_line_details

4922: aso_debug_pub.ADD ( 'SPLIT_MODEL_LINE - New Qte Line ID ='||to_char(lx_qte_line_rec.quote_line_id), 1 , 'N' );
4923: aso_debug_pub.ADD ( 'Split_Model_Line - Updating the top model and ato line id for the top model line ', 1 , 'Y' );
4924: aso_debug_pub.ADD ( 'Split_Model_Line - l_ato_model: ' || l_ato_model , 1 , 'Y' );
4925: END IF;
4926: update aso_quote_line_details
4927: set top_model_line_id = lx_qte_line_rec.quote_line_id,
4928: ato_line_id = decode(l_ato_model,fnd_api.g_true,lx_qte_line_rec.quote_line_id,null)
4929: where quote_line_id = lx_qte_line_rec.quote_line_id;
4930:

Line 5170: UPDATE aso_quote_line_details

5166:
5167: IF l_orig_item_id_tbl.count > 0 AND l_new_item_id_tbl.count > 0 THEN
5168:
5169: FORALL i IN l_orig_item_id_tbl.FIRST..l_orig_item_id_tbl.LAST
5170: UPDATE aso_quote_line_details
5171: SET config_item_id = l_new_item_id_tbl(i)
5172: ,last_update_date = SYSDATE
5173: ,last_updated_by = G_USER_ID
5174: ,last_update_login = G_LOGIN_ID