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 754: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st

750: END IF;
751:
752: -- Check whether there are any operations changes created for the item with this change order ..
753: SELECT count(st.structure_type_id) INTO l_pending_changes_count
754: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st
755: WHERE op.revised_item_sequence_id = p_change_line_id
756: AND op.revised_item_sequence_id = ri.revised_item_sequence_id
757: AND op.implementation_date IS NULL
758: AND st.structure_type_id = ( SELECT bbom.structure_type_id

Line 2003: FROM bom_operation_sequences

1999: );
2000:
2001: CURSOR check_chng_rounting_existing( revised_item NUMBER) IS
2002: SELECT 'X'
2003: FROM bom_operation_sequences
2004: WHERE revised_item_sequence_id = revised_item;
2005:
2006:
2007: CURSOR chng_operation_rows IS

Line 2017: FROM bom_operation_sequences

2013: , acd_type
2014: , revised_item_sequence_id
2015: , disable_date
2016: , effectivity_date
2017: FROM bom_operation_sequences
2018: WHERE revised_item_sequence_id = revised_item
2019: AND change_notice = item.change_notice
2020: FOR UPDATE OF change_notice
2021: , implementation_date

Line 2041: FROM bom_operation_sequences

2037:
2038:
2039: CURSOR check_op_seq_num_exists IS
2040: SELECT 'X'
2041: FROM bom_operation_sequences
2042: WHERE operation_sequence_id = chng_operation_rec.old_operation_sequence_id
2043: AND operation_seq_num = chng_operation_rec.operation_seq_num;
2044:
2045: CURSOR unimplemented_rtg_rev

Line 2197: from bom_operation_sequences o

2193: o.implementation_date,
2194: o.disable_date,
2195: o.effectivity_date,
2196: o.operation_sequence_id
2197: from bom_operation_sequences o
2198: where o.operation_sequence_id = old_id
2199: for update of o.change_notice,
2200: o.disable_date,
2201: o.last_update_date,

Line 2223: from bom_operation_sequences b

2219:
2220: CURSOR check_overlapping_operation ( routing_seq_id NUMBER,
2221: operation_num NUMBER, operation_seq_id NUMBER, eff_date DATE) IS
2222: Select 'x' -- overlapping effectivity
2223: from bom_operation_sequences b
2224: where b.routing_sequence_id= routing_seq_id
2225: -- and b.operation_sequence_id = operation_seq_id
2226: and b.operation_seq_num = operation_num
2227: and b.implementation_date is not null

Line 2232: from bom_operation_sequences b

2228: and b.effectivity_date <= eff_date
2229: and nvl(b.disable_date, eff_date + 1) > eff_date
2230: union
2231: select 'x' -- duplicate value on unique index
2232: from bom_operation_sequences b
2233: where b.routing_sequence_id= routing_seq_id
2234: and b.operation_seq_num = operation_num
2235: and b.effectivity_date = eff_date
2236: and b.operation_sequence_id <> operation_seq_id;

Line 3186: select 1 FROM bom_operation_sequences WHERE routing_sequence_id IN

