APPS.WSM_JOBCOPIES_PVT dependencies on WIP_OPERATION_RESOURCES

Line 5540: INSERT INTO WIP_OPERATION_RESOURCES

5536: AND WDJ.wip_entity_id = p_wip_entity_id;
5537: end if;
5538:
5539: l_stmt_num := 60;
5540: INSERT INTO WIP_OPERATION_RESOURCES
5541: (WIP_ENTITY_ID, OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM,
5542: ORGANIZATION_ID, REPETITIVE_SCHEDULE_ID,
5543: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
5544: CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,

Line 5774: FROM WIP_OPERATION_RESOURCES WOR,

5770: SYSDATE,
5771: WCORU.INSTANCE_ID,
5772: WCORU.SERIAL_NUMBER,
5773: WCORU.CUMULATIVE_PROCESSING_TIME
5774: FROM WIP_OPERATION_RESOURCES WOR,
5775: WSM_COPY_OP_RESOURCE_USAGE WCORU
5776: WHERE WCORU.WIP_ENTITY_ID= p_wip_entity_id
5777: AND WCORU.Operation_seq_num = l_curr_op_seq_num
5778: AND WOR.WIP_ENTITY_ID= WCORU.WIP_ENTITY_ID