DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_PK dependencies on WIP_WS_PTP_GT

Line 726: insert into wip_ws_ptp_gt

722: wip_ws_util.trace_log(' uom = '||l_primary_uom_code);
723: wip_ws_util.trace_log(' Lead time = '||to_char(l_lead_time));
724:
725: If move_qty+scrap_qty+reject_qty <> 0 Then
726: insert into wip_ws_ptp_gt
727: (organization_id,
728: department_id,
729: wip_entity_id,
730: operation_seq_num,

Line 840: insert into wip_ws_ptp_gt

836: wip_ws_util.trace_log(' shift id = '||move_tran_rec.shift_id);
837: wip_ws_util.trace_log(' uom = '||move_tran_rec.primary_uom_code);
838: wip_ws_util.trace_log(' Lead time = '||to_char(move_tran_rec.op_lead_time));
839:
840: insert into wip_ws_ptp_gt
841: (organization_id,
842: department_id,
843: wip_entity_id,
844: operation_seq_num,

Line 906: from wip_ws_ptp_gt t

902: sysdate,
903: g_user_id,
904: sysdate,
905: g_user_id
906: from wip_ws_ptp_gt t
907: group by
908: organization_id,department_id,wip_entity_id,operation_seq_num,shift_id,primary_uom_code,
909: op_lead_time;
910: