DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_COMPONENT_OPERATIONS

Line 2163: FROM bom_component_operations bco

2159: * with the same Op_seq_num
2160: */
2161: CURSOR c_Comp_Operation_Exist IS
2162: SELECT 'Already Exists' op_seq_exists
2163: FROM bom_component_operations bco
2164: WHERE bco.component_sequence_id =
2165: g_rev_comp_Unexp_rec.component_sequence_id
2166: AND bco.operation_seq_num =
2167: decode(g_rev_component_rec.new_operation_sequence_number,

Line 2308: FROM bom_component_operations bco,

2304: FUNCTION Check_Optional_For_Comp_Ops RETURN BOOLEAN
2305: IS
2306: CURSOR c_Change_Optional IS
2307: SELECT 'Exist' there_Exist
2308: FROM bom_component_operations bco,
2309: bom_components_b comp
2310: WHERE bco.component_sequence_id = comp.component_sequence_id
2311: AND comp.component_sequence_id = g_rev_comp_Unexp_rec.component_sequence_id
2312: AND comp.optional = 1