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

Line 408: From aso_quote_line_details

404: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) IS
405: Cursor c_update_revision IS
406: SELECT quote_line_id,
407: quote_line_Detail_id
408: From aso_quote_line_details
409: Where config_header_id = p_config_hdr_id
410: AND config_revision_num = p_config_rev_nbr ;
411:
412: l_Api_Version_Number NUMBER := 1.0 ;

Line 564: aso_quote_line_details qte_dtl

560: cfg_dtl.component_code ,
561: cfg_dtl.quantity ,
562: cfg_dtl.uom_code -- 6661597
563: FROM cz_config_details_v cfg_dtl ,
564: aso_quote_line_details qte_dtl
565: WHERE cfg_dtl.config_hdr_id = l_config_hdr_id
566: AND cfg_dtl.config_rev_nbr = l_config_rev_nbr
567: AND cfg_dtl.config_hdr_id = qte_dtl.config_header_id
568: AND cfg_dtl.config_rev_nbr = qte_dtl.config_revision_num

Line 584: aso_quote_line_details qte_dtl

580: cfg_dtl.component_code ,
581: cfg_dtl.quantity ,
582: cfg_dtl.uom_code -- 6661597
583: FROM cz_config_details_v cfg_dtl ,
584: aso_quote_line_details qte_dtl
585: WHERE qte_dtl.quote_line_id = l_model_line_id
586: AND cfg_dtl.config_hdr_id = l_config_hdr_id
587: AND cfg_dtl.config_rev_nbr = l_config_rev_nbr
588: AND cfg_dtl.config_hdr_id = qte_dtl.config_header_id

Line 761: FROM ASO_QUOTE_LINE_DETAILS qte_dtl

757: FROM cz_config_details_v cfg_dtl
758: WHERE config_hdr_id = l_config_hdr_id
759: AND config_rev_nbr = l_config_rev_nbr
760: AND NOT EXISTS (SELECT NULL
761: FROM ASO_QUOTE_LINE_DETAILS qte_dtl
762: WHERE qte_dtl.config_header_id = cfg_dtl.config_hdr_id
763: AND qte_dtl.config_revision_num = cfg_dtl.config_rev_nbr
764: AND qte_dtl.config_item_id = cfg_dtl.config_item_id )
765: ORDER BY cfg_dtl.bom_sort_order;

Line 784: FROM ASO_QUOTE_LINE_DETAILS dtl,

780: cfg.config_delta,
781: cfg.line_type,
782: cfg.name,
783: qte.line_type_source_flag
784: FROM ASO_QUOTE_LINE_DETAILS dtl,
785: CZ_CONFIG_DETAILS_V cfg ,
786: ASO_QUOTE_LINES_ALL qte
787: WHERE dtl.config_header_id = l_config_hdr_id
788: AND cfg.config_rev_nbr = l_config_rev_nbr

Line 805: FROM ASO_QUOTE_LINE_DETAILS dtl

801:
802: CURSOR C_config_details_del( l_config_hdr_id NUMBER ,
803: l_config_rev_nbr NUMBER ) IS
804: SELECT dtl.quote_line_id
805: FROM ASO_QUOTE_LINE_DETAILS dtl
806: WHERE dtl.config_header_id = l_config_hdr_id
807: AND dtl.config_revision_num = l_config_rev_nbr
808: AND NOT EXISTS ( SELECT NULL
809: FROM CZ_CONFIG_DETAILS_V cfg

Line 816: FROM aso_quote_line_details

812: AND cfg.config_rev_nbr = l_config_rev_nbr );
813:
814: CURSOR C_config_all(p_parent_config_item_id number) IS
815: SELECT quote_line_id
816: FROM aso_quote_line_details
817: WHERE config_header_id = p_config_hdr_id
818: AND config_revision_num = p_config_rev_nbr
819: AND config_item_id = p_parent_config_item_id;
820:

Line 824: FROM aso_quote_line_details

820:
821: CURSOR C_Config_Exists( l_config_hdr_id NUMBER ,
822: l_config_rev_nbr NUMBER ) IS
823: SELECT quote_line_id
824: FROM aso_quote_line_details
825: WHERE ref_type_code = 'CONFIG'
826: AND ref_line_id IS NULL
827: AND config_header_id = l_config_hdr_id
828: AND config_revision_num = l_config_rev_nbr;

