eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_PSFT_INTEGRATION_PVT dependencies on CZ_MODEL_REF_EXPLS

Line 863: (SELECT component_id FROM cz_model_ref_expls

859: FOR i IN (SELECT devl_project_id, ps_node_id, persistent_node_id, ps_node_type,
860: reference_id, feature_type, minimum, maximum, itm.orig_sys_ref osr
861: FROM cz_ps_nodes psn, cz_item_masters itm
862: WHERE psn.deleted_flag = '0' AND psn.devl_project_id IN
863: (SELECT component_id FROM cz_model_ref_expls
864: WHERE deleted_flag = '0' AND model_id = p_model_id
865: AND (model_id = component_id OR ps_node_type = PS_NODE_TYPE_REFERENCE))
866: AND psn.item_id = itm.item_id(+) AND '0' = itm.deleted_flag(+))
867: LOOP

Line 906: (SELECT component_id FROM cz_model_ref_expls

902: psp.data_value strval, prp.def_num_value defnumval, psp.data_num_value numval,
903: psn.devl_project_id project, psn.persistent_node_id persistentid
904: FROM cz_ps_nodes psn, cz_ps_prop_vals psp, cz_properties prp
905: WHERE psn.deleted_flag = '0' AND psn.devl_project_id IN
906: (SELECT component_id FROM cz_model_ref_expls
907: WHERE deleted_flag = '0' AND model_id = p_model_id
908: AND (model_id = component_id OR ps_node_type = PS_NODE_TYPE_REFERENCE))
909: AND psp.deleted_flag = '0' AND psp.ps_node_id = psn.ps_node_id
910: AND prp.deleted_flag = '0' AND prp.property_id = psp.property_id

Line 919: (SELECT component_id FROM cz_model_ref_expls

915: psn.devl_project_id project, psn.persistent_node_id persistentid
916: FROM cz_ps_nodes psn, cz_ps_prop_vals psp, cz_properties prp,
917: cz_intl_texts deftxt, cz_intl_texts txt
918: WHERE psn.deleted_flag = '0' AND psn.devl_project_id IN
919: (SELECT component_id FROM cz_model_ref_expls
920: WHERE deleted_flag = '0' AND model_id = p_model_id
921: AND (model_id = component_id OR ps_node_type = PS_NODE_TYPE_REFERENCE))
922: AND psp.deleted_flag = '0' AND psp.ps_node_id = psn.ps_node_id
923: AND prp.deleted_flag = '0' AND prp.property_id = psp.property_id

Line 1098: FROM cz_model_ref_expls re

1094:
1095: IF l_model_id IS NOT NULL THEN
1096: BEGIN
1097: SELECT NULL INTO l_model_id
1098: FROM cz_model_ref_expls re
1099: WHERE deleted_flag = '0' AND model_id = l_model_id
1100: AND ps_node_type = PS_NODE_TYPE_REFERENCE
1101: AND NOT EXISTS (SELECT 1 FROM cz_devl_projects
1102: WHERE deleted_flag = '0' AND devl_project_id = re.component_id)