DBA Data[Home] [Help]

APPS.CZ_LOGIC_GEN dependencies on CZ_TYPES

Line 11111: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE

11107: AND MODEL.object_type = 'PRJ'
11108: AND parent.devl_project_id IN
11109: (SELECT DISTINCT component_id FROM cz_model_ref_expls
11110: WHERE deleted_flag = '0' AND model_id = inDevlProjectId
11111: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
11112: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
11113: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS
11114: AND PARENT.effective_until > SYSDATE
11115: AND NOT EXISTS

Line 11112: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))

11108: AND parent.devl_project_id IN
11109: (SELECT DISTINCT component_id FROM cz_model_ref_expls
11110: WHERE deleted_flag = '0' AND model_id = inDevlProjectId
11111: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
11112: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
11113: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS
11114: AND PARENT.effective_until > SYSDATE
11115: AND NOT EXISTS
11116: (SELECT 1 FROM cz_ps_nodes CHILD

Line 11113: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS

11109: (SELECT DISTINCT component_id FROM cz_model_ref_expls
11110: WHERE deleted_flag = '0' AND model_id = inDevlProjectId
11111: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
11112: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
11113: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS
11114: AND PARENT.effective_until > SYSDATE
11115: AND NOT EXISTS
11116: (SELECT 1 FROM cz_ps_nodes CHILD
11117: WHERE CHILD.deleted_flag = '0'