DBA Data[Home] [Help]

APPS.CZ_MODEL_CONVERT dependencies on CZ_PB_MODEL_EXPORTS

Line 2077: FROM cz_model_publications p , cz_pb_model_exports z

2073:
2074: v_model_conversion_set_id:=p_model_conversion_set_id;
2075: FOR v_models IN
2076: ( SELECT remote_model_id
2077: FROM cz_model_publications p , cz_pb_model_exports z
2078: WHERE p.export_status IN('OK')
2079: AND p.server_id = 0
2080: AND p.publication_mode = 'M'
2081: AND p.migration_group_id = p_model_conversion_set_id

Line 2121: FROM cz_model_publications p , cz_pb_model_exports z

2117: UPDATE cz_rules
2118: SET config_engine_type = 'F' , rule_class=nvl(rule_class,0)
2119: WHERE deleted_flag='0'
2120: AND devl_project_id IN( SELECT remote_model_id
2121: FROM cz_model_publications p , cz_pb_model_exports z
2122: WHERE p.export_status IN('OK')
2123: AND p.server_id = 0
2124: AND p.publication_mode = 'M'
2125: AND p.migration_group_id = p_model_conversion_set_id

Line 2138: FROM cz_model_publications p , cz_pb_model_exports z

2134: -- Clearing Initial values need to be done at last for all models
2135: -- as some models may have a downward contribute/consume and hence may require the initial values for accumulator rule creation
2136: FOR v_models IN
2137: ( SELECT remote_model_id
2138: FROM cz_model_publications p , cz_pb_model_exports z
2139: WHERE p.export_status IN('OK')
2140: AND p.server_id = 0
2141: AND p.publication_mode = 'M'
2142: AND p.migration_group_id = p_model_conversion_set_id

Line 2416: FROM cz_model_publications p , cz_pb_model_exports z

2412:
2413: FOR c_process IN (
2414:
2415: SELECT remote_model_id
2416: FROM cz_model_publications p , cz_pb_model_exports z
2417: WHERE p.export_status IN('OK')
2418: AND p.server_id = 0
2419: AND p.publication_mode = 'M'
2420: AND p.migration_group_id = P_request_id