APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_PAC_EXPLOSION_TEMP
Line 2938: FROM cst_pac_explosion_temp cpet
2934: INTO l_min_child_absl_level_code
2935: FROM cst_pac_itms_absl_codes cpiac
2936: WHERE cpiac.pac_period_id = p_period_id
2937: AND cpiac.inventory_item_id IN (SELECT DISTINCT cpet.component_item_id 2938: FROM cst_pac_explosion_temp cpet 2939: WHERE cpet.pac_period_id = cpiac.pac_period_id
2940: AND cpet.assembly_item_id = items_in_current_absl_row.inventory_item_id
2941: AND cpet.component_item_id <> cpet.assembly_item_id
2942: );