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_LINES_ALL

Line 2313: FROM aso_quote_lines_all

2309: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
2310: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
2311: FROM ASO_LINE_RELATIONSHIPS
2312: WHERE quote_line_id IN ( SELECT quote_line_id
2313: FROM aso_quote_lines_all
2314: WHERE quote_header_id = x_quote_header_id )
2315: AND relationship_type_code <> 'SERVICE';
2316:
2317: CURSOR c_price_adj_rel (

Line 2331: FROM aso_quote_lines_all aql

2327: , ASO_PRICE_ADJUSTMENTS apa
2328: WHERE apr.price_adjustment_id = apa.price_adjustment_id
2329: AND apa.quote_header_id = x_quote_header_id
2330: AND EXISTS ( SELECT 'x'
2331: FROM aso_quote_lines_all aql
2332: WHERE aql.quote_header_id = x_quote_header_id
2333: AND apr.quote_line_id = aql.quote_line_id );
2334:
2335: CURSOR C_Serviceable_Product (

Line 2412: FROM ASO_QUOTE_LINES_ALL

2408: x_qte_header_id NUMBER,
2409: x_qte_line_id NUMBER
2410: ) IS
2411: SELECT 'X'
2412: FROM ASO_QUOTE_LINES_ALL
2413: WHERE quote_header_id = x_qte_header_id
2414: AND quote_line_id = x_qte_line_id;
2415:
2416: CURSOR c_line_relation_from_line_id (

Line 2460: From ASO_QUOTE_LINES_ALL

2456: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
2457:
2458: Cursor Get_Max_Line_Number ( c_QUOTE_HEADER_ID Number) IS
2459: Select Max(Line_number)
2460: From ASO_QUOTE_LINES_ALL
2461: WHERE quote_header_id = c_QUOTE_HEADER_ID;
2462:
2463: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
2464: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

Line 3650: p_old_object_code => 'ASO_QUOTE_LINES_ALL',

3646: END IF;
3647:
3648: ASO_ATTACHMENT_INT.Copy_Attachments(
3649: p_api_version => l_api_version,
3650: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
3651: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
3652: p_old_object_id => L_QTE_LINE_ID,
3653: p_new_object_id => lx_qte_line_rec.quote_line_id,
3654: x_return_status => l_return_status,

Line 3651: p_new_object_code => 'ASO_QUOTE_LINES_ALL',

3647:
3648: ASO_ATTACHMENT_INT.Copy_Attachments(
3649: p_api_version => l_api_version,
3650: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
3651: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
3652: p_old_object_id => L_QTE_LINE_ID,
3653: p_new_object_id => lx_qte_line_rec.quote_line_id,
3654: x_return_status => l_return_status,
3655: x_msg_count => x_msg_count,

Line 4235: , ASO_Quote_Lines_all

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
4239: AND ASO_quote_line_details.ref_type_code = 'CONFIG'

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 4241: AND aso_quote_lines_all.quote_header_id = qte_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 (
4245: l_organization_id NUMBER

Line 4292: FROM aso_quote_lines_all

4288:
4289:
4290: Cursor get_qte_line_number (x_qte_line_id NUMBER) IS
4291: SELECT line_number
4292: FROM aso_quote_lines_all
4293: WHERE quote_line_id = x_qte_line_id ;
4294:
4295: l_line_number NUMBER;
4296: l_old_quote_line_id Number;

Line 4305: , ASO_Quote_Lines_all

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
4309: AND ASO_Quote_Lines_all.item_type_code = 'MDL'

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 4309: AND ASO_Quote_Lines_all.item_type_code = 'MDL'

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;
4313: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 4310: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;

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;
4313: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4314: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 4666: p_old_object_code => 'ASO_QUOTE_LINES_ALL',

4662: END IF;
4663:
4664: ASO_ATTACHMENT_INT.Copy_Attachments(
4665: p_api_version => l_api_version,
4666: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
4667: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
4668: p_old_object_id => qte_line_id,
4669: p_new_object_id => lx_qte_line_rec.quote_line_id,
4670: x_return_status => x_return_status ,

Line 4667: p_new_object_code => 'ASO_QUOTE_LINES_ALL',

4663:
4664: ASO_ATTACHMENT_INT.Copy_Attachments(
4665: p_api_version => l_api_version,
4666: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
4667: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
4668: p_old_object_id => qte_line_id,
4669: p_new_object_id => lx_qte_line_rec.quote_line_id,
4670: x_return_status => x_return_status ,
4671: x_msg_count => x_msg_count,

Line 4792: FROM aso_quote_lines_all

4788: l_api_version CONSTANT NUMBER := 1.0;
4789:
4790: Cursor get_qte_line_number (x_qte_line_id NUMBER) IS
4791: SELECT line_number
4792: FROM aso_quote_lines_all
4793: WHERE quote_line_id = x_qte_line_id ;
4794:
4795: l_line_number NUMBER;
4796:

Line 5123: p_old_object_code => 'ASO_QUOTE_LINES_ALL',

5119: END IF;
5120:
5121: ASO_ATTACHMENT_INT.Copy_Attachments (
5122: p_api_version => l_api_version,
5123: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
5124: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
5125: p_old_object_id => qte_line_id,
5126: p_new_object_id => lx_qte_line_rec.quote_line_id,
5127: x_return_status => x_return_status,

Line 5124: p_new_object_code => 'ASO_QUOTE_LINES_ALL',

5120:
5121: ASO_ATTACHMENT_INT.Copy_Attachments (
5122: p_api_version => l_api_version,
5123: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
5124: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
5125: p_old_object_id => qte_line_id,
5126: p_new_object_id => lx_qte_line_rec.quote_line_id,
5127: x_return_status => x_return_status,
5128: x_msg_count => x_msg_count,

Line 5517: FROM ASO_QUOTE_LINES_ALL

5513: x_qte_header_id NUMBER,
5514: x_qte_line_id NUMBER
5515: ) IS
5516: SELECT 'X'
5517: FROM ASO_QUOTE_LINES_ALL
5518: WHERE quote_header_id = x_qte_header_id
5519: AND quote_line_id = x_qte_line_id;
5520:
5521:

Line 5581: From ASO_QUOTE_LINES_ALL

5577:
5578:
5579: Cursor Get_Max_Line_Number ( c_QUOTE_HEADER_ID Number) IS
5580: Select Max(Line_number)
5581: From ASO_QUOTE_LINES_ALL
5582: WHERE quote_header_id = c_QUOTE_HEADER_ID;
5583:
5584: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
5585: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

Line 6336: p_old_object_code => 'ASO_QUOTE_LINES_ALL',

6332: END IF;
6333:
6334: ASO_ATTACHMENT_INT.Copy_Attachments(
6335: p_api_version => l_api_version,
6336: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
6337: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
6338: p_old_object_id => P_Original_Qte_Line_Rec.quote_line_id,
6339: p_new_object_id => lx_qte_line_rec.quote_line_id,
6340: x_return_status => l_return_status,

Line 6337: p_new_object_code => 'ASO_QUOTE_LINES_ALL',

6333:
6334: ASO_ATTACHMENT_INT.Copy_Attachments(
6335: p_api_version => l_api_version,
6336: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
6337: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
6338: p_old_object_id => P_Original_Qte_Line_Rec.quote_line_id,
6339: p_new_object_id => lx_qte_line_rec.quote_line_id,
6340: x_return_status => l_return_status,
6341: x_msg_count => x_msg_count,