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.ENGPKIMP dependencies on BOM_OPERATION_SEQUENCES

Line 826: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st

822: END IF;
823:
824: -- Check whether there are any operations changes created for the item with this change order ..
825: SELECT count(st.structure_type_id) INTO l_pending_changes_count
826: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st
827: WHERE op.revised_item_sequence_id = p_change_line_id
828: AND op.revised_item_sequence_id = ri.revised_item_sequence_id
829: AND op.implementation_date IS NULL
830: AND st.structure_type_id = ( SELECT bbom.structure_type_id

Line 2099: FROM bom_operation_sequences

2095: );
2096:
2097: CURSOR check_chng_rounting_existing( revised_item NUMBER) IS
2098: SELECT 'X'
2099: FROM bom_operation_sequences
2100: WHERE revised_item_sequence_id = revised_item;
2101:
2102:
2103: CURSOR chng_operation_rows IS

Line 2113: FROM bom_operation_sequences

2109: , acd_type
2110: , revised_item_sequence_id
2111: , disable_date
2112: , effectivity_date
2113: FROM bom_operation_sequences
2114: WHERE revised_item_sequence_id = revised_item
2115: AND change_notice = item.change_notice
2116: FOR UPDATE OF change_notice
2117: , implementation_date

Line 2137: FROM bom_operation_sequences

2133:
2134:
2135: CURSOR check_op_seq_num_exists IS
2136: SELECT 'X'
2137: FROM bom_operation_sequences
2138: WHERE operation_sequence_id = chng_operation_rec.old_operation_sequence_id
2139: AND operation_seq_num = chng_operation_rec.operation_seq_num;
2140:
2141: CURSOR unimplemented_rtg_rev

Line 2293: from bom_operation_sequences o

2289: o.implementation_date,
2290: o.disable_date,
2291: o.effectivity_date,
2292: o.operation_sequence_id
2293: from bom_operation_sequences o
2294: where o.operation_sequence_id = old_id
2295: for update of o.change_notice,
2296: o.disable_date,
2297: o.last_update_date,

Line 2319: from bom_operation_sequences b

2315:
2316: CURSOR check_overlapping_operation ( routing_seq_id NUMBER,
2317: operation_num NUMBER, operation_seq_id NUMBER, eff_date DATE) IS
2318: Select 'x' -- overlapping effectivity
2319: from bom_operation_sequences b
2320: where b.routing_sequence_id= routing_seq_id
2321: -- and b.operation_sequence_id = operation_seq_id
2322: and b.operation_seq_num = operation_num
2323: and b.implementation_date is not null

Line 2328: from bom_operation_sequences b

2324: and b.effectivity_date <= eff_date
2325: and nvl(b.disable_date, eff_date + 1) > eff_date
2326: union
2327: select 'x' -- duplicate value on unique index
2328: from bom_operation_sequences b
2329: where b.routing_sequence_id= routing_seq_id
2330: and b.operation_seq_num = operation_num
2331: and b.effectivity_date = eff_date
2332: and b.operation_sequence_id <> operation_seq_id;

Line 3410: select 1 FROM bom_operation_sequences WHERE routing_sequence_id IN

