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

Line 962: update aso_quote_line_details

958: IF aso_debug_pub.g_debug_flag = 'Y' THEN
959: aso_debug_pub.ADD ( 'Copy_Template - Updating the top model and ato line id for the top model line ', 1 , 'Y' );
960: aso_debug_pub.ADD ( 'Copy_Template - l_ato_model: ' || l_ato_model , 1 , 'Y' );
961: END IF;
962: update aso_quote_line_details
963: set top_model_line_id = lx_qte_line_rec.quote_line_id,
964: ato_line_id = decode(l_ato_model,fnd_api.g_true,lx_qte_line_rec.quote_line_id,null)
965: where quote_line_id = lx_qte_line_rec.quote_line_id;
966:

Line 1090: UPDATE aso_quote_line_details

1086:
1087: IF l_orig_item_id_tbl.count > 0 AND l_new_item_id_tbl.count > 0 THEN
1088:
1089: FORALL i IN l_orig_item_id_tbl.FIRST..l_orig_item_id_tbl.LAST
1090: UPDATE aso_quote_line_details
1091: SET config_item_id = l_new_item_id_tbl(i)
1092: ,last_update_date = SYSDATE
1093: ,last_updated_by =G_USER_ID
1094: ,last_update_login = G_LOGIN_ID

Line 1568: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID

1564: config_hdr_id NUMBER
1565: , config_rev_number NUMBER
1566: , qte_hdr_id NUMBER
1567: ) IS
1568: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
1569: FROM ASO_Quote_Line_Details
1570: , ASO_Quote_Lines_all
1571: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1572: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

Line 1569: FROM ASO_Quote_Line_Details

1565: , config_rev_number NUMBER
1566: , qte_hdr_id NUMBER
1567: ) IS
1568: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
1569: FROM ASO_Quote_Line_Details
1570: , ASO_Quote_Lines_all
1571: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1572: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
1573: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

Line 1571: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id

1567: ) IS
1568: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
1569: FROM ASO_Quote_Line_Details
1570: , ASO_Quote_Lines_all
1571: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1572: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
1573: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
1574: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
1575: AND ASO_quote_line_details.ref_line_id is not null

Line 1572: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

1568: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
1569: FROM ASO_Quote_Line_Details
1570: , ASO_Quote_Lines_all
1571: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1572: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
1573: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
1574: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
1575: AND ASO_quote_line_details.ref_line_id is not null
1576: AND aso_quote_lines_all.quote_header_id = qte_hdr_id

Line 1573: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

1569: FROM ASO_Quote_Line_Details
1570: , ASO_Quote_Lines_all
1571: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1572: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
1573: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
1574: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
1575: AND ASO_quote_line_details.ref_line_id is not null
1576: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
1577: ORDER BY aso_quote_line_details.bom_sort_order;

Line 1574: AND ASO_quote_line_details.ref_type_code = 'CONFIG'

1570: , ASO_Quote_Lines_all
1571: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1572: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
1573: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
1574: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
1575: AND ASO_quote_line_details.ref_line_id is not null
1576: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
1577: ORDER BY aso_quote_line_details.bom_sort_order;
1578:

Line 1575: AND ASO_quote_line_details.ref_line_id is not null

1571: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1572: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
1573: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
1574: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
1575: AND ASO_quote_line_details.ref_line_id is not null
1576: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
1577: ORDER BY aso_quote_line_details.bom_sort_order;
1578:
1579: CURSOR C_Serviceable_Product (

Line 1577: ORDER BY aso_quote_line_details.bom_sort_order;

1573: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
1574: AND ASO_quote_line_details.ref_type_code = 'CONFIG'
1575: AND ASO_quote_line_details.ref_line_id is not null
1576: AND aso_quote_lines_all.quote_header_id = qte_hdr_id
1577: ORDER BY aso_quote_line_details.bom_sort_order;
1578:
1579: CURSOR C_Serviceable_Product (
1580: l_organization_id NUMBER
1581: , l_inv_item_id NUMBER

Line 1638: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID

1634: config_hdr_id NUMBER
1635: , config_rev_number NUMBER
1636: , qte_hdr_id NUMBER
1637: ) IS
1638: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
1639: FROM ASO_Quote_Line_Details
1640: , ASO_Quote_Lines_all
1641: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1642: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

Line 1639: FROM ASO_Quote_Line_Details

1635: , config_rev_number NUMBER
1636: , qte_hdr_id NUMBER
1637: ) IS
1638: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
1639: FROM ASO_Quote_Line_Details
1640: , ASO_Quote_Lines_all
1641: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1642: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
1643: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

Line 1641: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id

1637: ) IS
1638: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
1639: FROM ASO_Quote_Line_Details
1640: , ASO_Quote_Lines_all
1641: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1642: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
1643: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
1644: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
1645: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;

Line 1642: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number

1638: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
1639: FROM ASO_Quote_Line_Details
1640: , ASO_Quote_Lines_all
1641: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1642: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
1643: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
1644: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
1645: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
1646:

Line 1643: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

1639: FROM ASO_Quote_Line_Details
1640: , ASO_Quote_Lines_all
1641: WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
1642: AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
1643: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
1644: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
1645: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
1646:
1647: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;