DBA Data[Home] [Help]

APPS.CZ_FCE_COMPILE dependencies on CZ_TYPES

Line 871: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE

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
874: AND PARENT.effective_until > SYSDATE
875: AND NOT EXISTS

Line 872: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))

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
874: AND PARENT.effective_until > SYSDATE
875: AND NOT EXISTS
876: (SELECT 1 FROM cz_ps_nodes CHILD

Line 873: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS

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
874: AND PARENT.effective_until > SYSDATE
875: AND NOT EXISTS
876: (SELECT 1 FROM cz_ps_nodes CHILD
877: WHERE CHILD.deleted_flag = '0'