APPS.ASO_CFG_INT dependencies on CZ_CONFIG_DETAILS_V

Line 210: from cz_config_details_v

206: l_copy_config_profile varchar2(1):=nvl(fnd_profile.value('ASO_COPY_CONFIG_EFF_DATE'),'Y');
207:
208: cursor c_config_rev_nbr is
209: select config_rev_nbr
210: from cz_config_details_v
211: where config_hdr_id = p_config_header_id
212: and config_rev_nbr = p_config_revision_num;
213:
214:

Line 216: from cz_config_details_v

212: and config_rev_nbr = p_config_revision_num;
213:
214:
215: cursor c_config_max_rev_nbr is select max(config_rev_nbr)
216: from cz_config_details_v
217: where config_hdr_id = p_config_header_id;
218:
219:
220: BEGIN

Line 563: FROM cz_config_details_v cfg_dtl ,

559: cfg_dtl.organization_id ,
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

Line 583: FROM cz_config_details_v cfg_dtl ,

579: cfg_dtl.organization_id ,
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

Line 757: FROM cz_config_details_v cfg_dtl

753: line_type,
754: component_sequence_id,
755: ato_config_item_id,
756: model_config_item_id
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

Line 785: CZ_CONFIG_DETAILS_V cfg ,

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
789: AND dtl.config_header_id = cfg.config_hdr_id

Line 809: FROM CZ_CONFIG_DETAILS_V cfg

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
810: WHERE cfg.config_item_id = dtl.config_item_id
811: AND cfg.config_hdr_id = l_config_hdr_id
812: AND cfg.config_rev_nbr = l_config_rev_nbr );
813:

Line 856: from cz_config_details_v

852: AND quote_line_id = p_config_rec.quote_line_id;
853:
854: CURSOR c_config_exist_in_cz (p_config_hdr_id number, p_config_rev_nbr number) IS
855: select config_hdr_id
856: from cz_config_details_v
857: where config_hdr_id = p_config_hdr_id
858: and config_rev_nbr = p_config_rev_nbr;
859:
860: l_api_name CONSTANT VARCHAR2(30) := 'Get_Config_Details' ;