DBA Data[Home] [Help]

APPS.BOMPCMBM dependencies on BOM_COMPONENT_OPERATIONS_S

Line 3390: bom_component_operations_s.NEXTVAL ,

3386: ATTRIBUTE14 ,
3387: ATTRIBUTE15 ,
3388: COMMON_COMPONENT_SEQUENCE_ID)
3389: SELECT
3390: bom_component_operations_s.NEXTVAL ,
3391: comp_ops.OPERATION_SEQ_NUM ,
3392: comp_ops.OPERATION_SEQUENCE_ID ,
3393: comp_ops.LAST_UPDATE_DATE ,
3394: comp_ops.LAST_UPDATED_BY ,

Line 3539: bom_component_operations_s.NEXTVAL ,

3535: ATTRIBUTE14 ,
3536: ATTRIBUTE15 ,
3537: COMMON_COMPONENT_SEQUENCE_ID)
3538: VALUES(
3539: bom_component_operations_s.NEXTVAL ,
3540: comp_ops.OPERATION_SEQ_NUM ,
3541: comp_ops.OPERATION_SEQUENCE_ID ,
3542: comp_ops.LAST_UPDATE_DATE ,
3543: comp_ops.LAST_UPDATED_BY ,

Line 3654: UPDATE bom_component_operations SET

3650: for comp_ops in get_comp_op_details(p_component_sequence_id, p_new_operation_seq_num)
3651: loop
3652: /*for dest_comp in get_destn_comps(p_component_sequence_id)
3653: loop*/
3654: UPDATE bom_component_operations SET
3655: OPERATION_SEQ_NUM = comp_ops.OPERATION_SEQ_NUM ,
3656: OPERATION_SEQUENCE_ID = comp_ops.OPERATION_SEQUENCE_ID,
3657: LAST_UPDATE_DATE = comp_ops.LAST_UPDATE_DATE ,
3658: LAST_UPDATED_BY = comp_ops.LAST_UPDATED_BY ,