[Home] [Help]
1081:
1082: DELETE WSM_COPY_OP_RESOURCE_USAGE
1083: WHERE wip_entity_id = p_wip_entity_id;
1084:
1085: DELETE WSM_COPY_REQUIREMENT_OPS
1086: WHERE wip_entity_id = p_wip_entity_id;
1087:
1088: end if; --End of check on p_new_job before deleting the copy tables
1089:
1930: if p_phantom_exists = 2 and p_common_bill_seq_id IS NOT NULL THEN --Code review remark
1931: l_phantom_org_id := p_org_id; --Added for bug 4515000
1932: --Populate primary and substitute components. As no phantom exists
1933: --no need for calling bom exploder code.
1934: INSERT INTO WSM_COPY_REQUIREMENT_OPS
1935: (WIP_ENTITY_ID,
1936: OPERATION_SEQ_NUM,
1937: COMPONENT_ITEM_ID,
1938: PRIMARY_COMPONENT_ID,
2185: fnd_file.put_line(fnd_file.log, 'Created '||SQL%ROWCOUNT||' records in WCR) (Primary Components) for we_id='||p_wip_entity_id);
2186: END IF;
2187: --IF SQL%ROWCOUNT > 0 THEN
2188: --Insert substitute components only when there are primary components.
2189: INSERT INTO WSM_COPY_REQUIREMENT_OPS
2190: (WIP_ENTITY_ID,
2191: OPERATION_SEQ_NUM,
2192: COMPONENT_ITEM_ID,
2193: PRIMARY_COMPONENT_ID,
2366: a.attribute15,
2367: wcro.original_system_reference
2368: FROM BOM_SUBSTITUTE_COMPONENTS A,
2369: MTL_SYSTEM_ITEMS C,
2370: WSM_COPY_REQUIREMENT_OPS wcro
2371: WHERE wcro.wip_entity_id = p_wip_entity_id
2372: AND a.component_sequence_id = wcro.component_sequence_id
2373: AND a.SUBSTITUTE_COMPONENT_ID = c.inventory_item_id
2374: AND c.organization_id = p_org_id;
3094: ---COMP_ITEM_ID, PRI_COMP_ID, COMP_SEQ_ID and SRC_PHANTOM_ID---
3095:
3096:
3097: l_stmt_num := 260;
3098: INSERT INTO WSM_COPY_REQUIREMENT_OPS
3099: (WIP_ENTITY_ID,
3100: OPERATION_SEQ_NUM,
3101: COMPONENT_ITEM_ID,
3102: PRIMARY_COMPONENT_ID,
3343: BOM_OPERATION_RESOURCES BOR,
3344: BOM_DEPARTMENT_RESOURCES BDR1,
3345: BOM_OPERATION_SEQUENCES BOS,
3346: BOM_OPERATIONAL_ROUTINGS BRTG,
3347: WSM_COPY_REQUIREMENT_OPS WCRO,
3348: MTL_SYSTEM_ITEMS MSI --BUG 7598223
3349: WHERE wcro.wip_entity_id=p_wip_entity_id
3350: AND wcro.organization_id=p_org_id
3351: AND wcro.Operation_seq_num = -l_curr_op_seq_num
3939:
3940: DELETE WSM_COPY_OP_RESOURCE_USAGE
3941: WHERE wip_entity_id = p_new_wip_entity_id;
3942:
3943: DELETE WSM_COPY_REQUIREMENT_OPS
3944: WHERE wip_entity_id = p_new_wip_entity_id;
3945: */
3946: DELETE WSM_LOT_BASED_JOBS
3947: WHERE wip_entity_id = p_new_wip_entity_id;
4418: -- ***** Make a copy of the Bill (primary and substitute components) for the job ***** --
4419:
4420: l_stmt_num := 50;
4421:
4422: INSERT INTO WSM_COPY_REQUIREMENT_OPS
4423: (WIP_ENTITY_ID,
4424: OPERATION_SEQ_NUM,
4425: COMPONENT_ITEM_ID,
4426: PRIMARY_COMPONENT_ID,
4593: ATTRIBUTE13,
4594: ATTRIBUTE14,
4595: ATTRIBUTE15,
4596: ORIGINAL_SYSTEM_REFERENCE
4597: FROM WSM_COPY_REQUIREMENT_OPS
4598: WHERE wip_entity_id = p_rep_wip_entity_id;
4599:
4600:
4601:
5080:
5081: DELETE WSM_COPY_OP_RESOURCE_USAGE
5082: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5083:
5084: DELETE WSM_COPY_REQUIREMENT_OPS
5085: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5086:
5087: DELETE WSM_LOT_BASED_JOBS
5088: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5525: MSI.segment20,
5526: WCRO.department_id,
5527: ROUND(WDJ.start_quantity*WCRO.quantity_per_assembly, WSMPCNST.NUMBER_OF_DECIMALS)
5528: FROM WIP_DISCRETE_JOBS WDJ,
5529: WSM_COPY_REQUIREMENT_OPS WCRO,
5530: MTL_SYSTEM_ITEMS MSI
5531: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id
5532: AND WCRO.OPERATION_SEQ_NUM = l_curr_op_seq_num
5533: AND MSI.inventory_item_id = WCRO.component_item_id