eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMPCMBM dependencies on BOM_COMPONENT_OPERATIONS

Line 3287: SELECT * from bom_component_operations

3283: IS
3284:
3285: Cursor get_comp_ops(p_component_sequence_id NUMBER)
3286: is
3287: SELECT * from bom_component_operations
3288: where component_sequence_id = p_component_sequence_id;
3289:
3290: Cursor get_destn_comps(p_comp_seq_id number)
3291: is

Line 3309: FROM BOM_COMPONENT_OPERATIONS

3305:
3306: BEGIN
3307: SELECT 'Y'
3308: INTO l_comp_op_exists
3309: FROM BOM_COMPONENT_OPERATIONS
3310: WHERE component_sequence_id = p_component_sequence_id;
3311: EXCEPTION
3312: WHEN NO_DATA_FOUND THEN
3313: --No comp ops to replicate, return

Line 3329: FROM bom_component_operations bco, BOM_COMPONENTS_B bic

3325: loop
3326: BEGIN
3327: SELECT bco.operation_seq_num
3328: INTO l_dummy
3329: FROM bom_component_operations bco, BOM_COMPONENTS_B bic
3330: WHERE bco.component_sequence_id = bic.component_sequence_id
3331: AND bic.component_sequence_id = p_component_sequence_id
3332: AND EXISTS(
3333: SELECT operation_seq_num, bos.routing_sequence_id

Line 3360: INSERT INTO bom_component_operations

3356: NULL;
3357: END;
3358: END LOOP;
3359:
3360: INSERT INTO bom_component_operations
3361: (
3362: COMP_OPERATION_SEQ_ID ,
3363: OPERATION_SEQ_NUM ,
3364: OPERATION_SEQUENCE_ID ,

Line 3390: bom_component_operations_s.NEXTVAL ,

3386: ATTRIBUTE14 ,
3387: ATTRIBUTE15 ,
3388: COMMON_COMPONENT_SEQUENCE_ID)
3389: SELECT
3390: bom_component_operations_s.NEXTVAL ,
3391: comp_ops.OPERATION_SEQ_NUM ,
3392: comp_ops.OPERATION_SEQUENCE_ID ,
3393: comp_ops.LAST_UPDATE_DATE ,
3394: comp_ops.LAST_UPDATED_BY ,

Line 3417: FROM BOM_COMPONENT_OPERATIONS comp_ops, BOM_COMPONENTS_B dest_comp

3413: comp_ops.ATTRIBUTE13 ,
3414: comp_ops.ATTRIBUTE14 ,
3415: comp_ops.ATTRIBUTE15 ,
3416: comp_ops.COMPONENT_SEQUENCE_ID
3417: FROM BOM_COMPONENT_OPERATIONS comp_ops, BOM_COMPONENTS_B dest_comp
3418: WHERE dest_comp.component_Sequence_id <> dest_comp.common_component_sequence_id
3419: AND dest_comp.common_component_sequence_id = comp_ops.component_sequence_id
3420: AND comp_ops.component_sequence_id = p_component_sequence_id
3421: AND NOT EXISTS

Line 3424: FROM BOM_COMPONENT_OPERATIONS ops2

3420: AND comp_ops.component_sequence_id = p_component_sequence_id
3421: AND NOT EXISTS
3422: (
3423: SELECT 1
3424: FROM BOM_COMPONENT_OPERATIONS ops2
3425: where ops2.component_sequence_id = dest_comp.component_sequence_id
3426: )
3427: ;
3428:

Line 3493: from bom_component_operations

3489: Cursor get_comp_op_details(p_comp_seq_id NUMBER,
3490: p_operation_seq_num NUMBER)
3491: IS
3492: select *
3493: from bom_component_operations
3494: where component_sequence_id = p_comp_seq_id
3495: and operation_seq_num= p_operation_seq_num;
3496:
3497: Cursor get_destn_comps(p_comp_seq_id number)

Line 3509: INSERT INTO bom_component_operations

3505: for comp_ops in get_comp_op_details(p_component_sequence_id, p_operation_seq_num)
3506: loop
3507: for dest_comp in get_destn_comps(p_component_sequence_id)
3508: loop
3509: INSERT INTO bom_component_operations
3510: (
3511: COMP_OPERATION_SEQ_ID ,
3512: OPERATION_SEQ_NUM ,
3513: OPERATION_SEQUENCE_ID ,

Line 3539: bom_component_operations_s.NEXTVAL ,

3535: ATTRIBUTE14 ,
3536: ATTRIBUTE15 ,
3537: COMMON_COMPONENT_SEQUENCE_ID)
3538: VALUES(
3539: bom_component_operations_s.NEXTVAL ,
3540: comp_ops.OPERATION_SEQ_NUM ,
3541: comp_ops.OPERATION_SEQUENCE_ID ,
3542: comp_ops.LAST_UPDATE_DATE ,
3543: comp_ops.LAST_UPDATED_BY ,

Line 3638: from bom_component_operations

3634: Cursor get_comp_op_details(p_comp_seq_id NUMBER,
3635: p_new_operation_seq_num NUMBER)
3636: IS
3637: select *
3638: from bom_component_operations
3639: where component_sequence_id = p_comp_seq_id
3640: and operation_seq_num = p_new_operation_seq_num;
3641:
3642: Cursor get_destn_comps(p_comp_seq_id number)

Line 3654: UPDATE bom_component_operations SET

3650: for comp_ops in get_comp_op_details(p_component_sequence_id, p_new_operation_seq_num)
3651: loop
3652: /*for dest_comp in get_destn_comps(p_component_sequence_id)
3653: loop*/
3654: UPDATE bom_component_operations SET
3655: OPERATION_SEQ_NUM = comp_ops.OPERATION_SEQ_NUM ,
3656: OPERATION_SEQUENCE_ID = comp_ops.OPERATION_SEQUENCE_ID,
3657: LAST_UPDATE_DATE = comp_ops.LAST_UPDATE_DATE ,
3658: LAST_UPDATED_BY = comp_ops.LAST_UPDATED_BY ,

Line 3745: DELETE FROM BOM_COMPONENT_OPERATIONS

3741: p_operation_seq_num IN NUMBER,
3742: x_return_status IN OUT NOCOPY VARCHAR2)
3743: IS
3744: BEGIN
3745: DELETE FROM BOM_COMPONENT_OPERATIONS
3746: WHERE COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq_id
3747: AND OPERATION_SEQ_NUM = p_operation_seq_num;
3748: x_return_status := FND_API.G_RET_STS_SUCCESS;
3749: EXCEPTION

Line 4486: DELETE BOM_COMPONENT_OPERATIONS

4482:
4483: DELETE BOM_REFERENCE_DESIGNATORS
4484: WHERE common_component_sequence_id = p_src_comp_seq_id;
4485:
4486: DELETE BOM_COMPONENT_OPERATIONS
4487: WHERE common_component_sequence_id = p_src_comp_seq_id;
4488:
4489: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
4490: