APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 2453: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';

2449: config routing, the operation_seq_num will be
2450: set to 1.
2451: +--------------------------------------------------------------*/
2452: lStmtNum := 130;
2453: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
2454:
2455: update bom_inventory_comps_interface ci
2456: set ci.operation_seq_num = 1
2457: where not exists

Line 2455: update bom_inventory_comps_interface ci

2451: +--------------------------------------------------------------*/
2452: lStmtNum := 130;
2453: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
2454:
2455: update bom_inventory_comps_interface ci
2456: set ci.operation_seq_num = 1
2457: where not exists
2458: (select 'op seq exists in config routing'
2459: from

Line 3043: from bom_inventory_comps_interface

3039: where organization_id = pOrgId
3040: and alternate_routing_designator is null
3041: and assembly_item_id in
3042: ( select component_item_id
3043: from bom_inventory_comps_interface
3044: where bom_item_type =2
3045: and bill_sequence_id = pCfgBillId
3046: )
3047: and serialization_start_op in