APPS.CZ_FCE_COMPILE dependencies on CZ_PS_NODES

Line 541: FROM cz_ps_nodes

537: l_psn_effectiveusagemask, l_psn_effectivitysetid, l_psn_decimalqtyflag, l_psn_ibtrackable,
538: l_psn_accumulatorflag, l_psn_initialnumvalue, l_psn_instantiableflag, l_psn_shippableitemflag,
539: l_psn_invtransactflag, l_psn_atoflag, l_psn_serialitemflag, l_psn_countedoptionsflag,
540: l_psn_devlprojectid, l_psn_domainorder, l_psn_reverseportid, l_psn_maxqtyperoption
541: FROM cz_ps_nodes
542: WHERE deleted_flag = '0'
543: START WITH ps_node_id = p_component_id
544: CONNECT BY PRIOR deleted_flag = '0' AND PRIOR ps_node_id = parent_id;
545:

Line 727: FROM cz_ps_nodes

723:
724: BEGIN
725:
726: SELECT devl_project_id INTO l_model_id
727: FROM cz_ps_nodes
728: WHERE deleted_flag = '0'
729: AND ps_node_id = l_psn_reverseportid ( i );
730:
731: EXCEPTION

Line 846: TYPE tNoChildOCNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;

842: ---------------------------------------------------------------------------------------
843: PROCEDURE report_nochild_oc ( p_component_id IN NUMBER ) IS
844:
845: -- LA 13733007 : OC with No children
846: TYPE tNoChildOCNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
847: TYPE tNoChildOCName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
848: TYPE tNoChildOCModelName IS TABLE OF cz_rp_entries.name%TYPE INDEX BY BINARY_INTEGER;
849: lNoChildOCNodeId tNoChildOCNodeId ;
850: lNoChildOCName tNoChildOCName ;

Line 847: TYPE tNoChildOCName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

843: PROCEDURE report_nochild_oc ( p_component_id IN NUMBER ) IS
844:
845: -- LA 13733007 : OC with No children
846: TYPE tNoChildOCNodeId IS TABLE OF cz_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
847: TYPE tNoChildOCName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
848: TYPE tNoChildOCModelName IS TABLE OF cz_rp_entries.name%TYPE INDEX BY BINARY_INTEGER;
849: lNoChildOCNodeId tNoChildOCNodeId ;
850: lNoChildOCName tNoChildOCName ;
851: lNoChildOCModelName tNoChildOCModelName;

Line 863: FROM cz_ps_nodes PARENT, cz_rp_entries MODEL

859: -- This query is used to report all the OCs under Root model and it's reference chain
860:
861: SELECT MODEL.NAME, PARENT.PS_NODE_ID, PARENT.NAME
862: BULK COLLECT INTO lNoChildOCModelName, lNoChildOCNodeId, lNoChildOCName
863: FROM cz_ps_nodes PARENT, cz_rp_entries MODEL
864: WHERE PARENT.deleted_flag = '0'
865: AND MODEL.deleted_flag = '0'
866: AND PARENT.devl_project_id = MODEL.object_id
867: AND MODEL.object_type = 'PRJ'

Line 876: (SELECT 1 FROM cz_ps_nodes CHILD

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'
878: AND CHILD.devl_project_id = PARENT.devl_project_id
879: AND CHILD.parent_id = PARENT.ps_node_id
880: AND CHILD.effective_until > SYSDATE);