APPS.BOMCUMYD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

Update_Events		IN	NUMBER		DEFAULT 1,
Item_Low		IN	VARCHAR2,
Item_High		IN	VARCHAR2
) IS
	Item_Name		VARCHAR2(40) ;

Line: 26

SELECT 	inventory_item_id,concatenated_segments
FROM 	mtl_system_items_b_kfv
WHERE 	concatenated_segments BETWEEN item_low and item_high
AND     organization_id = current_org_id;

Line: 32

SELECT 	inventory_item_id,concatenated_segments
FROM 	mtl_system_items_b_kfv
WHERE 	concatenated_segments >= item_low
AND     organization_id = current_org_id;

Line: 38

SELECT 	inventory_item_id,concatenated_segments
FROM 	mtl_system_items_b_kfv
WHERE 	concatenated_segments <= item_high
AND     organization_id = current_org_id;

Line: 44

SELECT 	routing_sequence_id,alternate_routing_designator
FROM   	bom_operational_routings
WHERE  	assembly_item_id = Item_Id
AND    	cfm_routing_flag = 3
AND     organization_id = current_org_id;

Line: 59

	FND_FILE.PUT_LINE( FND_FILE.LOG,'UPDATE_EVENTS='||to_char(update_events));

Line: 135

		SELECT concatenated_segments
		INTO   Item_Name
		FROM   mtl_system_items_b_kfv
		WHERE  inventory_item_id = Item_Id
		AND    organization_id   = Current_Org_Id;

Line: 186

        SELECT TOTAL_PRODUCT_CYCLE_TIME into l_tpct FROM
        BOM_OPERATIONAL_ROUTINGS bor
        WHERE bor.ROUTING_SEQUENCE_ID = rtg_seq_id
        AND bor.ORGANIZATION_ID = org_id
        AND bor.ASSEMBLY_ITEM_ID = item_id;

Line: 198

		UPDATE MTL_SYSTEM_ITEMS
		SET FULL_LEAD_TIME = l_tpct/24,
		    FIXED_LEAD_TIME = l_tpct/24,
		    PROGRAM_UPDATE_DATE = SYSDATE
		WHERE INVENTORY_ITEM_ID = item_id
		AND ORGANIZATION_ID = org_id;

Line: 207

	       Select (STOP_TIME - START_TIME) into l_line_Seconds
               from wip_lines where line_id = Flow_Line_Id
	       and ORGANIZATION_ID = org_id;

Line: 213

	       /**Update using Line hours**/
		UPDATE MTL_SYSTEM_ITEMS
		SET FULL_LEAD_TIME = l_tpct/l_line_hours,
		    FIXED_LEAD_TIME = l_tpct/l_line_hours,
		    PROGRAM_UPDATE_DATE = SYSDATE
		WHERE INVENTORY_ITEM_ID = item_id
		AND ORGANIZATION_ID = org_id;

Line: 221

	        UPDATE MTL_SYSTEM_ITEMS
		SET FULL_LEAD_TIME = l_tpct/24,
		    FIXED_LEAD_TIME = l_tpct/24,
		    PROGRAM_UPDATE_DATE = SYSDATE
		WHERE INVENTORY_ITEM_ID = item_id
		AND ORGANIZATION_ID = org_id;

Line: 238

SELECT null from bom_operation_sequences
WHERE routing_sequence_id = rtg_seq_id
and process_op_seq_id is not null;

Line: 243

SELECT null from bom_operation_sequences
WHERE routing_sequence_id = rtg_seq_id
and line_op_seq_id is not null;

Line: 331

SELECT 	inventory_item_id,concatenated_segments
FROM 	mtl_system_items_b_kfv
WHERE 	concatenated_segments BETWEEN item_low and item_high
AND     organization_id = current_org_id;

Line: 337

SELECT 	inventory_item_id,concatenated_segments
FROM 	mtl_system_items_b_kfv
WHERE 	concatenated_segments >= item_low
AND     organization_id = current_org_id;

Line: 343

SELECT 	inventory_item_id,concatenated_segments
FROM 	mtl_system_items_b_kfv
WHERE 	concatenated_segments <= item_high
AND     organization_id = current_org_id;

Line: 349

SELECT routing_sequence_id, alternate_routing_designator,
       assembly_item_id
FROM BOM_OPERATIONAL_ROUTINGS	bor
WHERE bor.ORGANIZATION_ID = current_org_id
AND bor.CFM_ROUTING_FLAG = 1
AND bor.LINE_ID = v_line;

Line: 357

SELECT DISTINCT bor.routing_sequence_id, bor.alternate_routing_designator,
       bor.assembly_item_id
FROM BOM_OPERATIONAL_ROUTINGS	bor,
BOM_OPERATION_SEQUENCES bos,
BOM_STANDARD_OPERATIONS bso
WHERE bor.ORGANIZATION_ID = current_org_id
AND bor.CFM_ROUTING_FLAG = 1
AND bor.LINE_ID = v_line
AND bso.OPERATION_CODE = v_operation_code
AND bos.STANDARD_OPERATION_ID = bso.STANDARD_OPERATION_ID
AND bor.ROUTING_SEQUENCE_ID = bos.ROUTING_SEQUENCE_ID
AND bos.OPERATION_TYPE = l_op_type;

Line: 371

SELECT routing_sequence_id, alternate_routing_designator,
       assembly_item_id
FROM BOM_OPERATIONAL_ROUTINGS bor
WHERE bor.ORGANIZATION_ID = current_org_id
AND bor.CFM_ROUTING_FLAG = 1;

Line: 378

SELECT routing_sequence_id, alternate_routing_designator
FROM BOM_OPERATIONAL_ROUTINGS	bor
WHERE bor.ORGANIZATION_ID = current_org_id
AND bor.ASSEMBLY_ITEM_ID = Item_id
AND bor.CFM_ROUTING_FLAG = 1
AND bor.LINE_ID = v_line;

Line: 386

SELECT DISTINCT bor.routing_sequence_id, bor.alternate_routing_designator
FROM BOM_OPERATIONAL_ROUTINGS bor,
BOM_OPERATION_SEQUENCES bos,
BOM_STANDARD_OPERATIONS bso
WHERE bor.ORGANIZATION_ID = current_org_id
AND bor.ASSEMBLY_ITEM_ID = Item_id
AND bor.CFM_ROUTING_FLAG = 1
AND bor.LINE_ID = v_line
AND bso.OPERATION_CODE = v_operation_code
AND bos.STANDARD_OPERATION_ID = bso.STANDARD_OPERATION_ID
AND bor.ROUTING_SEQUENCE_ID = bos.ROUTING_SEQUENCE_ID
AND bos.OPERATION_TYPE = l_op_type;

Line: 400

SELECT routing_sequence_id, alternate_routing_designator
FROM BOM_OPERATIONAL_ROUTINGS bor
WHERE bor.ORGANIZATION_ID = current_org_id
AND bor.ASSEMBLY_ITEM_ID = Item_id
AND bor.CFM_ROUTING_FLAG = 1;

Line: 423

        item_tab.DELETE;

Line: 514

           FND_FILE.PUT_LINE(FND_FILE.LOG,'Item/Item range NOT specified, selecting all items...');