APPS.CZ_FCE_COMPILE dependencies on CZ_MODEL_REF_EXPLS

Line 869: (SELECT DISTINCT component_id FROM cz_model_ref_expls

865: AND MODEL.deleted_flag = '0'
866: AND PARENT.devl_project_id = MODEL.object_id
867: AND MODEL.object_type = 'PRJ'
868: AND parent.devl_project_id IN
869: (SELECT DISTINCT component_id FROM cz_model_ref_expls
870: WHERE deleted_flag = '0' AND model_id = p_component_id
871: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
872: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
873: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS

Line 10721: FROM cz_model_ref_expls

10717:
10718: SELECT model_ref_expl_id, parent_expl_node_id, component_id, referring_node_id, expl_node_type
10719: BULK COLLECT INTO t_expl_modelrefexplid, t_expl_parentexplnodeid, t_expl_componentid,
10720: t_expl_referringnodeid, t_expl_explnodetype
10721: FROM cz_model_ref_expls
10722: WHERE model_id = p_component_id
10723: AND deleted_flag = '0';
10724:
10725: FOR i IN 1..t_expl_modelrefexplid.COUNT LOOP