3182:
3183: --Check if there are any operations for this item ..
3184: --Again, we allow empty routings to get implemented for the same reason for which we allowe empty BOMs
3185: SELECT Count(*) INTO l_no_operations FROM dual WHERE EXISTS(
3186: select 1 FROM bom_operation_sequences WHERE routing_sequence_id IN
3187: (
3188: SELECT routing_sequence_id FROM BOM_OPERATIONAL_ROUTINGS WHERE
3189: ASSEMBLY_ITEM_ID = item.revised_item_id and
3190: ORGANIZATION_ID = item.organization_id

Line 5112: UPDATE bom_operation_sequences

5108: chng_operation_rec.disable_date := eff_date;
5109: end if;
5110:
5111: -- Disalbe the old operation record
5112: UPDATE bom_operation_sequences
5113: SET
5114: change_notice = old_op_rec.change_notice,
5115: implementation_date = today,
5116: disable_date = old_op_rec.disable_date,

Line 5390: X_from_entity_name => 'BOM_OPERATION_SEQUENCES'

5386:
5387: -- Copy attachment of the Operation Sequences
5388: -- Added for Bug 3701023
5389: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
5390: X_from_entity_name => 'BOM_OPERATION_SEQUENCES'
5391: , X_from_pk1_value => to_char(chng_operation_rec.old_operation_sequence_id)
5392: , X_from_pk2_value => null
5393: , X_from_pk3_value => null
5394: , X_from_pk4_value => null

Line 5396: , X_to_entity_name => 'BOM_OPERATION_SEQUENCES'

5392: , X_from_pk2_value => null
5393: , X_from_pk3_value => null
5394: , X_from_pk4_value => null
5395: , X_from_pk5_value => null
5396: , X_to_entity_name => 'BOM_OPERATION_SEQUENCES'
5397: , X_to_pk1_value => to_char(chng_operation_rec.operation_sequence_id)
5398: , X_to_pk2_value => null
5399: , X_to_pk3_value => null
5400: , X_to_pk4_value => null

Line 5562: UPDATE bom_operation_sequences

5558:
5559: END IF; -- end of IF chng_operation_rec.acd_type = acd_change
5560:
5561: -- Implement the current operation row.
5562: UPDATE bom_operation_sequences
5563: SET
5564: change_notice = item.change_notice,
5565: implementation_date = today,
5566: disable_date = chng_operation_rec.disable_date,

Line 5587: Update bom_operation_sequences

5583:
5584: If chng_operation_rec.acd_type = acd_change then
5585: --fix for bug 1607851
5586: IF item.eco_for_production = 2 THEN
5587: Update bom_operation_sequences
5588: set old_operation_sequence_id = chng_operation_rec.operation_sequence_id,
5589: last_update_date = sysdate,
5590: last_updated_by = userid,
5591: last_update_login = loginid,

Line 5733: FROM bom_operation_sequences b

5729: acd_type ,
5730: revised_item_sequence_id ,
5731: original_system_reference,
5732: eco_for_production
5733: FROM bom_operation_sequences b
5734: WHERE operation_sequence_id
5735: = chng_operation_rec.operation_sequence_id;
5736:
5737: IF chng_operation_rec.acd_type = acd_delete then

Line 5738: Delete from bom_operation_sequences

5734: WHERE operation_sequence_id
5735: = chng_operation_rec.operation_sequence_id;
5736:
5737: IF chng_operation_rec.acd_type = acd_delete then
5738: Delete from bom_operation_sequences
5739: where operation_sequence_id = chng_operation_rec.operation_sequence_id;
5740: END IF;
5741:
5742: -- ERES changes begin : bug 3908563

Line 8691: FROM bom_operation_sequences

8687: -- whose eco_for_production = 1.
8688: /* DELETE FROM bom_sub_operation_resources
8689: WHERE operation_sequence_id IN
8690: ( SELECT operation_sequence_id
8691: FROM bom_operation_sequences
8692: WHERE revised_item_sequence_id = p_revised_item_sequence_id
8693: );
8694: */
8695: -- Delete all the resources assigned to the operations whose

Line 8701: FROM bom_operation_sequences

8697: /*
8698: DELETE FROM bom_operation_resources
8699: WHERE operation_sequence_id IN
8700: ( SELECT operation_sequence_id
8701: FROM bom_operation_sequences
8702: WHERE revised_item_sequence_id = p_revised_item_sequence_id
8703: );
8704: */
8705: -- before delete the related operation sequence records,

Line 8710: UPDATE bom_operation_sequences

8706: -- make the old operation active again
8707:
8708: FOR i in 1..rev_op_disable_date_tbl.count
8709: LOOP
8710: UPDATE bom_operation_sequences
8711: SET
8712: disable_date = rev_op_disable_date_tbl(i).disable_date,
8713: last_update_date = sysdate,
8714: last_updated_by = userid,

Line 8724: DELETE FROM bom_operation_sequences

8720: WHERE operation_sequence_id = rev_op_disable_date_tbl(i).operation_seq_id;
8721: END LOOP;
8722:
8723: -- Delete the related operation sequence records
8724: DELETE FROM bom_operation_sequences
8725: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
8726:
8727: -- Delete the related revised operation sequence records
8728: /* DELETE FROM eng_revised_operations