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_LINES_ALL

Line 450: FROM aso_quote_lines_all

446: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
447: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
448: FROM ASO_LINE_RELATIONSHIPS
449: WHERE quote_line_id IN ( SELECT quote_line_id
450: FROM aso_quote_lines_all
451: WHERE quote_header_id = x_quote_header_id )
452: AND relationship_type_code <> 'SERVICE';
453:
454:

Line 531: FROM ASO_QUOTE_LINES_ALL

527: x_qte_header_id NUMBER,
528: x_qte_line_id NUMBER
529: ) IS
530: SELECT 'X'
531: FROM ASO_QUOTE_LINES_ALL
532: WHERE quote_header_id = x_qte_header_id
533: AND quote_line_id = x_qte_line_id;
534:
535: CURSOR c_line_relation_from_line_id (

Line 1259: FROM aso_quote_lines_all

1255: l_api_version CONSTANT NUMBER := 1.0;
1256:
1257: Cursor get_qte_line_number (x_qte_line_id NUMBER) IS
1258: SELECT line_number
1259: FROM aso_quote_lines_all
1260: WHERE quote_line_id = x_qte_line_id ;
1261:
1262: l_line_number NUMBER;
1263:

Line 1570: , ASO_Quote_Lines_all

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

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

Line 1627: FROM aso_quote_lines_all

1623:
1624:
1625: Cursor get_qte_line_number (x_qte_line_id NUMBER) IS
1626: SELECT line_number
1627: FROM aso_quote_lines_all
1628: WHERE quote_line_id = x_qte_line_id ;
1629:
1630: l_line_number NUMBER;
1631: l_old_quote_line_id Number;

Line 1640: , ASO_Quote_Lines_all

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

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;

Line 1644: AND ASO_Quote_Lines_all.item_type_code = 'MDL'

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

Line 1645: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;

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