DBA Data[Home] [Help]

APPS.CZ_MODEL_CONVERT dependencies on CZ_PB_MODEL_EXPORTS

Line 2050: FROM cz_model_publications p , cz_pb_model_exports z

2046:
2047: v_model_conversion_set_id:=p_model_conversion_set_id;
2048: FOR v_models IN
2049: ( SELECT remote_model_id
2050: FROM cz_model_publications p , cz_pb_model_exports z
2051: WHERE p.export_status IN('OK')
2052: AND p.server_id = 0
2053: AND p.publication_mode = 'M'
2054: AND p.migration_group_id = p_model_conversion_set_id

Line 2089: FROM cz_model_publications p , cz_pb_model_exports z

2085: UPDATE cz_rules
2086: SET config_engine_type = 'F' , rule_class=nvl(rule_class,0)
2087: WHERE deleted_flag='0'
2088: AND devl_project_id IN( SELECT remote_model_id
2089: FROM cz_model_publications p , cz_pb_model_exports z
2090: WHERE p.export_status IN('OK')
2091: AND p.server_id = 0
2092: AND p.publication_mode = 'M'
2093: AND p.migration_group_id = p_model_conversion_set_id

Line 2106: FROM cz_model_publications p , cz_pb_model_exports z

2102: -- Clearing Initial values need to be done at last for all models
2103: -- as some models may have a downward contribute/consume and hence may require the initial values for accumulator rule creation
2104: FOR v_models IN
2105: ( SELECT remote_model_id
2106: FROM cz_model_publications p , cz_pb_model_exports z
2107: WHERE p.export_status IN('OK')
2108: AND p.server_id = 0
2109: AND p.publication_mode = 'M'
2110: AND p.migration_group_id = p_model_conversion_set_id

Line 2423: FROM cz_model_publications p , cz_pb_model_exports z

2419:
2420: FOR c_process IN (
2421:
2422: SELECT remote_model_id
2423: FROM cz_model_publications p , cz_pb_model_exports z
2424: WHERE p.export_status IN('OK')
2425: AND p.server_id = 0
2426: AND p.publication_mode = 'M'
2427: AND p.migration_group_id = P_request_id