DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_PK dependencies on WIP_WS_PTP_GT

Line 734: insert into wip_ws_ptp_gt

730: wip_ws_util.trace_log(' uom = '||l_primary_uom_code);
731: wip_ws_util.trace_log(' Lead time = '||to_char(l_lead_time));
732:
733: If move_qty+scrap_qty+reject_qty <> 0 Then
734: insert into wip_ws_ptp_gt
735: (organization_id,
736: department_id,
737: wip_entity_id,
738: operation_seq_num,

Line 848: insert into wip_ws_ptp_gt

844: wip_ws_util.trace_log(' shift id = '||move_tran_rec.shift_id);
845: wip_ws_util.trace_log(' uom = '||move_tran_rec.primary_uom_code);
846: wip_ws_util.trace_log(' Lead time = '||to_char(move_tran_rec.op_lead_time));
847:
848: insert into wip_ws_ptp_gt
849: (organization_id,
850: department_id,
851: wip_entity_id,
852: operation_seq_num,

Line 914: from wip_ws_ptp_gt t

910: sysdate,
911: g_user_id,
912: sysdate,
913: g_user_id
914: from wip_ws_ptp_gt t
915: group by
916: organization_id,department_id,wip_entity_id,operation_seq_num,shift_id,primary_uom_code,
917: op_lead_time;
918: