DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_COMPONENT_OPERATIONS

Line 2171: FROM bom_component_operations bco

2167: * with the same Op_seq_num
2168: */
2169: CURSOR c_Comp_Operation_Exist IS
2170: SELECT 'Already Exists' op_seq_exists
2171: FROM bom_component_operations bco
2172: WHERE bco.component_sequence_id =
2173: g_rev_comp_Unexp_rec.component_sequence_id
2174: AND bco.operation_seq_num =
2175: decode(g_rev_component_rec.new_operation_sequence_number,

Line 2316: FROM bom_component_operations bco,

2312: FUNCTION Check_Optional_For_Comp_Ops RETURN BOOLEAN
2313: IS
2314: CURSOR c_Change_Optional IS
2315: SELECT 'Exist' there_Exist
2316: FROM bom_component_operations bco,
2317: bom_components_b comp
2318: WHERE bco.component_sequence_id = comp.component_sequence_id
2319: AND comp.component_sequence_id = g_rev_comp_Unexp_rec.component_sequence_id
2320: AND comp.optional = 1