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_LINES_ALL

Line 1618: FROM aso_quote_lines_all

1614: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
1615: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
1616: FROM ASO_LINE_RELATIONSHIPS
1617: WHERE quote_line_id IN ( SELECT quote_line_id
1618: FROM aso_quote_lines_all
1619: WHERE quote_header_id = x_quote_header_id )
1620: AND relationship_type_code <> 'SERVICE';
1621:
1622: CURSOR c_price_adj_rel (

Line 1636: FROM aso_quote_lines_all aql

1632: , ASO_PRICE_ADJUSTMENTS apa
1633: WHERE apr.price_adjustment_id = apa.price_adjustment_id
1634: AND apa.quote_header_id = x_quote_header_id
1635: AND EXISTS ( SELECT 'x'
1636: FROM aso_quote_lines_all aql
1637: WHERE aql.quote_header_id = x_quote_header_id
1638: AND apr.quote_line_id = aql.quote_line_id );
1639:
1640: CURSOR C_Serviceable_Product (

Line 1717: FROM ASO_QUOTE_LINES_ALL

1713: x_qte_header_id NUMBER,
1714: x_qte_line_id NUMBER
1715: ) IS
1716: SELECT 'X'
1717: FROM ASO_QUOTE_LINES_ALL
1718: WHERE quote_header_id = x_qte_header_id
1719: AND quote_line_id = x_qte_line_id;
1720:
1721: CURSOR c_line_relation_from_line_id (

Line 1765: From ASO_QUOTE_LINES_ALL

1761: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
1762:
1763: Cursor Get_Max_Line_Number ( c_QUOTE_HEADER_ID Number) IS
1764: Select Max(Line_number)
1765: From ASO_QUOTE_LINES_ALL
1766: WHERE quote_header_id = c_QUOTE_HEADER_ID;
1767:
1768: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
1769: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

Line 2436: p_old_object_code => 'ASO_QUOTE_LINES_ALL',

2432: END IF;
2433:
2434: ASO_ATTACHMENT_INT.Copy_Attachments(
2435: p_api_version => l_api_version,
2436: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
2437: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
2438: p_old_object_id => L_QTE_LINE_ID,
2439: p_new_object_id => lx_qte_line_rec.quote_line_id,
2440: x_return_status => l_return_status,

Line 2437: p_new_object_code => 'ASO_QUOTE_LINES_ALL',

2433:
2434: ASO_ATTACHMENT_INT.Copy_Attachments(
2435: p_api_version => l_api_version,
2436: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
2437: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
2438: p_old_object_id => L_QTE_LINE_ID,
2439: p_new_object_id => lx_qte_line_rec.quote_line_id,
2440: x_return_status => l_return_status,
2441: x_msg_count => x_msg_count,

Line 2927: , ASO_Quote_Lines_all

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

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

Line 2984: FROM aso_quote_lines_all

2980:
2981:
2982: Cursor get_qte_line_number (x_qte_line_id NUMBER) IS
2983: SELECT line_number
2984: FROM aso_quote_lines_all
2985: WHERE quote_line_id = x_qte_line_id ;
2986:
2987: l_line_number NUMBER;
2988: l_old_quote_line_id Number;

Line 2997: , ASO_Quote_Lines_all

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

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

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

Line 3002: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;

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

Line 3358: p_old_object_code => 'ASO_QUOTE_LINES_ALL',

3354: END IF;
3355:
3356: ASO_ATTACHMENT_INT.Copy_Attachments(
3357: p_api_version => l_api_version,
3358: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
3359: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
3360: p_old_object_id => qte_line_id,
3361: p_new_object_id => lx_qte_line_rec.quote_line_id,
3362: x_return_status => x_return_status ,

Line 3359: p_new_object_code => 'ASO_QUOTE_LINES_ALL',

3355:
3356: ASO_ATTACHMENT_INT.Copy_Attachments(
3357: p_api_version => l_api_version,
3358: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
3359: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
3360: p_old_object_id => qte_line_id,
3361: p_new_object_id => lx_qte_line_rec.quote_line_id,
3362: x_return_status => x_return_status ,
3363: x_msg_count => x_msg_count,

Line 3484: FROM aso_quote_lines_all

3480: l_api_version CONSTANT NUMBER := 1.0;
3481:
3482: Cursor get_qte_line_number (x_qte_line_id NUMBER) IS
3483: SELECT line_number
3484: FROM aso_quote_lines_all
3485: WHERE quote_line_id = x_qte_line_id ;
3486:
3487: l_line_number NUMBER;
3488:

Line 3815: p_old_object_code => 'ASO_QUOTE_LINES_ALL',

3811: END IF;
3812:
3813: ASO_ATTACHMENT_INT.Copy_Attachments (
3814: p_api_version => l_api_version,
3815: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
3816: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
3817: p_old_object_id => qte_line_id,
3818: p_new_object_id => lx_qte_line_rec.quote_line_id,
3819: x_return_status => x_return_status,

Line 3816: p_new_object_code => 'ASO_QUOTE_LINES_ALL',

3812:
3813: ASO_ATTACHMENT_INT.Copy_Attachments (
3814: p_api_version => l_api_version,
3815: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
3816: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
3817: p_old_object_id => qte_line_id,
3818: p_new_object_id => lx_qte_line_rec.quote_line_id,
3819: x_return_status => x_return_status,
3820: x_msg_count => x_msg_count,

Line 4209: FROM ASO_QUOTE_LINES_ALL

4205: x_qte_header_id NUMBER,
4206: x_qte_line_id NUMBER
4207: ) IS
4208: SELECT 'X'
4209: FROM ASO_QUOTE_LINES_ALL
4210: WHERE quote_header_id = x_qte_header_id
4211: AND quote_line_id = x_qte_line_id;
4212:
4213:

Line 4273: From ASO_QUOTE_LINES_ALL

4269:
4270:
4271: Cursor Get_Max_Line_Number ( c_QUOTE_HEADER_ID Number) IS
4272: Select Max(Line_number)
4273: From ASO_QUOTE_LINES_ALL
4274: WHERE quote_header_id = c_QUOTE_HEADER_ID;
4275:
4276: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
4277: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

Line 5028: p_old_object_code => 'ASO_QUOTE_LINES_ALL',

5024: END IF;
5025:
5026: ASO_ATTACHMENT_INT.Copy_Attachments(
5027: p_api_version => l_api_version,
5028: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
5029: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
5030: p_old_object_id => P_Original_Qte_Line_Rec.quote_line_id,
5031: p_new_object_id => lx_qte_line_rec.quote_line_id,
5032: x_return_status => l_return_status,

Line 5029: p_new_object_code => 'ASO_QUOTE_LINES_ALL',

5025:
5026: ASO_ATTACHMENT_INT.Copy_Attachments(
5027: p_api_version => l_api_version,
5028: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
5029: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
5030: p_old_object_id => P_Original_Qte_Line_Rec.quote_line_id,
5031: p_new_object_id => lx_qte_line_rec.quote_line_id,
5032: x_return_status => l_return_status,
5033: x_msg_count => x_msg_count,