Line 849: FROM aso_quote_line_details

845: AND config_rev_nbr = p_config_rev_nbr;
846:
847: CURSOR C_diff_Config_Exists IS
848: SELECT config_header_id
849: FROM aso_quote_line_details
850: WHERE ref_type_code = 'CONFIG'
851: AND ref_line_id IS NULL
852: AND quote_line_id = p_config_rec.quote_line_id;
853:

Line 1080: --will not be the same as in aso_quote_line_details.

1076:
1077: --check if revision number has changed for this configuration.
1078: --if yes update all the previous selected options to the current
1079: --revision number.This is necessary as the current revision number
1080: --will not be the same as in aso_quote_line_details.
1081:
1082: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1083: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1084: (p_config_rec.config_header_id IS NOT NULL AND

Line 1093: UPDATE aso_quote_line_details

1089: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1090: aso_debug_pub.add( 'ASO_CFG_INT: Get_config_details: Revision number has changed so updating');
1091: END IF;
1092:
1093: UPDATE aso_quote_line_details
1094: SET config_revision_num = p_config_rev_nbr,
1095: last_update_date = sysdate,
1096: last_updated_by = FND_GLOBAL.USER_ID,
1097: last_update_login = FND_GLOBAL.CONC_LOGIN_ID

Line 1907: from aso_quote_line_details

1903: and a.quote_line_id = p_quote_line_id;
1904:
1905: Cursor c_config_header_id ( p_quote_line_id NUMBER ) is
1906: Select config_header_id
1907: from aso_quote_line_details
1908: where quote_line_id = p_quote_line_id;
1909:
1910: Cursor c_pricelist_id ( p_config_item_id NUMBER, p_config_header_id NUMBER ) is
1911: Select qtl.price_list_id, qtl.quote_line_id

Line 1913: aso_quote_line_details qtl_dtl

1909:
1910: Cursor c_pricelist_id ( p_config_item_id NUMBER, p_config_header_id NUMBER ) is
1911: Select qtl.price_list_id, qtl.quote_line_id
1912: from aso_quote_lines_all qtl,
1913: aso_quote_line_details qtl_dtl
1914: where qtl.quote_line_id = qtl_dtl.quote_line_id
1915: and qtl_dtl.config_item_id = p_config_item_id
1916: and qtl_dtl.config_header_id = p_config_header_id
1917: and ref_line_id is not null;

Line 1921: from aso_quote_line_details

1917: and ref_line_id is not null;
1918:
1919: Cursor c_config_line(p_quote_line_id NUMBER, p_config_header_id NUMBER) is
1920: Select quote_line_id
1921: from aso_quote_line_details
1922: where quote_line_id = p_quote_line_id
1923: and config_header_id = p_config_header_id
1924: and ref_line_id is not null;
1925:

Line 2592: from aso_quote_line_details a

2588: charge_periodicity_code
2589: from aso_quote_lines_all
2590: where quote_header_id = p_qte_header_id
2591: and quote_line_id not in ( select a.quote_line_id
2592: from aso_quote_line_details a
2593: where (a.config_header_id, a.config_revision_num)
2594: = ( select config_header_id, config_revision_num
2595: from aso_quote_line_details
2596: where quote_line_id = p_qte_line_id ))

Line 2595: from aso_quote_line_details

2591: and quote_line_id not in ( select a.quote_line_id
2592: from aso_quote_line_details a
2593: where (a.config_header_id, a.config_revision_num)
2594: = ( select config_header_id, config_revision_num
2595: from aso_quote_line_details
2596: where quote_line_id = p_qte_line_id ))
2597: and quote_line_id <> p_qte_line_id;
2598:
2599:

Line 3334: , ASO_QUOTE_LINE_DETAILS and ASO_LINE_RELATIONSHIPS

3330: that are updated and deleted from the model.
3331: Parse_output_xml : parses the CZ output xml message to see if the configuration
3332: is valid and complete.
3333: Get_config_details : To save options along with the model line in ASO_QUOTE_LINES_ALL
3334: , ASO_QUOTE_LINE_DETAILS and ASO_LINE_RELATIONSHIPS
3335: -----------------------------------------------------------------------*/
3336:
3337: PROCEDURE Validate_Configuration
3338: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,