DBA Data[Home] [Help]

APPS.BOM_COMPONENT_API dependencies on BOM_OPERATION_SEQUENCES

Line 1755: FROM bom_operation_sequences a, bom_operational_routings b

1751: stmt_num := 2;
1752: IF (op_seq <> 1) THEN
1753: SELECT distinct operation_seq_num
1754: INTO dummy
1755: FROM bom_operation_sequences a, bom_operational_routings b
1756: WHERE b.organization_id = org_id
1757: AND b.assembly_item_id = assy_id
1758: AND operation_seq_num = op_seq
1759: -- AND a.effectivity_date < sysdate

Line 2651: FROM bom_operation_sequences bos

2647: if(ret_code = 0 and c3rec.BITA <> G_ProductFamily) then -- This code is for bug 1804509
2648: update bom_inventory_comps_interface
2649: set operation_lead_time_percent =
2650: (select operation_lead_time_percent
2651: FROM bom_operation_sequences bos
2652: WHERE c3rec.OSN = bos.operation_seq_num
2653: AND bos.ROUTING_SEQUENCE_ID =
2654: (select COMMON_ROUTING_SEQUENCE_ID
2655: from BOM_OPERATIONAL_ROUTINGS bor

Line 3799: FROM bom_operation_sequences bos

3795: if (ret_code=0) then
3796: update bom_inventory_comps_interface
3797: set operation_lead_time_percent =
3798: (select operation_lead_time_percent
3799: FROM bom_operation_sequences bos
3800: WHERE c1rec.OSN = bos.operation_seq_num
3801: AND bos.ROUTING_SEQUENCE_ID =
3802: (select COMMON_ROUTING_SEQUENCE_ID
3803: from BOM_OPERATIONAL_ROUTINGS bor