APPS.ASO_CFG_INT dependencies on CZ_CONFIG_DETAILS_V

Line 208: from cz_config_details_v

204:
205:
206: cursor c_config_rev_nbr is
207: select config_rev_nbr
208: from cz_config_details_v
209: where config_hdr_id = p_config_header_id
210: and config_rev_nbr = p_config_revision_num;
211:
212:

Line 214: from cz_config_details_v

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

Line 556: FROM cz_config_details_v cfg_dtl ,

552: cfg_dtl.inventory_item_id ,
553: cfg_dtl.organization_id ,
554: cfg_dtl.component_code ,
555: cfg_dtl.quantity
556: FROM cz_config_details_v cfg_dtl ,
557: aso_quote_line_details qte_dtl
558: WHERE cfg_dtl.config_hdr_id = l_config_hdr_id
559: AND cfg_dtl.config_rev_nbr = l_config_rev_nbr
560: AND cfg_dtl.config_hdr_id = qte_dtl.config_header_id

Line 575: FROM cz_config_details_v cfg_dtl ,

571: cfg_dtl.inventory_item_id ,
572: cfg_dtl.organization_id ,
573: cfg_dtl.component_code ,
574: cfg_dtl.quantity
575: FROM cz_config_details_v cfg_dtl ,
576: aso_quote_line_details qte_dtl
577: WHERE qte_dtl.quote_line_id = l_model_line_id
578: AND cfg_dtl.config_hdr_id = l_config_hdr_id
579: AND cfg_dtl.config_rev_nbr = l_config_rev_nbr

Line 669: FROM cz_config_details_v cfg_dtl

665: line_type,
666: component_sequence_id,
667: ato_config_item_id,
668: model_config_item_id
669: FROM cz_config_details_v cfg_dtl
670: WHERE config_hdr_id = l_config_hdr_id
671: AND config_rev_nbr = l_config_rev_nbr
672: AND NOT EXISTS (SELECT NULL
673: FROM ASO_QUOTE_LINE_DETAILS qte_dtl

Line 697: CZ_CONFIG_DETAILS_V cfg ,

693: cfg.line_type,
694: cfg.name,
695: qte.line_type_source_flag
696: FROM ASO_QUOTE_LINE_DETAILS dtl,
697: CZ_CONFIG_DETAILS_V cfg ,
698: ASO_QUOTE_LINES_ALL qte
699: WHERE dtl.config_header_id = l_config_hdr_id
700: AND cfg.config_rev_nbr = l_config_rev_nbr
701: AND dtl.config_header_id = cfg.config_hdr_id

Line 721: FROM CZ_CONFIG_DETAILS_V cfg

717: FROM ASO_QUOTE_LINE_DETAILS dtl
718: WHERE dtl.config_header_id = l_config_hdr_id
719: AND dtl.config_revision_num = l_config_rev_nbr
720: AND NOT EXISTS ( SELECT NULL
721: FROM CZ_CONFIG_DETAILS_V cfg
722: WHERE cfg.config_item_id = dtl.config_item_id
723: AND cfg.config_hdr_id = l_config_hdr_id
724: AND cfg.config_rev_nbr = l_config_rev_nbr );
725:

Line 768: from cz_config_details_v

764: AND quote_line_id = p_config_rec.quote_line_id;
765:
766: CURSOR c_config_exist_in_cz (p_config_hdr_id number, p_config_rev_nbr number) IS
767: select config_hdr_id
768: from cz_config_details_v
769: where config_hdr_id = p_config_hdr_id
770: and config_rev_nbr = p_config_rev_nbr;
771:
772: l_api_name CONSTANT VARCHAR2(30) := 'Get_Config_Details' ;