DBA Data[Home] [Help]

APPS.CZ_UPGRADE dependencies on CZ_CONFIG_DETAILS_V

Line 3080: FROM cz_config_details_v c

3076:
3077: FOR c_native IN (SELECT config_hdr_id,
3078: config_rev_nbr,
3079: config_item_id
3080: FROM cz_config_details_v c
3081: WHERE (ps_node_id IS NULL OR ps_node_id < 0)
3082: AND bom_sort_order IS NULL
3083: AND parent_config_item_id NOT IN
3084: (SELECT config_item_id FROM cz_config_details_v

Line 3084: (SELECT config_item_id FROM cz_config_details_v

3080: FROM cz_config_details_v c
3081: WHERE (ps_node_id IS NULL OR ps_node_id < 0)
3082: AND bom_sort_order IS NULL
3083: AND parent_config_item_id NOT IN
3084: (SELECT config_item_id FROM cz_config_details_v
3085: WHERE config_hdr_id = c.config_hdr_id
3086: AND config_rev_nbr = c.config_rev_nbr))LOOP
3087:
3088: globalIndex := globalIndex + 1;