APPS.WSMPCOGI SQL Statements

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

Line: 16

	SELECT bbom.alternate_bom_designator
	INTO   x_alternate_designator
	FROM   bom_bill_of_materials bbom,
               bom_inventory_components bic,
               wsm_co_products bcp
	WHERE  bcp.co_product_group_id = x_co_product_group_id
        AND    bcp.component_sequence_id = bic.component_sequence_id
        AND    bic.bill_sequence_id      = bbom.bill_sequence_id
        AND    rownum = 1;

Line: 53

  SELECT count (*)
  INTO   x_count
  FROM   wsm_co_products
  WHERE  co_product_group_id = x_co_product_group_id
  AND    co_product_id IS NOT NULL;

Line: 85

  SELECT bom_inventory_components_s.nextval
  INTO   x_result
  FROM   sys.dual;

Line: 118

        select component_sequence_id
        into   l_id
        from   bom_inventory_components
        where  bill_sequence_id = p_bill_sequence_id
        and    component_item_id = p_component_item_id
        and    operation_seq_num = p_operation_sequence_num
        and    effectivity_date = p_effectivity_date;

Line: 134

        select bic.component_sequence_id
        into   l_id
        from   bom_inventory_components bic,
		bom_bill_of_materials bom
        where  bom.bill_sequence_id = p_bill_sequence_id
	and    bic.bill_sequence_id = bom.common_bill_sequence_id
        and    bic.component_item_id = p_component_item_id
        and    bic.operation_seq_num = p_operation_sequence_num
        and    bic.effectivity_date = p_effectivity_date;

Line: 170

  SELECT concatenated_segments
  INTO l_item_name
  FROM mtl_system_items_kfv
  WHERE inventory_item_id = p_inventory_item_id
  AND   organization_id = p_organization_id;