APPS.WSM_JOBCOPIES_PVT dependencies on WIP_OPERATION_RESOURCES

Line 5771: INSERT INTO WIP_OPERATION_RESOURCES

5767: AND WDJ.wip_entity_id = p_wip_entity_id;
5768: end if;
5769:
5770: l_stmt_num := 60;
5771: INSERT INTO WIP_OPERATION_RESOURCES
5772: (WIP_ENTITY_ID, OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM,
5773: ORGANIZATION_ID, REPETITIVE_SCHEDULE_ID,
5774: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
5775: CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,

Line 6005: FROM WIP_OPERATION_RESOURCES WOR,

6001: SYSDATE,
6002: WCORU.INSTANCE_ID,
6003: WCORU.SERIAL_NUMBER,
6004: WCORU.CUMULATIVE_PROCESSING_TIME
6005: FROM WIP_OPERATION_RESOURCES WOR,
6006: WSM_COPY_OP_RESOURCE_USAGE WCORU
6007: WHERE WCORU.WIP_ENTITY_ID= p_wip_entity_id
6008: AND WCORU.Operation_seq_num = l_curr_op_seq_num
6009: AND WOR.WIP_ENTITY_ID= WCORU.WIP_ENTITY_ID