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 2995: SELECT * from bom_component_operations

2991: IS
2992:
2993: Cursor get_comp_ops(p_component_sequence_id NUMBER)
2994: is
2995: SELECT * from bom_component_operations
2996: where component_sequence_id = p_component_sequence_id;
2997:
2998: Cursor get_destn_comps(p_comp_seq_id number)
2999: is

Line 3017: FROM BOM_COMPONENT_OPERATIONS

3013:
3014: BEGIN
3015: SELECT 'Y'
3016: INTO l_comp_op_exists
3017: FROM BOM_COMPONENT_OPERATIONS
3018: WHERE component_sequence_id = p_component_sequence_id;
3019: EXCEPTION
3020: WHEN NO_DATA_FOUND THEN
3021: --No comp ops to replicate, return

Line 3037: FROM bom_component_operations bco, BOM_COMPONENTS_B bic

3033: loop
3034: BEGIN
3035: SELECT bco.operation_seq_num
3036: INTO l_dummy
3037: FROM bom_component_operations bco, BOM_COMPONENTS_B bic
3038: WHERE bco.component_sequence_id = bic.component_sequence_id
3039: AND bic.component_sequence_id = p_component_sequence_id
3040: AND EXISTS(
3041: SELECT operation_seq_num, bos.routing_sequence_id

Line 3068: INSERT INTO bom_component_operations

3064: NULL;
3065: END;
3066: END LOOP;
3067:
3068: INSERT INTO bom_component_operations
3069: (
3070: COMP_OPERATION_SEQ_ID ,
3071: OPERATION_SEQ_NUM ,
3072: OPERATION_SEQUENCE_ID ,

Line 3098: bom_component_operations_s.NEXTVAL ,

3094: ATTRIBUTE14 ,
3095: ATTRIBUTE15 ,
3096: COMMON_COMPONENT_SEQUENCE_ID)
3097: SELECT
3098: bom_component_operations_s.NEXTVAL ,
3099: comp_ops.OPERATION_SEQ_NUM ,
3100: comp_ops.OPERATION_SEQUENCE_ID ,
3101: comp_ops.LAST_UPDATE_DATE ,
3102: comp_ops.LAST_UPDATED_BY ,

Line 3125: FROM BOM_COMPONENT_OPERATIONS comp_ops, BOM_COMPONENTS_B dest_comp

3121: comp_ops.ATTRIBUTE13 ,
3122: comp_ops.ATTRIBUTE14 ,
3123: comp_ops.ATTRIBUTE15 ,
3124: comp_ops.COMPONENT_SEQUENCE_ID
3125: FROM BOM_COMPONENT_OPERATIONS comp_ops, BOM_COMPONENTS_B dest_comp
3126: WHERE dest_comp.component_Sequence_id <> dest_comp.common_component_sequence_id
3127: AND dest_comp.common_component_sequence_id = comp_ops.component_sequence_id
3128: AND comp_ops.component_sequence_id = p_component_sequence_id
3129: AND NOT EXISTS

Line 3132: FROM BOM_COMPONENT_OPERATIONS ops2

3128: AND comp_ops.component_sequence_id = p_component_sequence_id
3129: AND NOT EXISTS
3130: (
3131: SELECT 1
3132: FROM BOM_COMPONENT_OPERATIONS ops2
3133: where ops2.component_sequence_id = dest_comp.component_sequence_id
3134: )
3135: ;
3136:

Line 3201: from bom_component_operations

3197: Cursor get_comp_op_details(p_comp_seq_id NUMBER,
3198: p_operation_seq_num NUMBER)
3199: IS
3200: select *
3201: from bom_component_operations
3202: where component_sequence_id = p_comp_seq_id
3203: and operation_seq_num= p_operation_seq_num;
3204:
3205: Cursor get_destn_comps(p_comp_seq_id number)

Line 3217: INSERT INTO bom_component_operations

3213: for comp_ops in get_comp_op_details(p_component_sequence_id, p_operation_seq_num)
3214: loop
3215: for dest_comp in get_destn_comps(p_component_sequence_id)
3216: loop
3217: INSERT INTO bom_component_operations
3218: (
3219: COMP_OPERATION_SEQ_ID ,
3220: OPERATION_SEQ_NUM ,
3221: OPERATION_SEQUENCE_ID ,

Line 3247: bom_component_operations_s.NEXTVAL ,

3243: ATTRIBUTE14 ,
3244: ATTRIBUTE15 ,
3245: COMMON_COMPONENT_SEQUENCE_ID)
3246: VALUES(
3247: bom_component_operations_s.NEXTVAL ,
3248: comp_ops.OPERATION_SEQ_NUM ,
3249: comp_ops.OPERATION_SEQUENCE_ID ,
3250: comp_ops.LAST_UPDATE_DATE ,
3251: comp_ops.LAST_UPDATED_BY ,

Line 3346: from bom_component_operations

3342: Cursor get_comp_op_details(p_comp_seq_id NUMBER,
3343: p_new_operation_seq_num NUMBER)
3344: IS
3345: select *
3346: from bom_component_operations
3347: where component_sequence_id = p_comp_seq_id
3348: and operation_seq_num = p_new_operation_seq_num;
3349:
3350: Cursor get_destn_comps(p_comp_seq_id number)

Line 3362: UPDATE bom_component_operations SET

3358: for comp_ops in get_comp_op_details(p_component_sequence_id, p_new_operation_seq_num)
3359: loop
3360: /*for dest_comp in get_destn_comps(p_component_sequence_id)
3361: loop*/
3362: UPDATE bom_component_operations SET
3363: OPERATION_SEQ_NUM = comp_ops.OPERATION_SEQ_NUM ,
3364: OPERATION_SEQUENCE_ID = comp_ops.OPERATION_SEQUENCE_ID,
3365: LAST_UPDATE_DATE = comp_ops.LAST_UPDATE_DATE ,
3366: LAST_UPDATED_BY = comp_ops.LAST_UPDATED_BY ,

Line 3453: DELETE FROM BOM_COMPONENT_OPERATIONS

3449: p_operation_seq_num IN NUMBER,
3450: x_return_status IN OUT NOCOPY VARCHAR2)
3451: IS
3452: BEGIN
3453: DELETE FROM BOM_COMPONENT_OPERATIONS
3454: WHERE COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq_id
3455: AND OPERATION_SEQ_NUM = p_operation_seq_num;
3456: x_return_status := FND_API.G_RET_STS_SUCCESS;
3457: EXCEPTION

Line 4138: DELETE BOM_COMPONENT_OPERATIONS

4134:
4135: DELETE BOM_REFERENCE_DESIGNATORS
4136: WHERE common_component_sequence_id = p_src_comp_seq_id;
4137:
4138: DELETE BOM_COMPONENT_OPERATIONS
4139: WHERE common_component_sequence_id = p_src_comp_seq_id;
4140:
4141: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
4142: