[Home] [Help]
1082:
1083: DELETE WSM_COPY_OP_RESOURCE_USAGE
1084: WHERE wip_entity_id = p_wip_entity_id;
1085:
1086: DELETE WSM_COPY_REQUIREMENT_OPS
1087: WHERE wip_entity_id = p_wip_entity_id;
1088:
1089: end if; --End of check on p_new_job before deleting the copy tables
1090:
2160: if p_phantom_exists = 2 and p_common_bill_seq_id IS NOT NULL THEN --Code review remark
2161: l_phantom_org_id := p_org_id; --Added for bug 4515000
2162: --Populate primary and substitute components. As no phantom exists
2163: --no need for calling bom exploder code.
2164: INSERT INTO WSM_COPY_REQUIREMENT_OPS
2165: (WIP_ENTITY_ID,
2166: OPERATION_SEQ_NUM,
2167: COMPONENT_ITEM_ID,
2168: PRIMARY_COMPONENT_ID,
2416: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCR) (Primary Components) for we_id='||p_wip_entity_id);
2417: END IF;
2418: --IF SQL%ROWCOUNT > 0 THEN
2419: --Insert substitute components only when there are primary components.
2420: INSERT INTO WSM_COPY_REQUIREMENT_OPS
2421: (WIP_ENTITY_ID,
2422: OPERATION_SEQ_NUM,
2423: COMPONENT_ITEM_ID,
2424: PRIMARY_COMPONENT_ID,
2597: a.attribute15,
2598: wcro.original_system_reference
2599: FROM BOM_SUBSTITUTE_COMPONENTS A,
2600: MTL_SYSTEM_ITEMS C,
2601: WSM_COPY_REQUIREMENT_OPS wcro
2602: WHERE wcro.wip_entity_id = p_wip_entity_id
2603: AND a.component_sequence_id = wcro.component_sequence_id
2604: AND a.SUBSTITUTE_COMPONENT_ID = c.inventory_item_id
2605: AND c.organization_id = p_org_id
3325: ---COMP_ITEM_ID, PRI_COMP_ID, COMP_SEQ_ID and SRC_PHANTOM_ID---
3326:
3327:
3328: l_stmt_num := 260;
3329: INSERT INTO WSM_COPY_REQUIREMENT_OPS
3330: (WIP_ENTITY_ID,
3331: OPERATION_SEQ_NUM,
3332: COMPONENT_ITEM_ID,
3333: PRIMARY_COMPONENT_ID,
3574: BOM_OPERATION_RESOURCES BOR,
3575: BOM_DEPARTMENT_RESOURCES BDR1,
3576: BOM_OPERATION_SEQUENCES BOS,
3577: BOM_OPERATIONAL_ROUTINGS BRTG,
3578: WSM_COPY_REQUIREMENT_OPS WCRO,
3579: MTL_SYSTEM_ITEMS MSI --BUG 6495025
3580: WHERE wcro.wip_entity_id=p_wip_entity_id
3581: AND wcro.organization_id=p_org_id
3582: AND wcro.Operation_seq_num = -l_curr_op_seq_num
4170:
4171: DELETE WSM_COPY_OP_RESOURCE_USAGE
4172: WHERE wip_entity_id = p_new_wip_entity_id;
4173:
4174: DELETE WSM_COPY_REQUIREMENT_OPS
4175: WHERE wip_entity_id = p_new_wip_entity_id;
4176: */
4177: DELETE WSM_LOT_BASED_JOBS
4178: WHERE wip_entity_id = p_new_wip_entity_id;
4649: -- ***** Make a copy of the Bill (primary and substitute components) for the job ***** --
4650:
4651: l_stmt_num := 50;
4652:
4653: INSERT INTO WSM_COPY_REQUIREMENT_OPS
4654: (WIP_ENTITY_ID,
4655: OPERATION_SEQ_NUM,
4656: COMPONENT_ITEM_ID,
4657: PRIMARY_COMPONENT_ID,
4824: ATTRIBUTE13,
4825: ATTRIBUTE14,
4826: ATTRIBUTE15,
4827: ORIGINAL_SYSTEM_REFERENCE
4828: FROM WSM_COPY_REQUIREMENT_OPS
4829: WHERE wip_entity_id = p_rep_wip_entity_id;
4830:
4831:
4832:
5311:
5312: DELETE WSM_COPY_OP_RESOURCE_USAGE
5313: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5314:
5315: DELETE WSM_COPY_REQUIREMENT_OPS
5316: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5317:
5318: DELETE WSM_LOT_BASED_JOBS
5319: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5756: MSI.segment20,
5757: WCRO.department_id,
5758: ROUND(WDJ.start_quantity*WCRO.quantity_per_assembly, WSMPCNST.NUMBER_OF_DECIMALS)
5759: FROM WIP_DISCRETE_JOBS WDJ,
5760: WSM_COPY_REQUIREMENT_OPS WCRO,
5761: MTL_SYSTEM_ITEMS MSI
5762: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id
5763: AND WCRO.OPERATION_SEQ_NUM = l_curr_op_seq_num
5764: AND MSI.inventory_item_id = WCRO.component_item_id