Story #67
Updated by hanny putri about 15 hours ago
Please re-mapping table BHP_WOService, trigger > backlog recalcuate with condition : * BHP_PM.cyle = OCL * BHP_PM.BHP_WOService_ID != NULL * BHP_PM.WOStatus=CO or CL * BHP_PM.PMStatus =DU Then get BHP_PM.BHP_WOService_ID and re-mapping field: * BHP_WOService.RequestedDate * BHP_WOService.StartDate * BHP_WOService.EndDate Remapping BHP_WOService based on BHP_M_PM_Rules * BHP_WOService.m_product_ID BHP_WOService.docstatus > From BHP_M_PM_Rules.DocStatus where BHP_M_PM_Rules.BHP_PM_Schedule_ID = BHP_PM.BHP_PM_Schedule_ID * BHP_WOService.m_product_category_ID * BHP_WOService.status BHP_WOService.wostatus > From BHP_M_PM_Rules.DocStatus where BHP_M_PM_Rules.BHP_PM_Schedule_ID = BHP_PM.BHP_PM_Schedule_ID