APPS.BOMPASGR dependencies on BOM_OPERATION_SEQUENCES

Line 875: bom_operation_sequences_s.nextval)

871: loop
872: update bom_op_sequences_interface
873: set transaction_id = mtl_system_items_interface_s.nextval,
874: operation_sequence_id = nvl(operation_sequence_id,
875: bom_operation_sequences_s.nextval)
876: where transaction_id is null
877: and process_flag = 1
878: and rownum < 500;
879: EXIT when SQL%NOTFOUND;

Line 1753: from bom_operation_sequences bos,

1749: dummy_org_id := 0;
1750:
1751: select bor.organization_id
1752: into dummy_org_id
1753: from bom_operation_sequences bos,
1754: bom_operational_routings bor
1755: where operation_sequence_id = c2rec.OSI
1756: and bos.routing_sequence_id = bor.routing_sequence_id;
1757: goto get_resource;

Line 1918: from bom_operation_sequences

1914: stmt_num := 13;
1915: BEGIN
1916: select department_id
1917: into dummy_dept
1918: from bom_operation_sequences
1919: where operation_sequence_id = c2rec.OSI;
1920: goto get_flag;
1921: EXCEPTION
1922: when NO_DATA_FOUND then

Line 2196: from bom_operation_sequences

2192:
2193: BEGIN
2194: select operation_sequence_id
2195: into op_seq_id
2196: from bom_operation_sequences
2197: where routing_sequence_id = rtg_seq_id
2198: and operation_seq_num = op_seq
2199: and to_char(effectivity_date,'YYYY/MM/DD HH24:MI:SS') = eff_date; -- Changed for bug 2647027
2200: -- and to_char(effectivity_date,'YYYY/MM/DD HH24:MI') = eff_date;