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

Line 2523: from aso_quote_line_Details

2519: x_available_yn Varchar2(1);
2520:
2521: cursor c_service_ref_quote (P_Quote_line_id number) is
2522: select service_ref_line_id
2523: from aso_quote_line_Details
2524: where quote_line_id= P_Quote_line_id
2525: and service_ref_type_code ='QUOTE';
2526:
2527: l_return_value Varchar2(1);

Line 3518: update aso_quote_line_details

3514: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3515: aso_debug_pub.ADD ( 'Copy_Rows - Updating the top model and ato line id for the top model line ', 1 , 'Y' );
3516: aso_debug_pub.ADD ( 'Copy_Rows - l_ato_model: ' || l_ato_model , 1 , 'Y' );
3517: END IF;
3518: update aso_quote_line_details
3519: set top_model_line_id = lx_qte_line_rec.quote_line_id,
3520: ato_line_id = decode(l_ato_model,fnd_api.g_true,lx_qte_line_rec.quote_line_id,null)
3521: where quote_line_id = lx_qte_line_rec.quote_line_id;
3522:

Line 3800: UPDATE aso_quote_line_details

3796:
3797: IF l_orig_item_id_tbl.count > 0 AND l_new_item_id_tbl.count > 0 THEN
3798:
3799: FORALL i IN l_orig_item_id_tbl.FIRST..l_orig_item_id_tbl.LAST
3800: UPDATE aso_quote_line_details
3801: SET config_item_id = l_new_item_id_tbl(i)
3802: ,last_update_date = SYSDATE
3803: ,last_updated_by =G_USER_ID
3804: ,last_update_login = G_LOGIN_ID

Line 4233: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID

4229: config_hdr_id NUMBER
4230: , config_rev_number NUMBER
4231: , qte_hdr_id NUMBER
4232: ) IS
4233: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
4234: FROM ASO_Quote_Line_Details
4235: , ASO_Quote_Lines_all
4236: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4237: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

Line 4234: FROM ASO_Quote_Line_Details

4230: , config_rev_number NUMBER
4231: , qte_hdr_id NUMBER
4232: ) IS
4233: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
4234: FROM ASO_Quote_Line_Details
4235: , ASO_Quote_Lines_all
4236: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4237: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
4238: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

Line 4236: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id

4232: ) IS
4233: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
4234: FROM ASO_Quote_Line_Details
4235: , ASO_Quote_Lines_all
4236: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4237: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
4238: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
4239: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
4240: AND ASO_quote_line_details.ref_line_id is not null

Line 4237: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

4233: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
4234: FROM ASO_Quote_Line_Details
4235: , ASO_Quote_Lines_all
4236: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4237: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
4238: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
4239: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
4240: AND ASO_quote_line_details.ref_line_id is not null
4241: AND aso_quote_lines_all.quote_header_id = qte_hdr_id

Line 4238: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

4234: FROM ASO_Quote_Line_Details
4235: , ASO_Quote_Lines_all
4236: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4237: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
4238: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
4239: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
4240: AND ASO_quote_line_details.ref_line_id is not null
4241: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
4242: ORDER BY aso_quote_line_details.bom_sort_order;

Line 4239: AND ASO_quote_line_details.ref_type_code = 'CONFIG'

4235: , ASO_Quote_Lines_all
4236: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4237: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
4238: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
4239: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
4240: AND ASO_quote_line_details.ref_line_id is not null
4241: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
4242: ORDER BY aso_quote_line_details.bom_sort_order;
4243:

Line 4240: AND ASO_quote_line_details.ref_line_id is not null

4236: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4237: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
4238: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
4239: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
4240: AND ASO_quote_line_details.ref_line_id is not null
4241: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
4242: ORDER BY aso_quote_line_details.bom_sort_order;
4243:
4244: CURSOR C_Serviceable_Product (

Line 4242: ORDER BY aso_quote_line_details.bom_sort_order;

4238: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
4239: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
4240: AND ASO_quote_line_details.ref_line_id is not null
4241: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
4242: ORDER BY aso_quote_line_details.bom_sort_order;
4243:
4244: CURSOR C_Serviceable_Product (
4245: l_organization_id NUMBER
4246: , l_inv_item_id NUMBER

Line 4303: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID

4299: config_hdr_id NUMBER
4300: , config_rev_number NUMBER
4301: , qte_hdr_id NUMBER
4302: ) IS
4303: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
4304: FROM ASO_Quote_Line_Details
4305: , ASO_Quote_Lines_all
4306: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4307: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

Line 4304: FROM ASO_Quote_Line_Details

4300: , config_rev_number NUMBER
4301: , qte_hdr_id NUMBER
4302: ) IS
4303: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
4304: FROM ASO_Quote_Line_Details
4305: , ASO_Quote_Lines_all
4306: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4307: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
4308: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

Line 4306: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id

4302: ) IS
4303: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
4304: FROM ASO_Quote_Line_Details
4305: , ASO_Quote_Lines_all
4306: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4307: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
4308: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
4309: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
4310: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;

Line 4307: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

4303: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
4304: FROM ASO_Quote_Line_Details
4305: , ASO_Quote_Lines_all
4306: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4307: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
4308: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
4309: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
4310: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
4311:

Line 4308: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

4304: FROM ASO_Quote_Line_Details
4305: , ASO_Quote_Lines_all
4306: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
4307: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
4308: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
4309: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
4310: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
4311:
4312: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 6234: update aso_quote_line_details

6230: aso_debug_pub.ADD ( 'SPLIT_MODEL_LINE - New Qte Line ID ='||to_char(lx_qte_line_rec.quote_line_id), 1 , 'N' );
6231: aso_debug_pub.ADD ( 'Split_Model_Line - Updating the top model and ato line id for the top model line ', 1 , 'Y' );
6232: aso_debug_pub.ADD ( 'Split_Model_Line - l_ato_model: ' || l_ato_model , 1 , 'Y' );
6233: END IF;
6234: update aso_quote_line_details
6235: set top_model_line_id = lx_qte_line_rec.quote_line_id,
6236: ato_line_id = decode(l_ato_model,fnd_api.g_true,lx_qte_line_rec.quote_line_id,null)
6237: where quote_line_id = lx_qte_line_rec.quote_line_id;
6238:

Line 6478: UPDATE aso_quote_line_details

6474:
6475: IF l_orig_item_id_tbl.count > 0 AND l_new_item_id_tbl.count > 0 THEN
6476:
6477: FORALL i IN l_orig_item_id_tbl.FIRST..l_orig_item_id_tbl.LAST
6478: UPDATE aso_quote_line_details
6479: SET config_item_id = l_new_item_id_tbl(i)
6480: ,last_update_date = SYSDATE
6481: ,last_updated_by = G_USER_ID
6482: ,last_update_login = G_LOGIN_ID