3406:
3407: --Check if there are any operations for this item ..
3408: --Again, we allow empty routings to get implemented for the same reason for which we allowe empty BOMs
3409: SELECT Count(*) INTO l_no_operations FROM dual WHERE EXISTS(
3410: select 1 FROM bom_operation_sequences WHERE routing_sequence_id IN
3411: (
3412: SELECT routing_sequence_id FROM BOM_OPERATIONAL_ROUTINGS WHERE
3413: ASSEMBLY_ITEM_ID = item.revised_item_id and
3414: ORGANIZATION_ID = item.organization_id

Line 5376: UPDATE bom_operation_sequences

5372: chng_operation_rec.disable_date := eff_date;
5373: end if;
5374:
5375: -- Disalbe the old operation record
5376: UPDATE bom_operation_sequences
5377: SET
5378: change_notice = old_op_rec.change_notice,
5379: implementation_date = today,
5380: disable_date = old_op_rec.disable_date,

Line 5654: X_from_entity_name => 'BOM_OPERATION_SEQUENCES'

5650:
5651: -- Copy attachment of the Operation Sequences
5652: -- Added for Bug 3701023
5653: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
5654: X_from_entity_name => 'BOM_OPERATION_SEQUENCES'
5655: , X_from_pk1_value => to_char(chng_operation_rec.old_operation_sequence_id)
5656: , X_from_pk2_value => null
5657: , X_from_pk3_value => null
5658: , X_from_pk4_value => null

Line 5660: , X_to_entity_name => 'BOM_OPERATION_SEQUENCES'

5656: , X_from_pk2_value => null
5657: , X_from_pk3_value => null
5658: , X_from_pk4_value => null
5659: , X_from_pk5_value => null
5660: , X_to_entity_name => 'BOM_OPERATION_SEQUENCES'
5661: , X_to_pk1_value => to_char(chng_operation_rec.operation_sequence_id)
5662: , X_to_pk2_value => null
5663: , X_to_pk3_value => null
5664: , X_to_pk4_value => null

Line 5826: UPDATE bom_operation_sequences

5822:
5823: END IF; -- end of IF chng_operation_rec.acd_type = acd_change
5824:
5825: -- Implement the current operation row.
5826: UPDATE bom_operation_sequences
5827: SET
5828: change_notice = item.change_notice,
5829: implementation_date = today,
5830: disable_date = chng_operation_rec.disable_date,

Line 5851: Update bom_operation_sequences

5847:
5848: If chng_operation_rec.acd_type = acd_change then
5849: --fix for bug 1607851
5850: IF item.eco_for_production = 2 THEN
5851: Update bom_operation_sequences
5852: set old_operation_sequence_id = chng_operation_rec.operation_sequence_id,
5853: last_update_date = sysdate,
5854: last_updated_by = userid,
5855: last_update_login = loginid,

Line 5997: FROM bom_operation_sequences b

5993: acd_type ,
5994: revised_item_sequence_id ,
5995: original_system_reference,
5996: eco_for_production
5997: FROM bom_operation_sequences b
5998: WHERE operation_sequence_id
5999: = chng_operation_rec.operation_sequence_id;
6000:
6001: IF chng_operation_rec.acd_type = acd_delete then

Line 6002: Delete from bom_operation_sequences

5998: WHERE operation_sequence_id
5999: = chng_operation_rec.operation_sequence_id;
6000:
6001: IF chng_operation_rec.acd_type = acd_delete then
6002: Delete from bom_operation_sequences
6003: where operation_sequence_id = chng_operation_rec.operation_sequence_id;
6004: END IF;
6005:
6006: -- ERES changes begin : bug 3908563

Line 9036: FROM bom_operation_sequences

9032: -- whose eco_for_production = 1.
9033: /* DELETE FROM bom_sub_operation_resources
9034: WHERE operation_sequence_id IN
9035: ( SELECT operation_sequence_id
9036: FROM bom_operation_sequences
9037: WHERE revised_item_sequence_id = p_revised_item_sequence_id
9038: );
9039: */
9040: -- Delete all the resources assigned to the operations whose

Line 9046: FROM bom_operation_sequences

9042: /*
9043: DELETE FROM bom_operation_resources
9044: WHERE operation_sequence_id IN
9045: ( SELECT operation_sequence_id
9046: FROM bom_operation_sequences
9047: WHERE revised_item_sequence_id = p_revised_item_sequence_id
9048: );
9049: */
9050: -- before delete the related operation sequence records,

Line 9055: UPDATE bom_operation_sequences

9051: -- make the old operation active again
9052:
9053: FOR i in 1..rev_op_disable_date_tbl.count
9054: LOOP
9055: UPDATE bom_operation_sequences
9056: SET
9057: disable_date = rev_op_disable_date_tbl(i).disable_date,
9058: last_update_date = sysdate,
9059: last_updated_by = userid,

Line 9069: DELETE FROM bom_operation_sequences

9065: WHERE operation_sequence_id = rev_op_disable_date_tbl(i).operation_seq_id;
9066: END LOOP;
9067:
9068: -- Delete the related operation sequence records
9069: DELETE FROM bom_operation_sequences
9070: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
9071:
9072: -- Delete the related revised operation sequence records
9073: /* DELETE FROM eng_revised_operations