DBA Data[Home] [Help]

APPS.CTO_CONFIG_ROUTING_PK dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 2462: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';

2458: config routing, the operation_seq_num will be
2459: set to 1.
2460: +--------------------------------------------------------------*/
2461: lStmtNum := 130;
2462: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
2463:
2464: update bom_inventory_comps_interface ci
2465: set ci.operation_seq_num = 1
2466: where not exists

Line 2464: update bom_inventory_comps_interface ci

2460: +--------------------------------------------------------------*/
2461: lStmtNum := 130;
2462: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
2463:
2464: update bom_inventory_comps_interface ci
2465: set ci.operation_seq_num = 1
2466: where not exists
2467: (select 'op seq exists in config routing'
2468: from

Line 3023: from bom_inventory_comps_interface

3019: where organization_id = pOrgId
3020: and alternate_routing_designator is null
3021: and assembly_item_id in
3022: ( select component_item_id
3023: from bom_inventory_comps_interface
3024: where bom_item_type =2
3025: and bill_sequence_id = pCfgBillId
3026: )
3027: and serialization_start_op in